SQL Data Compare 11.4 release notes
Published 17 November 2015
11.4.10 - February 8th, 2016
FREQUENT UPDATES RELEASE
11.4.9 - February 3rd, 2016
FREQUENT UPDATES RELEASE
New Features
- SQL Data Compare now has a SHA-256 digital signature.
11.4.8 - January 18th, 2016
FREQUENT UPDATES RELEASE
- SQL Data Compare now requires .NET 4.0 to be installed
- Pivot view has been removed from the differences grid after a rewrite.
Fixes
- Fixed an error registering views on Azure SQL Database V11.
SDC-2037
: Fixed a crash selecting rows in the Row Differences pane.
SDC-2014
: Data Compare no longer inserts NULLs when deploying a script folder where column names weren't specified
11.4.6 - January 11th, 2016
FREQUENT UPDATES RELEASE
11.4.5 - December 21st, 2015
FREQUENT UPDATES RELEASE
Fixes
SDC-2002
: Fix an issue where `comctl32.dll` could potentially fail to load when SQL Data Compare is launched.SDC-2007
: SQL Data Compare no longer fills its log file with warnings when trying to connect to some versions of SQL Source Control.
11.4.4 - December 14th, 2015
FREQUENT UPDATES RELEASE
11.4.3 - December 9th, 2015
Note: Version 11.4 rolls up all of the changes from frequent update versions 11.3.1 to 11.4.3 - if you want to receive these kinds of updates more quickly in future, you should turn on Frequent Updates.
Fixes
- Fixed an issue where in certain circumstances it wasn't possible to upgrade to the latest version of SQL Data Compare.
11.4.2 - December 8th, 2015
Fixes
SDC-2005
: SQL Data Compare no longer fails when registering a SQL 2000 database due to querying permissions which do not exist on this version of SQL Server.
11.4.1 - December 1st, 2015
New Features
SQL Data Compare will now warn when dynamic data masking (a new SQL Server 2016/Azure SQL Database feature) might cause masked data to be deployed. This warning appears when tables with data masks are selected in the source database and the user does not have UNMASK permission on the source database.
Fixes
From 11.4.0: The default behaviour for disabling and re-enabling foreign key constraints has changed
SQL Data Compare sometimes needs to temporarily disable foreign key constraints when updating data. When SQL Data Compare re-enables the foreign key constraints, it will now restore them to their original trusted or untrusted state by default, rather than always using WITH NOCHECK
to skip integrity checks. This means that the constraints will no longer default to being untrusted, but the deployment will take longer because the integrity checks need to be carried out.
The Force constraints to be re-enabled WITH CHECK option is now deprecated. If you want SQL Data Compare to continue to use WITH NOCHECK
to skip integrity checks for foreign keys, select the new Skip integrity checks for foreign key constraints option.
From previous 11.3.x frequent updates releases
SDC-1952
: SQL Data Compare no longer freezes when you switch to a password field with the touch keyboard enabled in Windows 10.SDC-1968
: SQL Data Compare now preserves extended properties on foreign keys when the 'Disable foreign keys' option is selected.SC-8005
: SQL Data Compare no longer requires VIEW SERVER STATE permissions to register databases on SQL Server 2008 and laterSC-8023
: All connection strings used by SQL Data Compare to connect to SQL Server now include the application name "Red Gate Software - SQL Tools"
11.4.0 - November 17th, 2015
FREQUENT UPDATES RELEASE
Fixes
The default behaviour for disabling and re-enabling foreign key constraints has changed
SQL Data Compare sometimes needs to temporarily disable foreign key constraints when updating data. When SQL Data Compare re-enables the foreign key constraints, it will now restore them to their original trusted or untrusted state by default, rather than always using WITH NOCHECK
to skip integrity checks. This means that the constraints will no longer default to being untrusted, but the deployment will take longer because the integrity checks need to be carried out.
The Force constraints to be re-enabled WITH CHECK option is now deprecated. If you want SQL Data Compare to continue to use WITH NOCHECK
to skip integrity checks for foreign keys, select the new Skip integrity checks for foreign key constraints option.
Releases