SQL Compare 13

SQL Compare 13.4 release notes

13.5.2.7785 - October 9th 2018

FREQUENT UPDATES RELEASE

Fixes

  • SC-10202: Improved handling of history tables that whose definitions were not included in a scripts folder
  • SC-10257: Queues and stored procedures that form a circular dependency are now deployed in the correct order when the source is a scripts folder
  • SC-10260: SQL Compare now handles snapshots containing temporal tables that were made using Compare version 12
  • SC-10261: Foreign key constraints can be set as CHECK or NOCHECK in a folder even when the option to ignore constraint names is set

13.4.8.7337 - September 3rd 2018

Features

  • Added Command line suppport for deploying the state represented by SQL Change Automation Projects. This is the offline schema model and programmable objects. This can be done using the sca1 and sca2 command line parameters, which should specify the path to the .sqlproj.

Fixes

  • SC-9458: Partition functions with datetime2(0) parameters now have the precision registered correctly when being read from a scripts folder
  • SC-10188: SQL Compare now ignores instance-specific functions generated by Change Data Capture
  • SC-10203: Updated the description for 'Ignore Constraint Names' and 'Ignore System Named Constraint Names' options
  • SC-10204: Ignore not for replication now works correctly when not for replication is set at the end of a line and ignore whitespace is not set
  • SC-10212: The return value of sp_addrolemember is now checked to improve error handling
  • Fixed a null reference exception where a CLR type depends on an assembly that is being created
  • Fixed a null reference exception when loading a snapshot from an older version of SQL Compare that was created from a scripts folder

13.4.7.7223 - August 20th 2018

FREQUENT UPDATES RELEASE

Fixes

  • Symmetric Keys now output a comment with various key properties in lieu of being able to deploy changes again
  • FunctionReturnTypeChange warning type renamed to FunctionTypeChange to more accurately reflect what it represents
  • SC-10161: SQL Compare will now rebuild indexes on views that reference a CLR assembly.
  • SQL Snapper now uses the correct case sensitivity setting when registering databases
  • SC-10194: The classic report no longer generates invalid javascript when there are no equal objects and include identicals is not set
  • SQL Compare now uses DBCC FREESYSTEMCACHE when modifying assemblies that are referenced by other assemblies

13.4.6.7079 - August 13th 2018

FREQUENT UPDATES RELEASE

Fixes

  • SC-10172: SQL Compare no longer incorrectly processes AT TIME ZONE in table expressions
  • SC-10134: SQL Compare can now parse nested AT TIME ZONE statements with parentheses
  • SC-10191: Commit statements without the TRAN or TRANSACTION keywords can now be parsed

13.4.5.6953 - July 30th 2018

Fixes

  • SC-10171: Null reference exception in serialisation fixed
  • SC-10178: Fix parser failure when TRY_PARSE(... USING <culture>) at the very end of a WHERE clause
  • SC-10181: Parser will now accept a language variable as the language option when creating a natively compiled stored procedure

  • SC-10185: Patching up dependencies when loading a snapshot will now correctly locate user defined table types

13.4.4.6883 - July 24th 2018

FREQUENT UPDATES RELEASE

Fixes

  • SC-10176: Parser now handles ordering by multiple columns in a STRING_AGG statement's WITHIN GROUP clause
  • Functions no longer rebuild or alter when the only change is extended properties, permissions or authorization
  • SC-10065: Improved alteration of security polices on case insensitive databases
  • SC-10177: Copying text from the diff viewer now preserves empty lines when the "Ignore whitespace" option is set

13.4.3.6777 - July 17th 2018

FREQUENT UPDATES RELEASE

Features

  • Added in-product notification of approaching support expiry

13.4.2.6669 - July 2nd 2018

FREQUENT UPDATES RELEASE

Features

  • SC-4757: Adds an "Ignore Change Tracking" option

Fixes

  • SC-9272: Fixed script ordering for service broker objects referenced by schema objects
  • SC-10123: Dependencies between user defined types and user defined table types are now respected when dropping them
  • SQL Compare migration blocks will now correctly drop and recreate dependencies when necessary.
  • SC-10069: Fixed dependencies bug between tables/views and their triggers when registering from a scripts folder
  • SC-10151: Dropping a function referenced by a security policy now drops and recreates the security policy

13.4.1.6601 - June 25th 2018

FREQUENT UPDATES RELEASE

Fixes

  • SC-9870: SQL Compare no longer creates SET statements in the context of creating a scripts folder, when filtered indexes are included.
  • SC-10145 Parse error on AT TIME ZONE with bracketed string literal fixed.

13.4.0.6563 - June 20th 2018

Features

  • SC-6601: The "Ignore authorization on schema objects" option now also includes schemas themselves

Fixes

  • SC-6610: Deploying a varchar(4096) column or wider onto a varchar(MAX) no longer gives spurious warning about truncation. Deploying in the other direction gives the correct warning.
  • SC-9834: Contracts and services with out of database / default / built-in message types and contracts, and some full text catalogs, no longer cause an exception when they exist in the target
  • SC-9940: Fixed issue parsing AT TIME ZONE where the time zone is the result of a nested SELECT statement
  • SC-10089: Deploying column changes to a fulltext index in a scripts folder will no longer create duplicate ALTER FULLTEXT INDEX statements
  • SC-10104: Modifying a key index of a fulltext index will now drop the fulltext index before and recreate it later
  • SC-10111: Changing the XML schema collection on a column will provide a more suitable warning
  • SC-10118: The interactive HTML report no longer sees case differences in data types as a difference
  • SC-10120: Copying text from the SQL differences pane to the clipboard now preserves line endings

Didn't find what you were looking for?