What's new in SQL Compare 12.2

Support for temporal tables

In SQL Compare 12.2 we have added support for the comparison and deployment of temporal tables in SQL Server 2016.

SQL Compare 12 > SQL Compare 12.2 release notes > sql_compare_temporal_tables.png

This means you can include temporal tables when deploying changes and comparing differences to your SQL Server databases. You can see what’s changed in your current table, plus what will be added to the history table. When you are ready to deploy, the script will include the expanded temporal table:

SQL Compare 12 > SQL Compare 12.2 release notes > sql_compare_temporal_tables_deployment_script.png

We’ve also added a handy warning that lets you know if you are deploying to an older version of SQL Server that doesn’t support temporal tables:

SQL Compare 12 > SQL Compare 12.2 release notes > sql_compare_temporal_tables_deployment_warning.png

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

Fixed an issue where it was possible to select revision history for version control systems that do not support revision history
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
SC-9357: SQL Server 2016's MIN_GRANT_PERCENT and MAX_GRANT_PERCENT syntax is now recognized
SC-9365: SQL Server 2016's OPTION (USE HINT(..)) syntax is now recognized

12.2.3.4239 - March 27th 2017

FREQUENT UPDATES RELEASE

Features

SQL Compare now has an IgnorePerformanceIndexes option to ignore all indexes except primary keys and unique constraints.

Fixes

SC-9208: When loading snapshots, the project's case sensitivity option is now used (rather than the one stored in the snapshot)
SC-9349: When a deployment adds GENERATED ALWAYS columns to a table, PERIOD FOR SYSTEM_TIME is now set on the table too
SC-9368: log messages containing curly braces (e.g. if SQL objects have curly braces in their name) no longer cause FormatException to be thrown

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

SC-9271: Errors thrown by sp_addextendedproperty are now handled correctly in deployment scripts
SC-3932: Interactive HTML Reports now escape forward slashes in object names and descriptions
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

12.2.0.4045 - February 22nd 2017

FREQUENT UPDATES RELEASE

Features

SQL Compare now supports temporal tables on SQL Server 2016.

Fixes

SC-9207: Fixed a bug where the end of a temporal SELECT statement would disappear from a textual object definition
SC-9274: Roles can now contain roles having the same name as a user
SC-9265: Fix an issue that the Deploy button could be incorrectly enabled or disabled
SC-9178: Made the Create Database dialog more responsive