I currently cut-paste each side into Visual Studio and save them as separate files and then use WinMerge to view the diffs. It would be so much more efficient if I could view the diffs natively.

Even when not in active use. SQL Data Compare is constantly using CPU and memory. When minimized or in the background it should be idle

If you have a lot of table mappings in addition to the tables that do map, you cannot see all the table mappings.

I have 61 tables mapped and 54 tables that are not mapped. I cannot map the tables because I cannot scroll far enough down the list to find a matching table.

We use data compare to run a sync of lots of data across many tables all linked to a specific organization in a multi-tenant db.
It would be great to be able to define a variable at the project level, e.g. InstanceID, then be able to set a sql comparison to InstanceID = [InstanceID] (or @InstanceID). That way we could copy a project and just edit the InstanceID instead of going into 30 definitions and changing every ID. Would be most useful as a simple text replace, so we could use "between 1 and 2" or like 'abc%'.

I'm having some column with data in the source <NULL> and in the destionation "000000" which are equal for functionality. Unfortunately I cannot add a seperate 'function' like you have a WHERE in SQL or a predicate / LINQ in C# to say these are equal.

This way I have to manually check all 35.000 rows, instead of a much less set or records.

Thanks in advance.

If i compare 2 tables with same name in same schema the title does not display which data come from which source.

I don't see why the tables have to reside in different databases, backup, source control, or scripts folder in order to run SQL Data Compare.

It wouldn't be much fuzz to add the ability to compare two tables regardless (i.e. in the same database). Sometimes I just need to divide the common traits from the differences, in order to plan some work.

When I compare (with redgate) the TFS code and the database it would be nice to see when that code was checked in.

Allow us to delete projects from the My Projects screen.

The different sections of the SQL Data Compare deployment script run together visually (e.g, disabling constraints, delete/update/insert records, re-enabling constraints). Comment lines like this would make the script more understandable at a glance (and easier to review):

/**************************************************** Suspend Constraints ****************************************************/

Currently, we have to manually edit every SQL Data Compare deployment script to add a USE <DB> statement at the top. We would like to see an option in the tool like SQL Compare has.

Since I don't have the permissions to do actual higher-level promotions myself, I usually ask the admin to send me back the results of my changes. One thing that helps me is adding an OUTPUT clause to my DML queries so I can see that the result matches my expectations.

Once an SQL Data Compare project is run, these steps have to be executed:

1. Click the "Deploy" button
2. Click "Next" (with default "Deploy using Data Compare" with all three option unticked)
3. Click "Deploy Now" (without saving or copying the script)
4. Click "Deploy Now" from the confirm deployment popup.

It would be so much more efficient if we could go straight to a deployment without having to do these steps EVERY time

When SQL Compare generates the synchronization script for text columns with multiple lines, it adds an extra space character at the end of each line, so CR+LF becomes ' '+CR+LF. As a result, the values still show up in the list of differences after synchronization.

This looks like a bug that needs to be fixed.

Would like to see a counter for the time that it takes to complete a data compare between databases.

Please provide ability to compare system tables -- need ability to compare jobs between servers

Hi, I am using SQL Data Compare and I faced a minor issue as following. after I compared two databases, and selected some differences to deploy using Down arrow and Space button in keyboard I did not use mouse. Then clicked Deployment Wizard button but it showed a message asking me to select differences, however many differences are selected.