SQL Server source control
Integrate source control with SQL Server database development
?Integrate SQL source control directly into SSMS
?Use dedicated or shared development models
?View conflicts and resolve directly in the UI
?View a detailed history of changes
?Lock objects to prevent overwrites
?Set team policies for check outs and locks
?Apply changes with dependency aware scripts
?Create and apply label from source control
Features
Popular source control systems support
Native and command line support for all the most popular source control systems including Git, Mercurial, Perforce, Subversion, and Team Foundation Server or any source control system which have command line support
Choice of database development models
Support for simultaneous work on dedicated and shared databases
Working folder
Link database to any folder in the file system
Object filtering
Exclude database or repository only objects from source control by schema, type or specific objects
Action center
Work with the latest object changes in real time
Batch operation processing
Perform source control operations on multiple objects simultaneously
Conflict resolution
Merge changes with either a built-in or third-party script diff/merge tools
Checking out and locking objects
Check out and lock objects in order to prevent others from making changes
Change rollback
Undo the latest changes made against selected objects
Historical view
See the complete history of all committed object changes
Static data support
Place your static data under source control for easier tracking of changes
Labels
Create labels and get by label easily
Database development policies
Set source control implementation rules by using policies
Object status
See the current status of objects in a shared database
Change log
Track who made changes, when, and on which objects in a shared database
Offline mode
Ability to work offline for distributed source control systems
System requirements
Hardware requirements
Dual Core 2.0 GHz CPU
4 GB memory
50 MB disk space (depends on the number of linked databases)
SQL Server
Microsoft SQL Server 2016, 2014, 2012, 2008, and 2005
Azure SQL Database, SQL Server on Amazon RDS
Add-in integration
SQL Server Management Studio 2016, 2014, 2012, or 2008
OS
Windows Vista/Server 2003 and above
Required
Microsoft .NET Framework 3.5 SP1
Note
Native support for Git, Mercurial, Subversion, Perforce and Team Foundation Server
Compare
Integration
SQL Server Management Studio 2008 R2 - 2016 ? ?
Cloud
Azure SQL Database ?
SQL Server on Amazon RDS ?
Database development models
Dedicated ? ?
Shared ? ?
Features
Branching / merging ? ?
Change log ? ?
Checking out and locking objects ? ?
Ignore comparison and synchronization options ? ?
Migration scripts ? ?
Object filtering ? ?
Revision history ? ?
Static data ? ?
Working folder ? ?
Built-in difference merging ?
Check out and lock policies ?
Database level object status ?
Labels ?
Object check out ?
Source control system support
Git
Subversion
Team Foundation Server
SourceGear Vault
Mercurial Native CLI
Perforce
Roadmap
Associate work item ID with commit
Link the committed changeset with the specified work item ID on TFS
Branching and merging support
Create new Git branch and merge projects from different branches directly from SQL Server Management Studio
SSDT projects support
Work with SQL Server Data Tools (SSDT) projects from SQL Server Management Studio