SQL Compare 12

SQL Compare 12.3 release notes

What's new in SQL Compare 12.3

Option to ignore performance indexes

SQL Compare 12.3 contains a new option to allow more control over what types of indexes are deployed. The "Ignore performance indexes" option will only deploy indexes created by unique constraints, primary keys, and foreign keys. This will allow the deployment of structural keys and indexes without impacting indexes that have been added to improve performance.

Select a Git revision as a data source

When using the SQL Source Control data source it is now possible to compare to a historical git revision.

This feature requires SQL Source Control 5.5.4 or later

12.3.3.4490 - May 8th 2017

Features

  • The "My Projects" window can now be opened from the toolbar

Fixes

  • When using the SQL Source Control data source and comparing custom-linked databases, the revision fields are now correctly disabled.
  • SC-9399: When using the SQL Source Control data source, progress updates will now be displayed while the requested revision of the scripts folder is being checked out.
  • Changes to a comparison report's name will now be correctly used if the report is generated while the "name" field still has focus.
  • SC-9433: Fixed a bug which could prevent the sqlcompare.exe commandline from recognising /options:IgnoreIndexes in some deployment cases.

12.3.2.4426 - April 26th 2017

FREQUENT UPDATES RELEASE

Fixes

  • SC-9392: Fixed an issue where filters could be loaded into the filter panel multiple times.
  • SC-9393: GENERATED ALWAYS columns can now be added to tables even when the 'use object existence checks' option is set
  • SC-9363: Fixed a bug where SQL Compare could fail to create a filtered index if another object had been created with SET ANSI_NULLS OFF earlier in the deployment script

12.3.1.4383 - April 12th 2017

FREQUENT UPDATES RELEASE

Fixes

  • Fixed a silent crash on start up that could occur when upgrading from SQL Compare 12.2.3 or 12.2.4

12.3.0.4373 - April 10th 2017

FREQUENT UPDATES RELEASE

Features

  • Interactive HTML reports now include the last modification date of each object
  • SQL Compare can now register SQL Server vNext backups and scripts folders

Fixes

  • SC-9339: The size of the My Projects dialog is now saved between sessions


Didn't find what you were looking for?