SQL Compare 12.2 release notes
Published 22 February 2017
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.
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:
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:
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
