SQL Compare 13

SQL Compare 13.1 release notes

What's new in SQL Compare 13.1 

Improved HTML report generation

Comparison reports generated in SQL Compare now have the modern look and feel of the reports you may have seen in ReadyRoll and DLM Automation.

13.1.7.5470 - December 11th 2017

FREQUENT UPDATES RELEASE

Compatibility with SQL Data Compare 13.1.7.5470

13.1.6.5463 - December 5th 2017

Fixes

  • SC-9683: Fixed display of warning message text, which was invisible for some .NET 4.7 users
  • SC-9400: Provided a mechanism to avoid stack overflow errors when parsing deeply nested elements in SQL.
  • SC-9822: SQL Compare now deploys column constraint text containing chained function calls correctly.
  • SC-9266: SQL Compare can now compare and deploy functions with NATIVE_COMPILATION
  • SC-9811: SQL Compare now handles creation of clustered indexes on a user-defined history table.
  • SC-9831: SQL Compare now handles method calls immediately following a COALESCE statement.
  • SQL Compare Command Line now runs in 64-bit mode by default

13.1.5.5427 - November 27th 2017

Fixes

  • SC-9770: The SQL Compare parser now accepts NATIVE_COMPILATION syntax in CREATE FUNCTION statements.

13.1.4.5418 - November 20th 2017

Fixes

  • SC-9813: SQL Compare now respects the IgnorePermissions option for objects created in a deployment script.

13.1.3.5405 - November 14th 2017

Fixes

  • SC-9793: SQL Compare handles errors with a null stacktrace
  • SC-9776: SQL Compare no longer attempts to deploy FULLTEXT indexes twice when CHANGE_TRACKING is enabled.
  • SC-9798: SQL Compare again correctly identifies mapped tables over multiple schemas.
  • SC-9802: SQL Compare doesn't attempt to duplicate constraints between a history table and temporal table when reading from a scripts folder.

13.1.2.5327 - October 30th 2017

FREQUENT UPDATES RELEASE

Features

  • Improved logging capabilities

13.1.1.5299 - October 23rd 2017

Fixes

  • SC-9781: SQL Compare can deploy temporal tables from a scripts folder to a live database.

13.1.0.5287 - October 16th 2017

FREQUENT UPDATES RELEASE

Features

  • SQL Compare now generates a new style of HTML report, to match the reports produced by other Redgate products. For the command-line, this updates the -reporttype switch to include a new Html value. The Interactive and Simple values have been deprecated, and are now interpreted as being equivalent to the new Html value.

Fixes

  • SC-8880: Scripts folders can now be in the root of a drive (as long as it is otherwise empty)
  • SC-9775: On the command-line, in the absence of a -reporttype switch, SQL Compare now correctly uses the -report switch to infer the report type, based on the report file name extension. Supported extensions are htmlhtmxls and xml.
  • SC-9755: Deployment scripts are no longer saved with a double .sql extension.
  • SC-9659: SQL Compare no longer tries to refresh schema bound views when deploying a change to an XML schema collection.

Didn't find what you were looking for?