11.6.11.2463 July 18th, 2016

Note: Version 11.6.11 rolls up all of the changes from frequent update versions 11.6.3 to 11.6.11 - if you want to receive these kinds of updates more quickly in future, you should turn on Frequent Updates.

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.

11.6.10.2352 July 11th, 2016

FREQUENT UPDATES RELEASE 

Fixes 

• SC-8777: Data compression differences now picked up when Ignore filegroup, partition scheme and partition function option used

11.6.9.2306 July 6th, 2016

FREQUENT UPDATES RELEASE 

Fixes

• SC-8735: Default values for parameters of type BINARY can now be registered from live databases

11.6.7.2123 June 20th, 2016

FREQUENT UPDATES RELEASE 

Fixes

• SC-4447: Default parameters no longer cause an overflow exception for large (>3.4E38) values

11.6.6.2054 June 13th, 2016

FREQUENT UPDATES RELEASE 

Fixes

• 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

11.6.5.1976 June 6th, 2016

FREQUENT UPDATES RELEASE 

Fixes

•  SC-8665, SC-8392: System functions added in Sql Server 2016 are no longer escaped when deploying to a scripts folder

11.6.3.1926 - June 1st, 2016

Note: Version 11.6.3 rolls up all of the changes from frequent update versions 11.5.0.397 to 11.6.3 - if you want to receive these kinds of updates more quickly in future, you should turn on Frequent Updates.

Features

• SQL Compare now accepts the ALTER DATABASE CURRENT syntax

• SQL Compare now connects to SQL Server 2016 RTM.
• New product switcher - accessible from the product logo top-left

Fixes

• 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

11.6.2.1799 - May 23rd, 2016

FREQUENT UPDATES RELEASE 

Fixes

• SC-8632: SQL Compare no longer treats change_tracking_current_version as a column name in constraints

11.6.1.1686 - May 16th, 2016

FREQUENT UPDATES RELEASE 

Fixes

• 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

11.6.0.1493 - May 9th, 2016

FREQUENT UPDATES RELEASE 
Features

• 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-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