15 Database Version Control Tools

This is the list of source version control tools for databases.
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.

Share

Visual Studio database project

msdn.microsoft.com/en-us/library/hh272690(v=vs.103).aspx

Type: State-based

Supports databases: SQL Server, Azure SQL Database

Supports repositories: Team Foundation Server, git

more...

Commercial/Free: Commercial

Free edition: yes

Redgate SQL Source Control

www.red-gate.com/products/sql-development/sql-source-control/

Plugs into SQL Server Management Studio: SSMS 2017, SSMS 2016, SSMS 2014, SSMS 2012 [version 5.8 of SQL Source Control no longer supports SSMS 2008]

Type: State-based

Supports databases: SQL Server

Supports repositories: Team Foundation Server, Subversion, git, Mercurial, Perforce, SourceGear Vault, Working Folder

Notable features: Locking objects in Shared model

more...

Commercial/Free: Commercial

Free edition: no, Pricing from: $495

dbForge Source Control

www.devart.com/dbforge/sql/source-control/

Plugs into Microsoft SQL Server Management Studio: SSMS 2016, SSMS 2014, SSMS 2012

Type: State-based

Supports databases: SQL Server

Supports repositories: Team Foundation Server, Subversion, git, Mercurial, Perforce, SourceGear Vault, Working Folder

more...

Commercial/Free: Commercial

Free edition: no, Pricing from: $250

ApexSQL Source Control

www.apexsql.com/sql_tools_source_control.aspx

Plugs into Microsoft SQL Server Management Studio: SSMS 2016, SSMS 2014, SSMS 2012

Type: State-based

Supports databases: SQL Server, Azure SQL Database, SQL Server on Amazon RDS

Supports repositories: Team Foundation Server, Subversion, git, Mercurial, Perforce, Working Folder

Notable features: Labels - representing a snapshot of current state of all objects in source control repository. Database development policies - possibility to establish and enforce behaviors among developers regarding source control, for example mandatory locking of files on checkout.

more...

Commercial/Free: Commercial

Free edition: no, Pricing from: $299

Source Control for Oracle

www.red-gate.com/products/oracle-development/source-control-for-oracle/

Type: State-based

Supports databases: Oracle

Supports repositories: Subversion, Team Foundation Server

more...

Commercial/Free: Commercial

Free edition: no, Pricing from: $369

DB Ghost Change Manager

www.dbghost.com

More of a schema compare tool

Type: State-based

Supports databases: SQL Server, Azure SQL Database

Supports repositories: Any (manual process)

more...

Commercial/Free: Commercial

Free edition: no, Pricing from: $550

Version SQL

www.versionsql.com/

VersionSQL is the straightforward SQL Server version control add-in. It's made to do one thing and do it well: Commit SQL to Git and Subversion source control repositories. Plugs into Microsoft SQL Server Management Studio: SSMS 2017, SSMS 2016, SSMS 2014, SSMS 2012

Type: State-based

Supports databases: SQL Server

Supports repositories: Git, Subversion

more...

Commercial/Free: Commercial

Free edition: yes, Pricing from: $149

DBmaestro Source Control

www.dbmaestro.com/database-source-control/

Type: State-based

Supports databases: Oracle, SQL Server

more...

Commercial/Free: Commercial

Free edition: no

Liquibase

www.liquibase.org/

Migrations (changelog) can be written in XML, YAML, JSON or SQL format.

Type: Migration-based

Supports databases: MySQL, PostgreSQL, Oracle, SQL Server, SAP ASE, SAP SQL Anywhere, DB2, Apache Derby, HSQL, H2, Informix, Firebird, SQL Lite

more...

Commercial/Free: Free

Free edition: yes

Flyway

flywaydb.org/

Migrations can be written in SQL or Java

Type: Migration-based

Supports databases: Oracle, SQL Server, Azure SQL Database, DB2, MySQL, MariaDB, Google Cloud SQL, PostgreSQL, Amazon Redshift, Vertica, H2, HyperSQL, Derby, SQLite, SAP HANA, solidDB, SAP ASE, Phoenix, EnterpriseDB, Greenplum

more...

Commercial/Free: Free

Free edition: yes

FluentMigrator

github.com/fluentmigrator/fluentmigrator

Migration framework for .NET. Database schema changes are described in classes written in C# that can be checked into a version control system.

Type: Migration-based

Supports databases: SQL Server, PostgreSQL, MySQL, Oracle, Jet, SQLite, SAP HANA

more...

Commercial/Free: Free

Free edition: yes

Ruby on Rails Migrations

guides.rubyonrails.org/v3.2/migrations.html

Type: Migration-based

Supports databases: MySQL, PostgreSQL, SQLite, SQL Server, Oracle

more...

Commercial/Free: Free

Free edition: yes

DBV

dbv.vizuina.com/

Type: Migration-based

Supports databases: MySQL

more...

Commercial/Free: Free

Free edition: yes

DBGeni

dbgeni.appsintheopen.com/index.html

Type: Migration-based

Supports databases: SQLite, Oracle, MySQL, SAP ADS

more...

Commercial/Free: Free

Free edition: yes

Sqitch

sqitch.org/

Type: Migration-based

Supports databases: PostgreSQL, SQLite, MySQL, Oracle, Firebird, Vertica

more...

Commercial/Free: Free

Free edition: yes

Last research made on 31 August 2017

Share