SQL Toolbelt

Eine Sammlung von Tools zum Vergleichen, Synchronisieren, Sichern, Analysieren u.v.m. für SQL Server.

Veröffentlicht von Redgate Software
Wird von ComponentSource seit 2005 vertrieben

Preise ab: $ 3,148.20 4.00 Stern Durchschnittliche Bewertung4.00 Stern Durchschnittliche Bewertung4.00 Stern Durchschnittliche Bewertung4.00 Stern Durchschnittliche Bewertung4.00 Stern Durchschnittliche Bewertung (1)

i

Please note that SQL Toolbelt is only available to customers who already own a License and need to purchase additional licenses, or renew existing subscriptions.
If you do not already own SQL Toolbelt please consider Redgate Deploy or SQL Toolbelt Essentials as an alternative.

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.