SQL Source Control v6.0

Añade compatiblidad con bases de datos de Microsoft SQL Server 2017, incluida SQL Server en Linux.
Noviembre 6, 2017
Nueva versión

Características

  • 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

Correcciones

  • 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

Control de código fuente de base de datos en SSMS.

¿Alguna pregunta?

Chatee en vivo ahora mismo con nuestros especialistas en licencias de Redgate Software.