SQL Compare 11.6 release notes
Published 09 M 2016
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