SQL Source Control 2.1 release notes
Published 16 July 2015
March 30th, 2011
Version 2.1 of SQL Source Control introduces support for any source control system with a command line interface.
Presets are included for:
Additionally, you can configure SQL Source Control to work with other source control systems.
For more information, see Working with config files.
For GIT and Perforce, committing changes with SQL Source Control commits all changes, not only database changes
If you are using GIT or Perforce, committing changes with SQL Source Control can commit all currently uncommitted changes for the working folder you are linked to.
This means that, for example, you could accidentally commit application code changes as well as database changes from within SQL Source Control.
To avoid this issue, we recommend you create a new, empty folder in source control to link your database. This makes sure the folder contains only database code, and you cannot commit non-database changes.
Issues for Vault users upgrading from the early access version
Users upgrading to version 2.1 from previous early access version may encounter issues.
If you are upgrading from an early access version, you are recommended to first do the following:
- Unlink your databases from source control.
- In Windows Explorer, naviagte to: %localappdata%\Red Gate\SQL Source Control <version number>
- Delete the files LinkedDatabases.xml, and TableDataConfigs.xml
Link your databases to source control again.
Spurious object change notification in rare circumstances
In some situations, it is possible to see a blue change notification in the Object Explorer, where there is no corresponding object with changes to commit on the Commit Changes tab.
This can occur, for example, if you alter a stored procedure and run it, then remove the change you made and run it again. The Object Explorer would continue to show a change, but there would be no change listed on the Commit Changes tab. Once you have visited the Commit Changes tab, and SQL Source Control has accurately determined the differences, the blue indicator is removed from the Object Explorer.
This is because the change detection performed on the Commit Changes tab is more detailed, and considers the state of the database, whereas the change notifications in the Object Explorer are displayed when a change is made.
Generally, you are unlikely to encounter this issue. However, it may be slightly more common when working under a shared development model.
Unlinking if you downgrade to version 1
If you uninstall SQL Source Control version 2, and install version 1, any databases that were linked to source control while you were using version 2 are unlinked. Simply re-link them to continue using them with SQL Source Control.
Performance issues when source controlling large quantities of data
If the data tables you are source controlling have a large number of rows, the Commit Changes and Get Latest tabs may be slow to populate and refresh.
Because performance can be poor for large quantities of source controlled data, we recommended you only source-control static (lookup) data.