SQL Compare 14

Help for older versions available.

These pages cover SQL Compare 14, which is not the latest version. Help for other versions is also available.

SQL Compare 14.4 release notes

14.4.23.18321 - February 22nd 2021

FREQUENT UPDATES RELEASE

Fixes

  • ZD-245196: Deploying a full text catalog along with its owner will no longer duplicate the CREATE USER statement
  • SC-10963: The /makescripts option on the command line no longer writes out migration blocks metadata for non-migration blocks databases

14.4.22.18256 - February 15th 2021

FREQUENT UPDATES RELEASE

Fixes

  • SC-10959: SQL Compare now properly handles temporal tables on partition schemes

14.4.21.18202 - February 8th 2021

FREQUENT UPDATES RELEASE

Internal library updates

14.4.20.18129 - February 1st 2021

FREQUENT UPDATES RELEASE

Internal library updates

14.4.19.18070 - January 25th 2021

FREQUENT UPDATES RELEASE

Internal library updates

14.4.18.17935 - January 18th 2021

FREQUENT UPDATES RELEASE

Fixes

  • SC-10308: Renaming a column included in a temporal table primary key will no longer produce an invalid deployment script

14.4.17.17847 - January 11th 2021

FREQUENT UPDATES RELEASE

Fixes

  • ZD-242682: Deploying a memory optimized table type will now longer ignore indexes when the option is set

14.4.16.17770 - January 5th 2021

FREQUENT UPDATES RELEASE

Fixes

  • SC-10950: Extended properties representing sensitivity classifications are now treated as sensitivity classifications on versions of SQL Server that support the ADD SENSITIVITY CLASSIFICATION syntax
  • Fix a crash when opening the Server dropdown in SQL Snapper

14.4.15.17626 - December 14th 2020

FREQUENT UPDATES RELEASE

Fixes

  • External tables are no longer erroneously registered as regular tables
  • SC-10945: Role members are now sorted in the SQL view

14.4.14.17548 - December 7th 2020

FREQUENT UPDATES RELEASE

Compatibility with SQL Data Compare 14.4.14.17548

14.4.13.17493 - November 30th 2020

FREQUENT UPDATES RELEASE

Fixes

  • SC-10946: Security policies now respect the "Add object existence checks" option

14.4.12.17429 - November 25th 2020

FREQUENT UPDATES RELEASE

Compatibility with SQL Data Compare 14.4.12.17429

14.4.11.17350 - November 16th 2020

FREQUENT UPDATES RELEASE

Internal library updates

14.4.10.17174 - November 3rd 2020

FREQUENT UPDATES RELEASE

Compatibility with SQL Data Compare 14.4.10.17174

14.4.9.17070 - October 26th 2020

FREQUENT UPDATES RELEASE

Fixes

  • SC-10928: Fixed regression where static data could not be deployed to a table referenced by a system named foreign key.
  • SC-6959: Comparing spatial indexes no longer gives false differences.

14.4.8.17007 - October 19th 2020

FREQUENT UPDATES RELEASE

Internal library updates

14.4.7.16962 - October 12th 2020

FREQUENT UPDATES RELEASE

Fixes

  • SQL Compare now generates correct update script when changing data type of PK column of temporal table

14.4.6.16906 - October 5th 2020

FREQUENT UPDATES RELEASE

Fixes

  • SC-10919: Improved handling of SQL SET statements in scripts folders
  • SC-4733: When the Ignore Permissions option is enabled, and a table is rebuilt, SQL Compare now restores its original permissions rather than deploying its original permissions

14.4.5.16856 - September 28th 2020

FREQUENT UPDATES RELEASE

Internal library updates

14.4.4.16824 - September 23rd 2020

Fixes

  • Static data differences are now correctly shown in the command line list of differences when using /include:staticdata

14.4.3.16779 - September 16th 2020

FREQUENT UPDATES RELEASE

Fixes

  • SC-10907: Amended script order when adding an IDENTITY field to a temporal table.
  • SCA-2749: When comparing a scripts folder using /include:staticdata, SQL Compare Command Line will no longer compare data for tables without static data defined.

14.4.2.16694 - September 7th 2020

FREQUENT UPDATES RELEASE

Fixes

  • SC-10906: SQL Compare no longer tries to recreate an existing clustered columnstore index when a column's datatype is modified

14.4.1.16663 - September 2nd 2020

FREQUENT UPDATES RELEASE

Fixes

  • ZD-166228: Fixed "SQL Change Automation scripting error"

14.4.0.16632 - August 24th 2020

FREQUENT UPDATES RELEASE

Fixes

  • Improved consistency between command line and UI behaviours

Didn't find what you were looking for?