SQL Source Control
Connect your databases to your source control system
- Plugs into SQL Server Management Studio
- Source control your schemas and static data
- NEW BETA: Improvements to migration scripts
SQL Source Control is an add-in for SQL Server Management Studio that links your database to your
source control system.
Because it works with tools you already use, there’s no lengthy setup, yet it gives you the ability to source
control schemas and reference data, roll back changes, and maintain the referential integrity of your
And it helps you solve other database challenges, like deploying without losing data.
Key features of SQL Source Control
Source control at your fingertips inside SQL Server Management Studio
It’s easy to record and share your code changes, because SQL Source Control runs inside SQL Server
You don’t have to stop what you’re doing or pass round handwritten change scripts.
Source control your schemas and reference data
Store and share any SQL Server object and static data. Committing and updating takes two clicks in
the Object Explorer.
To see what’s new, you can check changes down to the individual lines of SQL, with highlighted differences.
Handles referential integrity for you
When you commit or update, SQL Source Control maintains the referential integrity of your
database for you.
It works out the right order for your changes and even deals with keys and constraints.
It uses the same engine as SQL Compare, the world’s most trusted tool for syncing database
Push and pull Git repos
Synchronize your local and remote Git repositories inside Management Studio.
Pull down changes from your remote repository, commit your changes locally, and push straight
them to your remote repository to share with the rest of your team.
Lock objects you're working on
You can lock the object you're working on in SQL Server Management Studio with just one
click, so your changes are safe from being overwritten.
Your team can see what's locked, as well as information on who locked it.
Work on a central database or your own local copy
You and your team can work on a shared database or each use a local, dedicated copy.
SQL Source Control supports both models for database development.
Either way, it helps you share code, avoid conflicts, and see who’s doing what, so you can
work without treading on each other’s toes.