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.18.11916 - July 15th 2019

FREQUENT UPDATES RELEASE

Fixes

  • SC-8949: ANSI current_timestamp syntax now reads correctly from scripts folder
  • SC-10569: Warning added for downgrade of AUTO_GRID tesslation schemes in spatial indexes
  • SC-10575: Compare now correctly parses the case where you have both an XML NAMESPACES and a CTE in a cursor declaration within a stored procedure.

13.7.17.11774 - July 8th 2019

FREQUENT UPDATES RELEASE

Fixes

  • SC-10528: Improved performance calculating work when many default constraints are present
  • SC-10562: Improved error message when your scripts folder contains a field with an invalid data type
  • Impersonate permissions on roles and schemas now deploy correctly
  • Old (pre-v13) snapshots should now load quicker

13.7.16.11325 - June 13th 2019

FREQUENT UPDATES RELEASE

Fixes

  • Fixed a bug where necessary whitespace would sometimes not be included in the migration script when renaming a table which is referenced in a procedure.
  • Synonym dependencies behaviour has changed
  • SC-10524: SSMS 18 now correctly listed in application options
  • Text object dependencies can now disambiguate between types and tables with the same name

13.7.15.11228 - June 6th 2019

FREQUENT UPDATES RELEASE

Fixes

  • SC-10531: Comparing two different Git revisions using the SQL Compare command line now works
  • SC-10516: Columnstore index columns can no longer incorrectly be marked as DESC
  • SC-10510: Updating a scripts folder when the only change is alters to XML schema collections now works

13.7.14.11151 - June 3rd 2019

FREQUENT UPDATES RELEASE

Fixes

  • Error handling statements added between route drop, XML schema collection drop/unbind and view refresh statements
  • SC-10528: Corrected a performance issue when comparing default constraints
  • SC-10519: Backups created with SQL Backup using multiple threads and with CHECKSUM enabled are now supported

13.7.13.10771 - May 13th 2019

Fixes

  • SC-10455: Scripts folder deployments now restore pre-existing permissions if Ignore Permissions option is set
  • SC-10505: Fixed an issue parsing stored procedures preceded by a nested comment, that could result in an a crash, or an incorrect diff being shown when the "Ignore authorization on schema objects" option is set
  • Ignore SET QUOTED_IDENTIFIER and SET ANSI_NULLS option now also removes those from the initial SET statement, and additionally removes the deprecated SET option ANSI_PADDING from that statement
  • Fixed error on generating deployment script when a text object (e.g. a stored procedure) referenced a history table directly
  • Summary view tab no longer 'hidden' in some circumstances
  • SC-10509: Default generated history table schema for scripts folder registration no longer contains the NOT FOR REPLICATION clause for columns that were identity columns with NOT FOR REPLICATION on the main table

13.7.12.10555 - May 7th 2019

FREQUENT UPDATES RELEASE

Fixes

  • Local objects that share the same name as a dependent object in another database are no longer seen as a dependency
  • SC-10496: Object existence checks no longer appear in the diff view when the "Add object existence checks" deployment option is enabled
  • Fixed issues when running SQL Compare in a non-English locale, including SC-10487 where FILLFACTOR was ignored in scripts folders when running in a Turkish locale

13.7.11.10438 - April 29th 2019

FREQUENT UPDATES RELEASE

Fixes

  • Error handling statements now in place between assembly drops to ensure we stop as soon as an error is encountered

  • SC-10477: We now deploy changes to partition schemes that are required by partition function changes, even if they would otherwise be ignored because the ConsiderNextFilegroup option is turned off

13.7.10.10373 - April 23rd 2019

FREQUENT UPDATES RELEASE

Features

  • Role and user modifications will now usually be done within the transaction rather than beforehand (unless they must be done beforehand because of limitations of SQL 2005/8 or full text objects depending on them)
  • Partition Schemes now select their dependencies if Include Dependencies is specified and Ignore Filegroups is turned off. Table drops will generate a High warning if generated.

Fixes

  • SC-10470: An exception is no longer thrown when updating a column in a scripts folder during a table rebuild from a type with no length to a type with length
  • SC-10474: SSDT projects are now recognized if the only version of MSBuild installed is 15
  • SC-10103: Partition Functions now no longer pull in non-selected partition schemes that didn't already exist in the target.
  • Fixed a rare occurence where a table rebuild caused by CLR UDT change would drop the table off its filegroup or partition scheme back to PRIMARY
  • We now use ALTER ROLE ADD / DROP MEMBER rather than sp_addrolemember/droprolemember on SQL2012 and above

13.7.9.10201 - April 10th 2019

FREQUENT UPDATES RELEASE

Features

  • Added a new project guid property to the RedGateDatabaseInfo xml file. This property will be used to track SQL Source Control usage across other Redgate products

Fixes

  • SC-8035/SDC-1978: SQL Compare no longer throws an exception in a situation where SQL Server doesn't provide column type information
  • SC-10461: Security policies that depend on functions that are being dropped, will no longer be recreated if they are also being dropped

13.7.8.10109 - April 1st 2019

FREQUENT UPDATES RELEASE

Fixes

  • Added some logging to foreign key population; now avoids nullref when referenced table cannot be found
  • SC-10449: Rebuilding a computed column will no longer drop an index on the column
  • Added some logging to foreign key population; now avoids nullref when referenced table cannot be found
  • Remove duplicate drop action messages for service broker objects
  • Add error handling statements between history table clustered index creation, table creation and sp_tableoption calls

13.7.7.10021 - March 26th 2019

Fixes

  • Error handling statements are now added between each foreign key and computed column drop, reducing extra statements executed in a failure state
  • Reduced the number of duplicate error handling statements in a row added around several statements
  • When FIPS mode is enabled, SQL Compare will still not be able to decrypt an object but will no longer throw an error
  • SC-10443: "Sequence contains no matching element" when schemas are cross-mapped
  • When a stored procedure might be broken due to being excluded from deployment, SQL Compare will no longer insist on deploying changes to it.
  • SC-10454: Tables with edge constraints are now dropped before the referenced node tables

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?