Released: Feb 13, 2019

7.0.10 中的更新

特性

• Adds new comparison option to ignore sensitivity classifications on fields.

修补程序

• Clustered columnstore indexes are no longer rebuilt when adding a column to a table and the "Ignore constraint and index names" option is set.
• An exception is no longer thrown when updating a column from a type with no length to a type with length.
• A duplicate index definition is no longer created when updating the schema of a temporal table.
• SQL Source Control now supports the DATA_COMPRESSION keyword on spatial...

Released: Dec 21, 2018

7.0.6 中的更新

特性

• Improve error dialog on failed commit.
• Add copy to clipboard button on some error dialogs.

修补程序

• Fixed the problem that caused some buttons in the SQL Source Control UI to be invisible in the first run after installation.
• SC-10339: Adding a column to a table with a history table no longer attempts to re-create an existing index.
• SC-10355: SQL Source Control can now handle more than one sensitivity classification per table.
• SC-10319: SQL Source Control now recognises primary keys on filetables...

Released: Nov 20, 2018

7.0.0 中的更新

特性

• Support for pushing to TFS Git.
• Support for SSMS 18.
• Introduces Pre and Post-Deployment scripts.
  • Pre and Post-Deployment scripts contain SQL that is run during a deployment of a SQL Source Control project.
  • Provides more control over your database deployments.

修补程序

• Various git fixes.

Released: Oct 8, 2018

6.3.2 中的更新

特性

• Support for SSMS 18 preview
• Add UI Option DisableAutoRefresh to disable automatic refresh of the commit and get latest tabs.

修补程序

• When SQL Source Control fails to create a cache for a scripts folder it will no longer fail with the message "Object reference not set to an instance of an object.".
• SQL Source Control no longer shows an error when reading a temporal table from the registration cache.
• SQL Source Control no longer throws an error when dropping a block predicate with a specified DML...

Released: Aug 29, 2018

6.3.0 中的更新

特性

• Introduces Pre and Post-Deployment scripts.

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).

修补程序

• Partition functions with datetime2(0) parameters now have the precision registered correctly when being read from a scripts folder.
• SQL Source Control can now parse nested AT TIME ZONE statements with parentheses.
• SQL Source Control will now rebuild indexes on...

Released: May 23, 2018

6.1.8 中的更新

特性

• Bulk uninstaller improvements.
• Telemetry has been updated in accordance with Redgate Software's privacy policy.

修补程序

• Ignores line endings whitespace in string literals when the ignore whitespace option is used.
• Fixed a compatibility issue between different versions of Redgate products that could cause them to fail to load in SSMS 2014 and earlier.
• Fixed an ObjectNotInDifferences error that occurred when the database contains a Service that depends on a Contract that is not defined in the...

Released: Jan 31, 2018

6.1 中的更新

修补程序

• Now supports filegroups defined on a fulltext index.
• No longer duplicates index creation on history tables.
• Now supports history tables with the same name but different schema to their related temporal table.
• Now supports TEXTIMAGE_ON filegroup if it differs from the filegroup of the table.

SQL Server Management Studio (SSMS) 2008 and 2008R2 are no longer supported.
Note: SQL Source Control will continue to support SQL Server 2008 and 2008R2 - you will just need to connect to the server...

Released: Oct 17, 2017

6.0 中的更新

特性

• 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...

Released: Aug 1, 2017

5.8 中的更新

特性

• Updated the comparison options dialog to display more information and allow searching for specific options.
• 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.

修补程序

• Fixed an issue where SQL Source Control would fail to compare users if...

Released: Aug 26, 2016

5.2.3 中的更新

修补程序

• Additional logging for errors during get latest when your repository contains migration scripts.
• SOC-7874, SOC-7878: SQL Source Control will clean-up temporary tables used when registering a database.
• Improved error handling and logging when generating a deployment script in Get Latest.
• SC-8854: Prevented a crash that could occur when registering a scripts folder containing a function with a complex series of aliases.
• SC-8042: Add check to avoid putting default permission for user defined...