4 Version Control tools for Azure SQL Database

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

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

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

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

Share