SQL Source Control 5.8 release notes
Published 13 July 2017
Before you update, here are a few things you should know:
SQL Server Management Studio (SSMS) 2008 and 2008R2 are no longer supported
Please note that SQL Source Control will continue to support SQL Server 2008 and 2008R2 - you will just need to connect to the server using a newer version of SSMS (2012 or greater). See End of support for SSMS 2008 and 2008R2 for more information.
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 (all versions).
5.8.3.6733 - August 22nd, 2017
FREQUENT UPDATES RELEASE
Features
- Setup, Migrations and Locking tabs have been updated, resolving a number of issues.
- The number of processes created by SQL Source Control has been reduced
- Replaced the Help->Feedback menu item with a link to the new Redgate Hub
Fixes
SOC-7271:
Fixed issues that would cause the SQL Source Control UI to disappear and show a RemotingExceptionSOC-8874:
Fixed error when closing SSMSSC-9532, SC-9537, SC-9538:
The SQL parser now accepts syntax for new SQL Graph, ALTER INDEX and STRING_AGG features in SQL Server 2017SC-9534:
During Get Latest, SQL Source Control will now create tables before schemabound functions to resolve dependenciesSC-9519:
SQL Source Control will no longer fail to register a database if the EXECUTE ANY EXTERNAL SCRIPT permission is present on a role object.SC-9520, SOC-8863:
SQL Source Control will now correctly source control DISABLED indexesSC-9526:
The SQL parser now accepts parentheses around identifiers in a CREATE FULLTEXT INDEX statement- Fixes a problem in the licensing client that could cause an OutOfMemory Exception
5.8.2.6579 - August 1st, 2017
FREQUENT UPDATES RELEASE
Features
- Updated the comparison options dialog to display more information and allow searching for specific options
Fixes
SOC-8321, SOC-8852:
Fixed an issue where SQL Source Control would fail to compare users if the domain was different
5.8.1.6443 - July 20th, 2017
FREQUENT UPDATES RELEASE
Fixes
-
SC-9267, SC-9296, SOC-8837
: Fixed a bug where for some machines database registration could fail with the message "An unexpected error was encountered while querying the database system tables..." (with the original error message "String was not recognized as a valid DateTime") SC-9501:
Spurious TEXTIMAGE_ON clauses are no longer appended to tables with computed columns registered from scripts foldersSC-9516:
SQL Source Control now handles dependencies between fulltext indexes and other indexes correctly
5.8.0.6413 - July 13th, 2017
FREQUENT UPDATES RELEASE
Changes to requirements and supported systems
- SSMS 2008 and SSMS 2008R2 are no longer supported
- SQL Source Control now requires .NET Framework version 4.6.1 or greater
Features
- Global Options are now available by clicking the 'Options' button in the header bar, rather than through the Setup tab. This means they are available even when you don't have a linked database selected.
- All of the linking options (source control, working folder, and evaluation) now follow a consistent workflow
Fixes
-
SC-9504:
SQL Source Control will now correctly treat multiplication/division operations as having a higher precendence than bitwise operations when parsing SQL SC-9471:
SQL Source Control can now write constraints with an AT TIME ZONE clause correctlySC-9507:
SQL Source Control will no longer script out an empty ALTER SEQUENCE statement when the only extended properties are different between the respective sequences