Released: Mar 21, 2016

Updates in this release

Updates in 11.5

New Features

• SQL Compare now connects to SQL Server 2016 RC0.
• SQL Compare now has a SHA-256 digital signature.
• SQL Compare now reads tables and indexes more quickly, especially those in schemas with many partitions. Applies to SQL Server 2005 and onwards, as well as Azure V12.

Fixes

• SC-7985: SQL Compare no longer errors on registration when attempting to decrypt objects on low compatibility level databases.
• SQL Compare no longer adds some blank lines or redundant GOs when deploying to a scripts folder.
• SQL Compare no longer double-escapes 'UNKNOWN' when being unable to read an object name from a CLR assembly.
• Trial licences will no longer expire instantly if upgrading from a previous version.
• SC-8341: SQL Compare no longer drops differing indexes while 'Ignore Indexes' is selected, unless the index needs to be dropped to implement a requested table change.
• SC-8324: SQL Compare now successfully compares permissions on Sequence objects.
• SC-8138: Asymmetric keys with NA algorithm (e.g. from hardware EKM) no longer cause comparison to fail.
• SQL Compare no longer adds some blank lines or redundant GOs when deploying to a scripts folder.
• SC-8349: SQL Compare can now compare DEFAULT namespaces in selective XML indexes.
• SC-8337: SQL Compare no longer rebuilds views due to full text index changes.
• SDC-1816: no longer crashes on startup if your MSI installed locations are corrupted or missing.
• SC-8327: SQL Compare no longer treats DUMP as a reserved keyword.
• SC-8218: SQL Compare now correctly scripts out computed columns that use the PARSE and TRY_PARSE functions.
• SC-8313: SQL Compare no longer fails to register Azure v12 databases that have been upgraded around 25th February 2016.
• SC-8224: SQL Compare can now compare partition functions that have NULL values cast to a data type. For example, the value CAST(NULL AS DATE).
• SC-8229: SQL Compare now restores CLR function permissions when rebuilding the function's assembly.
• SQL Compare can now register repositories from SQL Source Control when the SQL Source Control 5 Beta is installed.