Had to use version 11 today because of a show stopping bug (which I've reported), but 11 looks so much more user friendly and easier to use than 12. Can we possibly have a "retro" look and feel option for version 12?

Enable Transaction Isolation Option like in SQL Compare. In SQL Compare you can set the transaction level to one of five options. This is needed in SQL Data Compare to eliminate blocking.

The application "pauses" / freezes for several seconds after selecting columns to include. Very painful when making changes to a dozen or so tables.

Love the tool, but please solve this!

When a data compare completes, if a table has differences, I'd like to be able to view a summary showing the columns that differ and how may rows differ for each column.

I just did this by hand today, selecting one column at a time on a 6 million row, wide table. Took an hour. With a summary page it should take just one pass.

I think this would make the feature a lot more useful: the reason for this is that when you go into tables and views it compares FIRST, so if you wanted to change that setting then either you now have a bunch of tables to go and include that you wanted to add, or you now have to go find a bunch of tables that you didn't want to include and take them out.

In SQL data compare, If I have two schemas (dbo and test) in some database, and only map the test schema between the databases to be compared, when it comes to table selection, it shows all the tables in the dbo schema as unmapped. That is true, but I'd rather not have to see them. Suggestion: Hide the tables in unmapped schemas.

The WHERE clause for a table can contain WHERE, and this works fine for comparison, but when you generate a deployment script it errors because the update statement says

UPDATE table SET value = 1 WHERE keyfield = 1 AND ( WHERE keyfield = 1 )

Often I need to mark a set of changes where the changes are not all in the same (or visible) columns. As a result, using the down arrow to go to the next record skips a lot of records that I need to mark.

This "smart" feature doesn't seem to be very useful when I'm working like this - can we have an option to turn it off, so that the cursor keys work just as they would in Excel, without trying to take me to the next change?

Unless I'm missing it, there doesn't seem to be a way to select a default open mode in Data Compare (or SQL Compare) version 12. It always opens to a new Compare Project. Most of the time I'm working with saved projects so it takes extra steps to do what I want. Older versions of Data/SQL compare used to let you pick how you want to start the application.

In SQL Data Compare 11 you could see what values had changed as they were highlighted in the row compare view. Now they are all one colour. Can this be brought back?

There needs to be an option to untick all columns as running a comparison of a couple of columns over a table containing 80+ columns involves laboriously unticking 70+ columns.

An option to exclude columns dynamically from the comparison via the front screen, without having to go back into project options.

This would be helpful as it is common to make decisions about which columns to include\exclude based on the results of a comparison.

I've inherited a db that has 161 tables without a PK or anything that will allow the data comparison tool to compare the content of the tables. I was really hoping I could export a list of those tables to CSV so I could chop them up and divvy them out to my colleagues so we can quickly work through the addition of PK's Unique Indexes etc. order for the data compare tool to be useful going forward.

Excluding columns from data comprison with options to include them in the deployment script because we need these columns as placeholders

We have some users of SDC who are not able to upgrade to the latest version, and we would like to compare using the same project file for consistency and to prevent errors in duplicating changes. We find that SDC will get stuck in a loop or give errors if this happen. I assume this is a new feature, not a bug.

This applies to both Data and Schema compare. To increase timeout on a compare, one has to append "; Connect Timeout=60" to the server name. This is not obvious, and incorrectly populates SSMS when deploying using the generate script tool.

Include the ability to sync one side to the other so that rows that only exist on the target side will be deleted. Right now there's no way to delete unmatched rows on either side. In the file tool Beyond Compare, it's called Mirror to Left and Mirror to Right. http://www.scootersoftware.com/v4help/index.html?dir_sync_how_to_sync.html

This would be really handy for syncing across environments like dev and preprod.

Support universal authentication for azure sql database