I am currently using SQL Data Compare. When I ran it against one of our databases, with all tables it consumed all the space on C:. I am doing selections of tables at a time and it's still consuming more space on each run. If I restart it clears down the temp folder. any chance of clearing down at the start of each comparison?

In prior versions when a where clause was created for a table an icon appeared next to the table name indicating a where clause had been applied. The icon no longer appears and when working with multiple tables at once it can be difficult to remember which tables have a where clause applied to them without having to reopen the where clause screen.

This is actually a deal breaker for me, because I often am switching back and forth to get different tables in sync, and this adds a lot of time to the process. Please at least add an option for this, it really interferes with my work flow.

When in the xml project file a new table is not available and the table exists in the database sql datacompare now automatically compares this table.

For a lot of user tables this is not the expected behaviour.
It would be nicer, if the user can configure if 'unknown' tables will be automatically compared or not.

So please add a setting that new tables are not included in the compare automatically.

The Fast Deployment option has been removed from V12. Please add it back in.

When dragging the pane splitter with the mouse, the dark gray split bar draws about 25% up and to the left of where it should be.

Unlike old versions of data compare the screen that shows all the tables i can check and set a where clause on also shows the table mapping by default every time. I almost never look at the mapping screen because i'm comparing two identical databases all the time. Please minimize or hide this by default again.

Great products, couldn't live without them!

We maintain a lot of projects. I'd love to see some way that the projects can be organized into folders or a tree structure. At the moment the flat structure gets messy. Understand how you can save your projects in different folders in your file system..

Thanks

If a table has a unique constraint index on say the name column and the change is just sapping the names on the IDs. The script to update the names ends up failing because it causes a unique constraint violation, but if the index is disable, then the update runs, then the index is rebuilt the unique constraint does not cause a failure.

While browsing the improvements, I notice a whole set of ideas centered around the ability to filter data, providing support for data types that may have changed between stages in the database lifecycle (development to QA to production for instance), and the ability to filter columns, changing column names, etc.

All of this could be supported by providing custom SQL query support in SQL Data Compare.

The tool should provide for a custom comparison query for the source and destination table.

There is an PK defined as PRIMARY KEY CLUSTERED, this Key will not be found AS comparison Key in Version 12, in Version 11 OK

Usually We are only syncing data for lookup tables only. It would be nice to be able to filter out specific datatypes for Keys e.g. int, bigint usually not necessary.

It can be very useful to add an option for reading from a nuget package store, in addition to "Direct From Source Control" and "Scripts folder".
The package should be reached unsing the http url. This is useful when reading from a build server outcome, which can upload the packages to the nuget store.

Please consider adding the ability to sort the differences in a column to the top. In some tables we diff there are lots of changes to some columns we don't care about and we have to sort through thousands of results to see the differences in the columns we do care about.

It is very limiting that when clicking on the sort on the top of the columns it only sorts based on the data in the columns ascending or descending.

Display the source (when source control is the source) like you do in SQL Compare.
For example, in SQL Compare, you get the icon but underneath there is a URL to indicate which version you are linked to. In SQL Data Compare, there is JUST an icon.

It's extremely time consuming to have to go to each individual table to create a custom key for comparing tables. Even with the common option of holding Shift to select a range. I have databases with hundreds of tables, and not all have a PKey. It would be nice to have an option that automatically selects all columns on the Tables & Views tab. You could even offer other options to select certain columns, or other ad-hoc options, for what columns to use in the compare process.