Version control tools for Azure SQL Database
List of source version control tools .
State-based tools - generate the scripts for database upgrade by comparing database structure to the model (etalon).
Migration-based tools - help/assist creation of migration scripts for moving database from one version to next.
Visual Studio - SQL Server Data Tools
Visual Studio supports SQL Server Data Tools (SSDT) that includes a Schema Compare utility that you can use to compare two database definitions. The source and target of the comparison can be any combination of a connected database or SQL Server database project. The comparison results appear as a set of actions that must be taken with the target to make it the same as the source. Once the comparison is complete you can update the target directly or generate an update script that has the same effect.
Generate change script: | |
---|---|
Runs on: (for desktop): | Mac OS,Windows |
Type: | State-based tools |
Repositories: | - |
Commercial: | Commercial |
Free edition: |
Redgate SQL Source Control
Redgate SQL Source Control enables version control schemas and reference data, roll back changes, and maintain the referential integrity of your database. You can manage pre & post deployment scripts within SQL Source Control to automate SQL changes when deploying.
Generate change script: | |
---|---|
Runs on: (for desktop): | Windows |
Type: | State-based tools |
Repositories: | Database |
Commercial: | Commercial |
Free edition: |
ApexSQL Source Control
ApexSQL Source Control is a Microsoft SQL Server Management Studio add-in, which integrates source control with SQL Server database development. It allows to source control SQL databases and objects directly from inside SSMS. The tool quickly setup source control connections and filter objects that will be version controlled.
Generate change script: | |
---|---|
Runs on: (for desktop): | Windows |
Type: | Migration-based tools |
Repositories: | Database |
Commercial: | Commercial |
Free edition: |
DB Ghost Change Manager
DB Ghost Change Manager includes tools that allow you to script out your databases into individual DROP/CREATE scripts, place those scripts under source control, modify them there and then build and deploy from those scripts. Once a database has been successfully scripted and placed under source control it can then be regarded as the "source database".
Generate change script: | |
---|---|
Runs on: (for desktop): | Windows |
Type: | State-based tools |
Repositories: | Database |
Commercial: | Commercial |
Free edition: |
Flyway
Flyway provides version control for your database so you can migrate it with ease and confidence. Migrations can be written in SQL (database-specific syntax (such as PL/SQL, T-SQL, ...) is supported) or Java (for advanced data transformations or dealing with LOBs).
Generate change script: | |
---|---|
Runs on: (for desktop): | Linux,Mac OS,Windows |
Type: | Migration-based tools |
Repositories: | File |
Commercial: | Commercial |
Free edition: |
yuniql
yuniql is an open source schema versioning and migration tool made with .NET Core. Deploy fresh databases fast using plain-SQL, seed lookup tables and test data from CSV and run environment-specific migrations. yuniql is released as stand-alone .exe app (no CLR needed!), Azure DevOps Pipelines Tasks, .NET Core tool, nuget package and Docker container.
Generate change script: | - |
---|---|
Runs on: (for desktop): | Linux,Windows |
Type: | Migration-based tools |
Repositories: | - |
Commercial: | Free |
Free edition: |
DB Version Control
SSMS plugin to version control SQL Server database - tracks database changes and generates migrations for both schema objects and static data. Scripts schema objects and static data into individual files for change tracking. To be used with any version control system (GIT, TFS, SVN, etc.)
Generate change script: | |
---|---|
Runs on: (for desktop): | - |
Type: | - |
Repositories: | - |
Commercial: | Commercial |
Free edition: |