These pages cover SQL Data Compare 12, which is not the latest version. Help for other versions is also available.
SQL Data Compare 12.2 release notes
Published 22 February 2017
What's new in SQL Data Compare 12.2
Support for temporal tables
In SQL Data Compare 12.2 we have added support for the comparison and deployment of current data between temporal tables in SQL Server 2016.
SQL Data Compare hides the GENERATED ALWAYS columns, as these contain insertion timestamps and can not be deployed:
Choose whether to include newly added tables
SQL Data Compare now includes an option to include tables that were created in your database since your SQL Data Compare project was saved.
12.2.4.4299 - March 30th 2017
FREQUENT UPDATES RELEASE
Features
- SC-9066: It is now possible to compare to a historical git revision (Requires SQL Source Control 5.5.4 or later)
Fixes
- SDC-2483: Individual cells in the Data Compare differences grid are now highlighted only when they contain a difference.
- SC-9374, SC-9376: Choosing 'HEAD' as the source control revision no longer causes a 'Value cannot be null' error in the UI or command line
12.2.3.4239 - March 27th 2017
FREQUENT UPDATES RELEASE
Compatibility with SQL Compare 12.2.3.4239
12.2.2.4140 - March 13th 2017
FREQUENT UPDATES RELEASE
Features
- SC-9338: The My Projects dialog will now remember the previous sort ordering
Fixes
- SDC-2448: Improved warning messages around referential integrity.
- SC-9204: Filenames are no longer truncated in the deployment wizard when updating a scripts folder
- SC-8944: Improved the title bars of various dialogs in high DPI mode
12.2.1.4077 - March 6th 2017
Features
- When trialling SQL Compare you will now be asked to create a Redgate ID. Please see https://www.red-gate.com/user-licensing for details.
Fixes
- SC-9177: Preserve changes to column widths in the My Projects dialog
- SDC-2424: CSV export settings are now applied to individual rows, not the whole table
12.2.0.4045 - February 22nd 2017
FREQUENT UPDATES RELEASE
Features
- Data Compare can now deploy the current state of data in temporal tables on SQL Server 2016.
Fixes
- SDC-2451: Temporary files are no longer left on disk at application exit
- SDC-2454, SDC-2382, SDC-2286, SDC-2420: Fixed a crash when selecting multiple tables at once for deployment
- SDC-2221: When loading old projects, new tables will be mapped unless "clear all" had been performed
- SDC-2243: Allow the mapping of tables sharing a name in different schemas
- SDC-2423: Fix an issue causing inconsistencies when hiding identical columns in the changes grid.
- SC-9265: Fix an issue that the Deploy button could be incorrectly enabled or disabled
