SQL Source Control 5

SQL Source Control 5.8 release notes

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 RemotingException
  • SOC-8874: Fixed error when closing SSMS
  • SC-9532, SC-9537, SC-9538: The SQL parser now accepts syntax for new SQL Graph, ALTER INDEX and STRING_AGG features in SQL Server 2017
  • SC-9534: During Get Latest, SQL Source Control will now create tables before schemabound functions to resolve dependencies
  • SC-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 indexes
  • SC-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 folders
  • SC-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

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 correctly
  • SC-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

Didn't find what you were looking for?