SQL Data Compare 12.1 release notes
Published 15 December 2016
What's new in SQL Data Compare 12.1
My projects
In response to a lot of feedback we have received since the release of SQL Data Compare 12, we have brought back the familiar 'my projects' dialog from SQL Data Compare 11:
The new dialog allows you to view the details of the source and target for each project as well as when it was last modified. The list of projects can be filtered using the search box in the top-right corner.
The new dialog is accessible from the File menu under My projects and, by checking the box at the bottom of the dialog, it can also be made to appear when the application starts up.
Hide identical columns
SQL Data Compare 12.1 adds the ability to toggle the display of identical columns in the data difference viewer. Columns whose data is identical in both the source and target can be shown and hidden by checking and un-checking the Show identical columns option:
In the above example, un-checking Show identical columns will hide the firstName and age columns:
This feature makes it easier to see differences when there are only a few columns of interest.
Improved update notifications
When updates are available for SQL Data Compare you will now see a notification banner within the product. This will make it easier to know when updates have been released and what features have been added.
The new banner provides details about the features and fixes included and allows installation of the update. If you wish to update at a later date, or to skip an update these options are available from the Remind me drop down.
12.1.6.3982 - February 13th 2017
FREQUENT UPDATES RELEASE
Features
- Added an option to include or exclude new tables by default
12.1.5.3927 - February 6th 2017
FREQUENT UPDATES RELEASE
Fixes
- SC-9197: Support registering databases with users that have the permission ALTER ANY EXTERNAL DATA SOURCE
- SDC-2242: Do not overwrite non .csv files when exporting CSV reports; add an option to overwrite existing files in the directory being exported to
12.1.4.3873 - January 17th 2017
FREQUENT UPDATES RELEASE
Fixes
- SC-9153: SQL Data Compare will no longer display an error when loading a project using SQL authentication where the 'Save Password' box has not been checked.
- SC-9190: Fixed some checkboxes which were invisible in some cases
12.1.3.3849 - January 16th 2017
FREQUENT UPDATES RELEASE
- Support sorting the results grid in ascending as well as descending order
- SDC-2241: Improved behaviour of checkboxes on high DPI screens
- SOC-8281: Fixed a casting error when deploying data to Azure
12.1.2.3823 - January 9th 2017
FREQUENT UPDATES RELEASE
Features
- SQL Server vNext on Linux is now supported.
- SQL Data Compare SSMS extension now supports latest version (v17.0 RC1) of SQL Server Management Studio
Fixes
- SDC-2239: Fixed a crash when sorting the results by object type
- SC-9160: SQL Data Compare now no longer allows showing multiple create database dialogs
- Fixed a bug where swapping databases in the Edit Project dialog could cause SQL Source Control revision numbers to be associated with the wrong database
12.1.1.3793 - January 4th 2017
FREQUENT UPDATES RELEASE
Fixes
- SDC-2232: Improved SQL Data Compare performance when selecting or deselecting large numbers of tables in the mappings UI
- SDC-2237: Deployment scripts are now correctly split into multiple transactions based on your "max transaction / batch size" setting
12.1.0.3760 - December 19th 2016
Features
- The data difference viewer can now be made to hide columns that are identical in the source and target.
Fixes
- SDC-2233: SQL Data Compare will no longer hide the top-level checkbox in the table mappings UI when sorting by that column
- SC-9156: The new My Projects dialog will now correctly load projects which specify a SQL Source Control data source
