SQL Compare 11.6 updated in SQL Toolbelt

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.