SQL Compare 14

SQL Compare 14.0 release notes

What’s new in SQL Compare 14.0 

Linux command line support (beta) 

The SQL Compare 14.0 command line is now available for Linux, allowing users to access core SQL Compare functions whether they choose to work on Linux or Windows. This removes complexity and increases user choice, and is part of Redgate’s ongoing commitment to widen access to its tools and enable developers to work effectively across multiple environments. Linux support is currently in beta.

The SQL Compare 14.0 command line for Linux is available as a Docker container through Docker Hub. See using the command line on Linux for more information.

SQL Server 2019 support 

SQL Compare 14.0 comes with full support for the forthcoming SQL Server 2019 release, meaning users will be able to access its new features. 

.NET Framework

SQL Compare now requires .NET Framework 4.7.2.

Removed features in SQL Compare 14

SQL Server 2005 support.

14.0.7.13517 - October 21st 2019

Fixes

  • SC-10677: Now avoids stack overflow with heavily nested computed columns more stringently. Some computed columns may show a syntax-only difference between live and scripts databases if they couldn't be parsed; this can be fixed by deploying the live version to the scripts folder.
  • SC-10666: The IsSQLCloneDatabase extended property no longer appears in comparisons, so that it can't be accidentally deployed to non-clone databases
  • SC-10682: Sorting the grid by Last Modified date now works correctly
  • SC-10642: When comparing expressions, parser timeouts now cause the comparison to fall back to a raw text comparison instead of throwing an error

14.0.6.13387 - October 14th 2019

FREQUENT UPDATES RELEASE

Features

  • Enabled sharing of recently used servers with other Redgate products

Fixes

  • SQL Compare no longer drops and recreates foreign key constraints when the only change to the referencing column is its nullability, sparseness, default value, or bound rule

14.0.5.13297 - October 7th 2019

FREQUENT UPDATES RELEASE

Fixes

  • SC-10056: Server combobox in the live database connection form now correctly updates when clicking the swap sides button
  • SC-10650: When dropping a primary key on a table with disabled non-clustered indexes, SQL Compare now warns you that SQL Server will automatically re-enable the non-clustered indexes

14.0.4.13251 - October 2nd 2019

FREQUENT UPDATES RELEASE

Fixes

  • Mode 80 and 90 databases now act as if they were SQL Server 2008 databases when Use Compatibility Level option is on, and as the underlying server version when it is not.
  • SC-10661: Roles and domain users with the same name no longer have their role memberships confused when reading from a scripts folder
  • The order of columns in statistics is now consistently correct

14.0.3.13106 - September 23rd 2019

FREQUENT UPDATES RELEASE

Fixes

  • Command line on Linux now logs to the /logs directory

14.0.2.13006 - September 16th 2019

FREQUENT UPDATES RELEASE

Fixes

  • SC-10653: Fixed the dialog to select a previous revision when comparing with a SQL Source Control source. Note you need to update SQL Source Control to 7.0.40 or later for this fix to work.

14.0.1.12901 - September 9th 2019

FREQUENT UPDATES RELEASE

Features

  • Server retrieval in connection dialog now retrieves local server instances more comprehensively

Fixes

  • SC-10651: Indexes with changes on temporal tables are no longer dropped twice

14.0.0.12866 - September 4th 2019

Features

  • SQL Compare now supports SQL Server 2019
  • The SQL Compare command line is now available for Linux

Fixes

  • SC-10642 - SQL Compare falls back to not normalising brackets for very large computed columns rather than failing with a parser timeout

Didn't find what you were looking for?