SQL Server on Linux를 포함하는 Microsoft SQL Server 2017 데이터베이스 서포트를 추가합니다.
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.