Released: Jul 18, 2016

Updates in this release

Updates in SQL Compare 11.6

Features:

• Now accepts the ALTER DATABASE CURRENT syntax.
• Now connects to SQL Server 2016 RTM.
• New product switcher - accessible from the product logo top-left.
• Now deploys migrations created in SQL Source Control 5 Release Candidate.
• Migrations created with the SQL Source Control 5 Beta are no longer supported.

Fixes:

• SC-8668: SQL Compare no longer generates incorrect creation script for objects using WITH ENCRYPTION option when AS keyword not specified.
• SC-8421: Dependencies now correctly calculated from ALTER SCHEMA statements.
• SC-8777: Data compression differences now picked up when Ignore filegroup, partition scheme and partition function option used.
• SC-8735: Default values for parameters of type BINARY can now be registered from live databases.
• SC-4447: Default parameters no longer cause an overflow exception for large (>3.4E38) values.
• SC-8353: Compare no longer forgets to add columns when rebuilding a fulltext index on a view.
• SC-8671: Compare now correctly scripts out computed columns that call functions with DEFAULT parameters.
• SC-8702: Users are now regarded as equal if they are Windows principals on different domains.
• SC-8665, SC-8392: System functions added in Sql Server 2016 are no longer escaped when deploying to a scripts folder.
• Trial licences will no longer expire instantly if upgrading from a previous version.
• SQL Compare now detects that a table is dependent on a function when the function is used in a check constraint.
• 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.
• SC-7985: SQL Compare no longer errors on registration when attempting to decrypt objects on low compatibility level databases.
• SC-8060: SQL Compare no longer fails to register scripts folders containing DML triggers that reference an XML schema collection.
• SC-8098: SQL Compare now registers STATISTICS_INCREMENTAL=ON from script folders.
• SC-8138: Asymmetric keys with NA algorithm (e.g. from hardware EKM) no longer cause comparison to fail.
• SC-8140: SQL Compare now adds extended properties to sequences in script folders correctly.
• SC-8218: SQL Compare now correctly scripts out computed columns that use the PARSE and TRY_PARSE functions.
• SC-8302: objects with "\u" in their name no longer produce an invalid interactive HTML report.
• SC-8313: SQL Compare no longer fails to register Azure v12 databases that have been upgraded around 25th February 2016.
• SC-8324: SQL Compare now successfully compares permissions on Sequence objects.
• SC-8327: SQL Compare no longer treats DUMP as a reserved keyword.
• SC-8337: SQL Compare no longer rebuilds views due to full text index changes.
• 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-8349: SQL Compare can now compare DEFAULT namespaces in selective XML indexes.
• SC-8476: SQL Compare now successfully compares comments that are directly after the object name.
• SC-8481: Migrations beta now works with TFS server workspaces and other sources containing readonly files.
• SC-8482: SQL Compare now correctly adds columns to pre-existing Full Text Indexes when transactions are disabled.
• SC-8524: support hardware crypto devices (e.g. nCipher) for asymmetric key encryption.
• SC-8632: SQL Compare no longer treats change_tracking_current_version as a column name in constraints.
• SDC-1356: Fixes a crash related to extremely large deployment scripts.
• SDC-1816: no longer crashes on startup if your MSI installed locations are corrupted or missing.
• SOC-5919: SQL Compare now respects options (eg 'Case sensitive object definition' and 'Ignore whitespace') when comparing extended property string values.
• SC-8632: SQL Compare no longer treats change_tracking_current_version as a column name in constraints.
• SDC-1356: Fixes a crash related to extremely large deployment scripts.
• SOC-5919: SQL Compare now respects options (eg 'Case sensitive object definition' and 'Ignore whitespace') when comparing extended property string values.
• SC-8060: SQL Compare no longer fails to register scripts folders containing DML triggers that reference an XML schema collection.
• SC-8476: SQL Compare now successfully compares comments that are directly after the object name.