Released: Oct 17, 2017

Updates in 6.0

Funktionen

• New platforms
  • Support for SQL Server 2017 databases, including SQL Server on Linux
  • Support for TFS 2018
• Reduced footprint
  • SQL Source Control no longer creates multiple additional processes while running
  • Installer size reduced by half
• Other features
  • Setup, Migrations and Locking tabs have been updated, resolving a number of issues.
  • SQL Source Control now supports customisation on history tables for temporal tables, such as customised indexes.
  • SQL Source Control now supports the HISTORY_RETENTION_PERIOD option on temporal tables.
  • SQL Source Control now accepts DATABASE SCOPED CONFIGURATION syntax.
  • Replaced the Help->Feedback menu item with a link to the new Redgate Hub

Fehlerkorrekturen

• SQL Source Control will no longer cause SSMS to show a "Cannot find resource" error when installed alongside SQL Prompt.
• SC-9724: SQL Source Control now doesn't wrap $PARSER in square quotes when used within a table column.
• SC-9742: SQL Source Control now handles rebuilds of tables which are both temporal and memory optimised.
• SC-9700: SQL Source Control wraps the default values of DateTime and DateTime2 parameters defined in a stored procedure in single quotes.
• SC-9720/SC-9696: SQL Source Control now handles comparison of whitespace and comments more consistently when the IgnoreWhitespace or IgnoreComments options are set.
• SC-9653: SQL Source Control now supports the use of the non-reserved keyword MATCH, in the body of text objects.
• SC-9679: Row-level security policy block predicates are now correctly registered from on-premise live databases.
• SC-9645: CREATE OR ALTER PROC is now scripted correctly.
• SC-9548: SQL Source Control will now correctly create fulltext indexes if the IgnoreTransaction option is selected.
• SC-9685: SQL Source Control now uses DEFAULT instead of the text of your default when coercing nulls to a column's default value.
• SC-9657: SQL Source Control now filters whitespace and comments more consistently when the IgnoreComments option is set.
• SC-9668: ALTER statements aren't duplicated if 'Add object existence checks' option is set.
• 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 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.