SQL Compare 13

SQL Compare 13.7 release notes

SQL Server Edge Constraints

Graph tables in SQL Server 2019 can have edge constraints, which constrain the node tables that an edge can refer to. Comparison and deployment of these constraints is supported in SQL Compare 13.7.

13.7.6.9920 - March 18th 2019

FREQUENT UPDATES RELEASE

Fixes

  • CLR type related table rebuilds will now also correctly rebuild all computed columns that reference the affected column, not just those with a method call
  • SQLite dependency upgraded to version 1.0.110

13.7.5.9811 - March 11th 2019

FREQUENT UPDATES RELEASE

Fixes

  • SC-10437: Tables on different filegroups are no longer rebuilt when there is a maximum length text column and the "Ignore Filegroup, partition schemes and partition functions" option is enabled
  • SC-10439: DROP PROC IF EXISTS no longer causes a parser error

13.7.4.9637 - February 28th 2019

FREQUENT UPDATES RELEASE

Fixes

  • SC-10427: Occasional unnamed default constraints that would erroneously appear will now not appear
  • SC-10407: Static data is no longer omitted from a command line comparison when the table doesn't exist in the target and a project file is being used
  • SC-10019: Excluded object types are no longer shown in the report if the /include:Identical switch is used
  • SC-10435: ODBC escape sequences for LIKE clauses can now be parsed
  • SC-10434: The classic report now renders correctly

13.7.3.9483 - February 20th 2019

Fixes

  • Fixed a threading deadlock when the source is a scripts folder
  • SC-10420: Adding a NOT NULL constraint to a column with a default constraint and an index will no longer fail deployment due to recreating the index before changing nullability
  • When creating a table that has rule bindings, those rules are now updated as dependencies
  • Default objects are now no longer rebuilt if there are only extended property or permission changes
  • Defaults and rules are no longer applied futureonly on UDTs - this means they will apply themselves to any table fields the UDTs are applied to

13.7.2.9407 - February 18th 2019

FREQUENT UPDATES RELEASE

Fixes

  • Added some extra error handling statements around role memberships
  • SC-8716: Changing the name of a default constraint now no longer unnecessarily drops and recreates indexes that reference the same column

13.7.1.9280 - February 11th 2019

FREQUENT UPDATES RELEASE

Fixes

  • SC-10382: Clustered columnstore indexes are no longer rebuilt when adding a column to a table and the "Ignore constraint and index names" option is set
  • SC-10408: An exception is no longer thrown when updating a column in a scripts folder from a type with no length to a type with length
  • SC-10409: A duplicate index definition is no longer created when updating the schema of a temporal table in a scripts folder

13.7.0.9250 - February 7th 2019

FREQUENT UPDATES RELEASE

Features

  • SQL Compare now supports comparison and deployment of edge constraints

Fixes

  • SC-10393: SQL Compare now supports the DATA_COMPRESSION keyword on spatial indexes

Didn't find what you were looking for?