SQL Source Control 5.4 release notes
Published 16 December 2016
Before you update, here are a few things you should know:
The new migrations solution replaces all previous versions
Migration scripts created using previous versions of SQL Source Control won't be compatible with SQL Source Control 5. To make sure any existing migration scripts aren't lost, see Upgrading from old versions of migration scripts before you update to SQL Source Control 5.
To deploy SQL Source Control 5 migration scripts using SQL Compare, you'll need SQL Compare version 11.6 or greater.
The following version control systems are no longer supported:
The following SQL Server versions are no longer supported:
- SQL Server 2005 (RTM, SP1, SP2, SP3 and SP4).
5.4.2 - January 19th, 2017
Fixes in this version
- Fixed a crash that could occur when showing/hiding notifications
Release notes for previous frequent update releases
Version 5.4.2 rolls up all of the changes from frequent update versions 5.3.1 to 5.4.1 - if you want to receive these kinds of updates more quickly in future, you should turn on Frequent Updates
5.4.1 - January 13th, 2017
FREQUENT UPDATES RELEASE
Fixes
- SOC-8281: SQL Source Control no longer fails with the message "The method or operation is not implemented" when trying to show static data changes with CLR data types
- Fixed an issue where SQL Source Control couldn't add/remove "WITH ENCRYPTION" in some cases
- SC-9167: The ignore white space option now correctly ignores white space in comments of textual objects
- SC-9159: Fixed a case where SQL Source Control could crash while registering inline CLUSTERED COLUMNSTORE definitions in a CREATE TABLE statement from a scripts folder
- SC-9058: Improved support for AT TIME ZONE syntax
- SC-9147: SQL Source Control will now recreate an index after dropping it due to changing an underlying field when the Ignore indexes option is set and the index only exists in the target database
- SC-9158: SQL Source Control now accepts OPENJSON calls with arbitrary expressions as the json parameter
- SC-9155: SQL Source Control will no longer check for differences in activation properties on queues (EXECUTE AS, MAX READERS, etc) if an activation procedure is not set
- SC-2186, SC-3890, SC-3975, SC-4993, SC-9147: SQL Source Control will now recreate an index after dropping it due to changing an underlying field when the Ignore indexes option is set
- SC-9149: SQL Source Control now accepts the WAIT_AT_LOW_PRIORITY option for ALTER TABLE SWITCH PARTITION statements
5.4.0 - December 16th, 2016
FREQUENT UPDATES RELEASE
Fixes
- SOC-8276: SQL Source Control scripts location XML fragment is now shown in Setup tab, "Under the hood" section
- SOC-8206: Checkbox selections are no longer lost when an error occurs on the Get Latest tab
Release notes for previous frequent update releases
- SQL Source Control 5.3 release notes
- SQL Source Control 5.2 release notes
- SQL Source Control 5.1 release notes
