For the best web experience, please use IE11+, Chrome, Firefox, or Safari
Free Trials Request Pricing
Home / SQL source control

SQL source control

ApexSQL Source Control is a SQL Server Management Studio (SSMS) add-in to version control SQL databases and objects. It integrates with all major source control systems and allows database developers to work together on a shared or a dedicated database copy. ApexSQL Source Control provides full object versioning features such as object locking with team policies management, detailed view of changes history, conflict resolution, labeling and more.


An introduction to ApexSQL Source Control 06:20
Download Free Trial

Nav Menu

SQL source control

Benefits

  • 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 labels from source control

  • Create branch or merge branches directly from SSMS

  • Associate a changeset with a TFS work item

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. Learn more

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. Learn more

Object filtering

Exclude database or repository only objects from source control by schema, type or specific objects. Learn more

Action center

Work with the latest object changes in real time. Learn more

Checking out and locking objects

Check out and lock objects in order to prevent others from making changes. Learn more

Changes rollback

Undo the latest changes made against selected objects. Learn more

Historical view

See the complete history of all committed object changes. Learn more

Labels

Create labels and get by label easily. Learn more

Database development policies

Set source control implementation rules by using policies. Learn more

Object status

See the current status of objects in a shared database. Learn more

Offline mode

Ability to work offline for distributed source control systems. Learn more

Related Topics

ApexSQL Source Control 2018 – Screen shot tour

ApexSQL Source Control 2018 – Screen shot tour

This article represents a screen shot tour of ApexSQL Source Control features with a brief description
Action center

Action center

This video explores Action center, a feature in ApexSQL Source Control that is used as a communication channel between a versioned database and its respective source control repository
How to utilize branching in Git

How to utilize branching in Git

This video shows how to use the Git branching feature in ApexSQL Source Control
Revision history

Revision history

This video shows how to review the history of committed changes and a way to compare any specific version of an object with a version from another changeset, or a database version
Working with ApexSQL Source Control in the shared model – Database change log

Working with ApexSQL Source Control in the shared model – Database change log

This video shows how to use the ApexSQL Source Control Change log feature in order to keep track of all the DDL changes made against a database
SQL Server Source control – Part I – understanding source control basics

SQL Server Source control – Part I – understanding source control basics

This article helps you to understand source control basics
How to see the full version history of a SQL Server database object under source control and, if needed, revert changes

How to see the full version history of a SQL Server database object under source control and, if needed, revert changes

This article describes how to see the full version history of a SQL Server database object under source control and revert changes by using ApexSQL Source Control
How to maintain SQL database changes working with Git branches

How to maintain SQL database changes working with Git branches

This article describes Git branching basics and how to utilize Git branching through ApexSQL Source Control
Advantages of ApexSQL Source Control – Part 1

Advantages of ApexSQL Source Control – Part 1

This blog article is a short overview of some key/unique features and/or the important advantages of ApexSQL Source Control vs other tools
How to implement SQL Server source control using the dedicated development model

How to implement SQL Server source control using the dedicated development model

This article gives an overview of the dedicated model and how to use ApexSQL Source Control to meet the given requirement
How to implement SQL Server source control using the shared development model

How to implement SQL Server source control using the shared development model

This article gives an overview of the shared model and how to use ApexSQL Source Control to meet the given requirement
How to link a SQL Server database to a Team Foundation Server repository

How to link a SQL Server database to a Team Foundation Server repository

This article describes how to link a database to a Team Foundation Server (TFS) repository as well as which permissions are required for the TFS user in order to link a database and use TFS projects
git,
mercurial
perforce
subervsion
azure devops gray

Testimonials

Hobbyist/OSS developer

I've been quite happy with the ApexSQL Source Control tool.

Bryan Johns Hobbyist/OSS developer

Linear Code

We are really satisfied with ApexSQL Source Control tool and really pleased to be part of your success. Congratulations!

Felipe Souza Linear Code

Exabyte Development

I find ApexSQL Source Control absolutely essential to have proper functionality in place to manage auditing of database object changes (who changed what and when), versioning (enabling reverting to any version of a database object) and controls enabling multiple developers to safely work on the same database. Source Control from ApexSQL achieves this and is affordable, is maturing rapidly by developers who have a passion to see their software surpass their competitors, and support is always impeccable. I recommend this software and company to all of my clients.

Robert Blomstrand Senior Database and .Net Developer Consultant

Dual Commercial, Inc.

I’m very pleased with ApexSQL Source Control. Glad to have our SQL in Source Control, and it works great for me to capture and safely track changes made by some of our power users without them having to be directly involved.

Lee Morrison Director of Software Development

R&B Solutions

Liked how ApexSQL Source Control hooked up to TFS quickly and tracked the source changes of the various objects I altered during my testing. In addition, ApexSQL Source Control is very fast to install and link to the databases on my SQL instance. We created a custom tool to do something similar to this, and it was a pain to manage. With ApexSQL Source Control, it takes all of the guess work out of SC.

Rick Olsen Manager of Application Development

CTO

We have been searching for a way to keep track of SQL database changes across our dev team without pulling our hair out. ApexSQL Source Control works straight away - no hassles. As a developer, if I cannot get a tool to work quickly - I move on. We had a narrow focus, but ApexSQL Source Control did everything we wanted. SQL database objects have caused us a lot of grief and ApexSQL Source Control helps tremendously.

Wade Burdette CTO

Other source control tools

Builds
Data comparison
Schema comparison
Scripting
Database DevOps
Create a SQL database from any input; automate builds from source control

Create a SQL database from any input; automate builds from source control

  • Create executable installation packages
  • Consolidate multiple SQL scripts
  • Ensure error free deployments
  • Deploy databases directly from SQL source control
  • Build databases from scripts, source control, etc
  • Preview the script impact by action or SQL object

ApexSQL Source Control is part of the ApexSQL DevOps toolkit

Learn More
ApexSQL Source Control is part of the ApexSQL DevOps toolkit

Get started now

Seamlessly integrate SQL source control with SQL Server Management Studio (SSMS).
Download Free Trial