These pages cover SQL Data Compare 13, which is not the latest version. Help for other versions is also available.
SQL Data Compare 13.3 release notes
Published 04 April 2018
13.3.8.6436 - June 11th 2018
Fixes
- SQL Data Compare more consistently compares data from a scripts folder when using a VARCHAR comparison key.
13.3.7.6422 - June 11th 2018
FREQUENT UPDATES RELEASE
Compatibility with SQL Compare 13.3.7.6422
13.3.6.6375 - June 4th 2018
FREQUENT UPDATES RELEASE
Features
- SDC-2857: Add option to include generated always columns in the comparison
Fixes
- SDC-2844: Update collations to use Microsoft library to improve consistency
- Performance improvements when populating indexes from a database
13.3.5.6244 - May 23rd 2018
Features
- SQL Compare supports external language event types, which are now available on Azure
Fixes
- Telemetry has been updated in accordance with the privacy policy available at https://www.red-gate.com/website/legal
13.3.4.6198 - May 17th 2018
FREQUENT UPDATES RELEASE
Fixes
- SC-10080: SQL Compare again ignores line endings whitespace in string literals when IgnoreWhiteSpace switched on.
- SC-10050: SQL Compare can again handle Services with Contract dependencies not in the database that could just be arbitrary strings (e.g. as in the case with Query Notifications)
- IgnoreUsers now properly ignores role memberships again; role memberships are no longer ignored when IgnoreUsers is off
- extended properties on queue event notifications are no longer deployed when the IgnoreEventNotificationsOnQueues option is on
- SC-10025: SQL Compare more gracefully handles errors with missing schemas in a scripts folder
- SC-9713: Using the IncludeIdentical switch on the command line no longer rebuilds objects with default non_PRIMARY filegroups
- SC-10044: The existence of multiple DDL event types on the server that are unknown to SQL Compare will longer cause trigger registration to fail
- SC-10061: Double-clicking on a project in the 'My projects' screen now does 'Compare now' instead of 'Edit project'
- SC-10062: Command line can deploy static data from a table with a primary key and unique index to a table with only a unique index
- SC-10072: Simple HTML option description removed from help widget in Generate Comparison Results Report dialog
- SC-10074: When rebuilding a temporal table, data from the GENERATED ALWAYS AS ROW START/END columns is now preserved
- SC-10077: When using "Ignore white space" option, nested string literals with whitespace differences now have highlighting applied
13.3.3.6037 - May 1st 2018
FREQUENT UPDATES RELEASE
Fixes
- SDC-2837: SQL Data Compare now handles comparisons of tables with a non-mapped computed field
13.3.2.5875 - April 17th 2018
Fixes
- SDC-2826: The 'Drop primary keys, indexes, and unique constraints' option no longer drops unique ROWGUIDCOL indexes on tables that include a FILESTREAM field.
- SC-10036: The SQL Data Compare command line will no longer fail when there is whitespace between options in an XML argument file
13.3.1.5775 - April 9th 2018
FREQUENT UPDATES RELEASE
Features
- SQL Data Compare command line now includes switches /activedirectory1 and /activedirectory2 to specify the use of Azure Active Directory authentication
Fixes
- SDC-2799: The
Reseed identity columns
option now sets the current seed of the target to the current seed of the source when possible
13.3.0.5760 - April 4th 2018
FREQUENT UPDATES RELEASE
Compatibility with SQL Compare 13.3.0.5760