SQL Source Control

Database source control within SSMS.

Published by Redgate Software
Distributed by ComponentSource since 2005

Version: 7.8.x

i

Please Note: SQL Source Control is no longer available as a standalone product for new purchases. It is only available for new license purchases as part of SQL Toolbelt Essentials or Flyway Teams.
If you already own existing licenses of this product, please contact us for pricing to add additional licenses to your existing license key.

SQL Source Control Releases

Released: May 21, 2019

Updates in 7.0.24

Updates in 7.0.24

  • Updates SQL Compare and SQL Data Compare to 13.7.14.10918.

Released: May 14, 2019

Updates in v7.0.23

Updates in 7.0.23

  • SOC-9848: Fixes an issue when an .rgproj was present that would prevent importing or committing changes again until SQL Source Control was restarted.
  • Updates SQL Compare and SQL Data Compare to 13.7.13.10717.

Released: May 8, 2019

Updates in 7.0.22

Features

  • Added the ability to scroll the migration tab on low screen resolutions.
  • Updates SQL Compare and SQL Data Compare to 13.7.13.10556.

Released: May 1, 2019

Updates in 7.0.21

Updates in 7.0.21

  • Updates SQL Compare and SQL Data Compare to 13.7.11.10438.

Released: Apr 2, 2019

Updates in 7.0.17

Features

  • Added a new project guid property to the RedGateDatabaseInfo xml file. This property will be used to track SQL Source Control usage across other Redgate products.

Released: Feb 13, 2019

Updates in 7.0.10

Features

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

Fixes

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

Released: Dec 21, 2018

Updates in 7.0.6

Features

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

Fixes

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

Released: Nov 20, 2018

Updates in 7.0.0

Features

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

Fixes

  • Various git fixes.

Released: Oct 8, 2018

Updates in 6.3.2

Features

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

Fixes

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

Released: Aug 29, 2018

Updates in 6.3.0

Features

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

Fixes

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