SQL Compare 12

SQL Compare 12.2 release notes

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

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

Didn't find what you were looking for?