Sometimes when copying data from server to server I need to change soemthing in the deployment script (e.g. replace a guid with another guid for a FK to work). Please allow editing the script before running it through Data Compare (currently I have to copy it, edit it and run it manually)

Currently, the Export CSV includes Matched and UnMatched field. It would be good to only see the UnMAtched Fields so quick action can be taken to fix it. It's especially painful when you have a table with a lot of fields and only a few are unmatched.

This feature is currently only available inside the tool. See https://us.v-cdn.net/6029854/uploads/editor/1m/d9ozpaupqkzc.jpg

Allow data from one source table to be mapped to 2 or more destination tables. Due to requirement changes we needed to split data from one table in to two separate tables but data compare will only map one source table to one destination table. Some data has to be duplicated on both tables and some belongs to one or other of the new tables.

Its great that you can tell if xml columns are diffierent. But please improve the ablity to view the doc and see the differences. Being able to save change would also be great.

Today, empty tables that have no rows appear in the list of "xxx tables or views with identical rows only". It would be more accurate to split this list into tables/views with data that are identical and table/views that are empty.

plz, add filtering object names by wildcards(* ?) in find box.
thanks...

It would be nice to have a quick way to send only the items I intend to process via a report. Currently in 13, I can only send everything.

Fix the page -- give us some indication on what is fixed and/or what enhancements are in the update so we know if it is worth installing or if we might as well wait until next update.

Yes its difficult to implement. And maybe not possible in all ways. But we have here really simple SQL 2 SQL Server Comparsions and enable the sync of timestamps would really helpful.

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.