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

Activity overview

Latest activity by dvdchas

Excluding specific column names from all comparisons
For the past few years I've been working with several products that generate tables on top of Sql databases. These tables tend to have a 4 or 5 columns that are common to all tables, that include ...
2 followers 2 comments 0 votes
Choosing the Schemas to compare on the db selection screen
We have some fairly large databases here that are seperated by Schema. E.g. * hundreds of objects in Schema:dbo * thousands under schema:CADIS * thousands under schema:CADIS_SYS * thousands under ...
3 followers 3 comments 0 votes
Easter Egg
I see the Easter Egg in SQL Compare 5 has been upgraded from version 3. If you bring up the about screen and wait for about 30 secs, a picture of the Red gate team appears. However in version 5 yo...
2 followers 3 comments 0 votes
I've recently upgraded to the latest version of SQL Compare 5.2.0.32. We mainly upgraded for better compatibility with Sql Server 2005. I quite like a lot of the new features, things like the automatic storing of comparison projects etc. However there are a lot of things that seem worse to me. 1) The grouping of types of objects into:- a) Objects in both that existing in both but are different b) Objects that exist only in DB1 c) Objects that exist only in DB2 d) identical objects This feature which may look nice I find quite annoying. By default sql Compare assumes that you want to synchronise all objects. So after un-ticking a whole load of changes in one group, its easy to forget to check the other groups. I miss the good old list all objects together and sort by status. Can the grouping be optionally turned off. Also why do the group headings take up so much space? 2) The colour coding of differences between scripts. In the old version it would set the background colour of lines that were missing/new/or changes. However now it only colours the characters that are different. New/Removed bits only show with a small little arrow in the middle. I'd like to see an option to colour code the whole lines, maybe still highlighting actually changed characters with a slightly darker colour. 3) As well as the general creation Sql differences view, the old version let you see the portion of the Synch SQL in either direction (DB1 to DB2 or DB2 to DB1) E.g. the Alter scripts. The new version seems to have dropped this useful feature. 4) The synchronisation Wizard. The new version forces you to decide the direction of your changes before you sync. In the old version you would select what DB would receive the changes at the last minute. Now you have to use the slightly hidden "Actions -> Switch Comparison Direction". The new version makes it a lot clearer but why not have a shortcut on the wizard and also on the button bar. Note: I've just realised I can double can double click on the direction arrow to reverse things. Maybe a few option boxes or buttons would make this more obvious to the novice. 5) The new version seems to chew up a lot more of your screen real-estate. Things like the "Synchronisation direction" are always shown, even when I'm wanting to look at the detail of the changes. Can these things be hidden, or at least moved up to the top toolbar (abit like IE's toolbars allow) 6) The grouping in the SQL Differences, again the grouping headings take up a little bit to much screen space. The old version continued to use the normal face. Anyway thanks for producing such a great product and keep up the good work. Rob P.S. A final feature I'd quite like to see, on the activation code. We tend to rebuild machines here fairly often. Could there be an option to include a note against the activation details sent to Red Gate. This note could automatically populate with the machine name of the PC being activated. I appreciate this note couldn't really be trusted to be accurate. However it would be useful when it comes to asking Red gate what happened to all our activations. / comments
I've recently upgraded to the latest version of SQL Compare 5.2.0.32. We mainly upgraded for better compatibility with Sql Server 2005. I quite like a lot of the new features, things like the aut...
0 votes