How can we help you today? How can we help you today?

Some user interface shortcomings and suggestions.

Features gone in the differences pane:
The possibility to immediately see the synchronization SQL by clicking a button is gone. Now you have to invoke the context menu.

Also gone the line viewer button to compare long lines easier, you have to invoke the context menu now.

A new but unnecessary feature in the difference pane are the three buttons controlling the heigth of the pane. It is more convenient to simply use the splitter bar to control the height to any size (instead only three sizes). Instead I would like to get back the font size buttons and the synchronization script button.

What I'm really missing in the difference pane (and all other panes holding T-SQL code) are my syntax coloring schemes, that I used in Query Analyzer formerly and Management studio now. It would be very agreeable if you could import the syntax coloring settings from Management Studio. (The loud and glary color of the system functions is a real pain in the eyes, also the loud red of the strings.)

The shortcut keys are shown on the menues, but should also be repeated on the tooltips of the toolbar buttons (not only on the two leftmost buttons).

The settings dialogs are not resizeable. Some dialogs (like the project dialog) promises to be resizeable, because the cursor changes to the left-right-arrow when dragged over the dialog's edge, but the promise is not kept.

On step 2 of the Synch Wizard (Review dependecies), the Objects-effected-list gets greyed when you uncheck the "Synchronize-all-dependencies-checkbox" which is ok. But when this checkbox is already unchecked due to a prior pass-by, this list is not greyed (as is was in version 7), which is an optical disruption and makes you feel inquiet (you don't feel sure that the dependencies will not be synchronized).

On step 3 of the Synch Wizard (Review script), I would appreciate that the Summary tab would be the topmost, since this is the most import one which gives you a quick clue what is changed. When you feel incomfortable about what is done, you still can investigate the Script more closely by clicking the Script button.

The warning tab on the same dialog sometimes alerts about circular dependencies. Until now I was never able to figure out which dependencies SQLCompare found, so it would be very helpful when this circular dependencies would be more detailed.
franz
0

Comments

6 comments

  • Simon C
    Thanks for your feedback;
    with regards to the SQL Differences pane, we generally discourage people from using the single object synchronization script, as it lacks any sort of dependency or warnings. The synchronization wizard is the best way of actually synchronizing objects, hence why we made the single object script slightly harder to get to. In the final product, the single object sync script will appear in it's own window, rather than in the bottom pane.

    In the final product, there will be a 'Show' button on the left side of the top bar that has pops up a context menu with options to show the line numbers/differences/collapsible regions, would this be sufficient? The idea of removing icons from that panel was to make it a lot cleaner & less cluttered; has this worked, in your opinion?

    The syntax colouring shouldn't have changed from previous versions; can you give examples as to what is different?

    The project dialog shouldn't be resizable; the resizable widget will be gone in the final version.

    The dependencies greying out is indeed a bug, that I've just checked in a fix for :D

    Any other comments you have, positive or negative, especially on the filtering and switch/sync direction, would be greatly appreciated

    Simon C
    Simon C
    0
  • franz
    Simon, you are right, the syntax coloring of the T-SQL panes did not change from version 7.

    What I would like is the possibility to define your own colourings as you can do in MSSMS (Tools | Options... | Fonts and Colors). Or even better, importing the colouring from the Management studio.
    franz
    0
  • David Atkinson
    franz wrote:
    A new but unnecessary feature I would like to get back the font size buttons.

    Can I ask you which of four sizes you use regularly? Do you use this feature to make your font larger or smaller?

    Does anyone else use the font size buttons in SQL Compare 7? If so, we'd love to hear your opinion on which sizes would be most useful.

    Thanks,

    David Atkinson
    Red Gate Software
    David Atkinson
    0
  • franz
    David, the size font I use depends on size of the script. For moderate sized scripts I use the default (2nd A from the left), for large scripts the smallest (leftmost) one.
    franz
    0
  • David Atkinson
    So you just use the two sizes? Is the small size good, or would you prefer it to be larger or smaller?

    David
    David Atkinson
    0
  • franz
    David, usually I use the default size (2nd A from left), for big scripts the smalles (1st A from left).
    I never used the biggest and second-biggest font ever.

    Simply put, leave the button arrangement on the SQL Differences pane as it was with version 7.
    franz
    0

Add comment

Please sign in to leave a comment.