SQL Source Control v6.0

添加對 Microsoft SQL Server 2017 資料庫 (包括 SQL Server on Linux) 的支援。
11月 6, 2017
新版本

特性

  • New platforms
    • Support for Microsoft 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 customization on history tables for temporal tables, such as customized 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

修補程式

  • 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 optimized.
  • 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.
SQL Source Control

SQL Source Control

SSMS 內的資料庫原始程式碼管理。

有任何疑問嗎?

Live Chat現在與我們的Redgate Software 專家即時聊天詢問。