SQL Compare 14.0 release notes
Published 21 August 2019
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
/logsdirectory
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
