SQL Source Control
Latest version: 3.1
Notes & articles
Release notes - version 2.2
SQL Source Control is an add-in for SQL Server Management Studio that allows you to source control your databases.
Note that SQL Source Control is not a source control system; it allows you to store your databases in your existing source control system.
This article discusses:
Features in version 2.2
Version 2.2 of SQL Source Control introduces the following new features:
- Object filtering
If you want to exclude objects from SQL Source Control, you can set up filters so they are not shown on the Commit Changes or Get Latest tabs. This is useful, for example, if there is a specific set of objects you never want to commit to source control.
For more information, see Using filters to exclude objects
- Repository browsing when linking
The Link To Source Control dialog box now includes a Browse button for Subversion, Team Foundation Server and Vault. Use this to browse your source control repository when you are linking to source control.
The browse functionality also lets you create new folders in your repository, so you can get set up without needing to leave SQL Server Management Studio.
Known issues in version 2.2
SQL Source Control version 2.2 has the following known issues:
Config files are no longer included for CVS and Bazaar
When linking a database to source control, on the Link to Source Control dialog box, presets are no longer included for the CVS and Bazaar source control systems.
You can still create a custom config file to support any source control system with a command line interface.
This change does not affect users who are already using CVS or Bazaar 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, you are recommended only to source control static (lookup) data.
Note that large quantities of data, or data that changes frequently (such as transactional data) should not be source controlled.
Bug reports and feedback
We are continuing to develop SQL Source Control, and we value any feedback you may have.
Please let us know about any issues you may encounter.
If SQL Source Control encounters a serious issue, you may see an error report dialog box:
Please click Send Error Report, and - if possible - provide detailed feedback, as these reports are extremely valuable to us.
These error reports may include:
- a stack trace
- your SQL Server and operating system version
- the Windows user you are logged in as, and your domain
This is so we can identify recurrent bugs.
- information from the SQL Source Control logs
In some conditions, this may include information about your database schema.
Getting more information
Was this article helpful?
SQL Source Control
- Setting SQL Compare options within SQL Source Control
- "ICredentialsProvider is unset, therefore can't get" error occurring within SQL Source Control
- Linking fails due to SVN pre-commit hooks
- Logging changes to shared databases
- Object changed by Unknown
- Setting permissions for SQL Source Control
- Using SQL Source Control with Team Foundation Server 2012 or tfspreview.com
- Error: Failed to resolve no-ops after 5 tries
- Using SQL Compare or SQL Changeset scripts with SQL Source Control
all SQL products
- Compatibility of Red Gate tools in 64-bit environments
- Application has encountered an error and needs to close
- Error message after installing SQL Toolbelt - The description for Event ID ( 1 ) in Source ( nview_info ) cannot be found.
- Changing the temporary directory used by the installer
- Toolbelt Installer "hanging" while "scanning volumes"
- Login failing with "trusted SQL Server connection" error when using RunAs
all products
- Some Red Gate products identified as containing a trojan by Anti-Virus software
- Activation may fail with Unknown Error -1
- Product uses web help although a CHM file is available locally
- Argument exception resulting from missing environment variable
- Check for updates may fail when used through proxies
- 'Unidentified Publisher' error when repairing or uninstalling
- Licensing activates product as standard edition
- Moving Red Gate software products to another machine
- Red Gate tools log locations
- The application UI opening slowly when there is no internet access
SQL Source Control
- Database development models
- Release notes - version 1.0
- Release notes - version 1.1
- Release notes - version 2.0
- Release notes - version 2.1
- Release notes - version 2.2
- Requirements & prerequisites
- Technical Overview
- Release notes - version 3.0
all SQL products
all products
- Red Gate product acknowledgements
- Activating your products
- Activating your products
- Red Gate bundle history
- Check for updates
- Troubleshooting Check for Updates errors
- Current versions
- Deactivating your products
- Installing Red Gate products from the .msi file
- Requesting additional activations
- Serial numbers for bundles
- Reactivating using a different serial number
- Extending your trial
- Finding your serial numbers
- Moving a serial number from one computer to another
- No response received for manual activation
- Licensing and activation resources
- Licensing and activation resources
- Troubleshooting licensing and activation errors
- Licensing and activation FAQs
- Red Gate tools log file locations
- Download old versions of products
- Download product prerequisites & utilities
- Support & upgrades
- Upgrading your software
- Upgrading FAQs


Step by step examples