Link your SQL Database to Version Control System

dbForge Source Control is a convenient SSMS add-in for SQL Server database change management in popular version control systems, including Git (including GitHub), TFS, SVN, Mercurial. The tool allows version-controlling database 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 data loss.

  • Version-control database schemas and table static data
  • Use either dedicated, or shared development models
  • Commit and revert changes with dependency awareness
  • View conflicts and resolve data and schema inconsistencies visually
  • Track the changes made and detect who, when, and why made them
  • Plug source control directly into SQL Server Management Studio
  • Automate database development with DevOps approach

Supported Source Control Systems

Subversion (SVN)
SVN
Team Foundation Server (including TFS Cloud)
TFS
Git (including GitHub)
Git
Perforce(P4)
Perforce
Mercurial
Mercurial
SourceGear Vault
SourceGear Vault
Features

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 as you version-control other files.

Version Control Scripts in Working Folders

Handle changes in Source Control Manager

Perform essential SQL version control tasks visually in a handy interface, including:

  • Commit. Updates source control with your local changes.
  • Get Latest. Updates database with the latest changes from source control.
  • Resolve conflicts. You can resolve discrepancies between the latest version of an object in source control and the one in local database in two ways:
    • Get Local. Your version of an object will be committed to source control.
    • Get Remote. Your changes will be discarded. The local database will be updated with the latest version of an object from source control.
Handle Changes in Source Control Manager

Version-control schemas and reference data

Store and share any SQL Server object and static data. With dbForge Source Control, you can:

  • Link static data to repository.
  • Commit, revert, and get latest static data changes.
  • Handle static data conflicts.
Working with static data

View changes history

Look through a full revision history of a database or a certain database object with the Changes History document. You can clearly see the changes made as well as who, when, and why made them.
View Changes History

Work on a central database or your own local copy

Source Control for SQL Server supports two models for database development, Dedicated and Shared.

  • Dedicated model allows developers work with their own copies of the database
  • Shared model suggests that all developers work on a single shared database.

Regardless of the choice of the database development model, Source Control for SQL Server ensures safe and convenient data changes management.

Work on a central database or your own local copy

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.

Roll Back Unwanted Changes

Source Control is a part of SQL Tools

SQL Tools includes a pack of essential SSMS add-ins and tools

Find out more

Get Started with Source Control for SQL Server at no cost

Download a FREE 30-day trial of the tool, and start saving time and efforts with your SQL database deployments right away.

Download free

Buy multi-user licenses with substantial discount

We provide flexible purchase options, including bulk discounts, to meet the need and budget of each and every customer.

Purchase now

Need a hand?

If you need any help or have questions about Devart tools or purchasing options, do not hesitate to get in touch with us.

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.

Explore
dbForge DevOps Automation for SQL Server

We use cookies to provide you with a better experience on the Devart website. You can read more about our use of cookies in our Cookies Policy.
Click OK to continue browsing the Devart site. Be aware you can disable cookies at any time.