Connect to your SQL Database to Version Control System

dbForge Source Control is a powerful SSMS add-in for managing SQL Server database changes in version control systems. The tool allows version-controlling schemas and reference data, roll back changes, and maintain the referential integrity of your SQL databases. The tool can also solve other database challenges, including deployment without losing data.

Supported Source Control Systems

Subversion (SVN)

Team Foundation Server (including TFS Cloud)

Git (including GitHub)

Perforce(P4)

Mercurial

SourceGear Vault

Version Control Scripts in Working Folders

A working folder contains SQL script files that represent your database. It allows you to script database changes to a database folder. After saving changes, the database working folder can be source-controlled with your version control system in the same way you version-control other files.

Source-Controlling a Working Folder

Handle Changes in Source Control Manager

Perform essential SQL version control tasks visually in a handy interface. In particular, the Source Control Manager allows you to:

  • Commit. Updates source control with your local changes. Created and modified objects will be scripted and put into the repository. Dropped objects will be excluded from the repository.
  • Get Latest. Updates database with the latest changes from source control. Database objects can be created, modified or dropped during that process.
  • Resolve conflicts. Conflict is a result of discrepancy between the latest version of an object in source control and the one in local database. You can resolve it in two ways:
    • Your version of an object will be committed to source control.
    • Your changes will be discarded. The local database will be updated with the latest version of an object from source control.
Source Control Manager

View Changes History

The Changes History document allows you to:

  • View changes history for the entire SQL database or for separate database objects.
  • View details of each commit, including revision ID, date, author and comments.
  • View list of objects that were modified in each commit.
  • View DDL differences for each object.
  • Compare revisions.
Changes History Document

Roll Back Unwanted Changes

The tool allows you to easily cancel any local changes you don't want to commit. Just select the changes you want to roll back the Local changes section of Source Control Manager, and click Undo.

Undoing Changes
Developer Bundle Save up to 25

dbForge Developer Bundle for SQL Server

Source Control is a part of dbForge Developer Bundle for SQL Server – an ultimate kit of fourteen database development and management tools for SSMS. Purchasing the single kit will save you 50% of the cost of each tool as compared to purchasing them individually.


Discount Programs

Takes part in DevOps Automation

Use Source Control along with dbForge DevOps Automation for SQL Server to extend the DevOps approach to SQL Server databases. The solution makes it easy to integrate SQL Server database into the DevOps process without compromising quality, performance, or reliability.

Dev Ops