SQL Compare 11.6

Adds support for SQL Server 2016.
Août 25, 2016
Nouvelle Version

Fonctionnalités

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

Correctifs

  • 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.
SQL Compare 11.6
SQL Compare

SQL Compare

Comparez et synchronisez les schémas de bases de données SQL Server.

Demander devis Acheter maintenant

Vous avez une question ?

Discutez en direct avec l'un de nos spécialiste des licences Redgate Software .