SQL Server
Oracle
MySQL
PostgreSQL
Amazon Redshift
Azure SQL Database
DBT
Google Big Query
IBM DB2
MariaDB
SAP HANA
Snowflake
SQLite
Teradata
Vertica
Version control tools
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: |
|
dbForge Source Control
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.
| Generate change script: |
|
|---|---|
| Runs on: (for desktop): | Windows |
| Type: | State-based tools |
| Repositories: | File |
| 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: |
|
Source Control for Oracle
Source Control for Oracle provides a convenient platform for version-control your schemas and static data with Git, SVN, and TFS. You can continue making changes in your IDE without the need to work on separate script files, so there's no disruption to the way you work.
| Generate change script: |
|
|---|---|
| Runs on: (for desktop): | Windows |
| Type: | State-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: |
|
Version SQL
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. It enables hassle-free change tracking for stored procedures, views, table schema, etc. by checking them into your source control repository.
| Generate change script: |
|
|---|---|
| Runs on: (for desktop): | Windows |
| Type: | State-based tools |
| Repositories: | Database |
| Commercial: | Commercial |
| Free edition: |
|
DBmaestro Source Control
DBmaestro Source Control manages and documents all changes made to database code, structure, and content across all teams. The Version Control Module validates database changes against schemas and relevant content while preventing unauthorized and out-of-process changes.
| Generate change script: |
|
|---|---|
| Runs on: (for desktop): | Linux,Mac OS,Windows |
| Type: | State-based tools |
| Repositories: | Database |
| Commercial: | Commercial |
| Free edition: |
|
Liquibase
Liquibase is an open source database-independent library for tracking, managing and applying database schema changes. It has the ability to roll changes back and forward from a specific point. It makes it easy to define database changes in a format that's familiar and comfortable to each user and then automatically generates database-specific SQL for you.
| Generate change script: |
|
|---|---|
| Runs on: (for desktop): | Linux,Mac OS,Windows |
| Type: | - |
| Repositories: | - |
| Commercial: | Free |
| 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: |
|
FluentMigrator
FluentMigrator is a migration framework for .NET. Database schema changes are described in classes written in C# that can be checked into a version control system.
| Generate change script: |
|
|---|---|
| Runs on: (for desktop): | Windows |
| Type: | Migration-based tools |
| Repositories: | File |
| Commercial: | Free |
| Free edition: |
|
Ruby on Rails Migrations
Ruby on Rails Migrations enables to use Ruby for defining database schema changes, which makes it convenient to use a version control system for maintaining synchronization with the actual code.
| Generate change script: |
|
|---|---|
| Runs on: (for desktop): | Linux,Mac OS,Windows |
| Type: | Migration-based tools |
| Repositories: | Database |
| Commercial: | Free |
| Free edition: |
|
DBGeni
DBGeni helps to manage database migrations that include applying and rolling them back to move your database from version to version easily. If you follow a few opinionated rules, DBGeni knows where to find your migrations scripts, the order to run them and what still needs to be applied.
| Generate change script: |
|
|---|---|
| Runs on: (for desktop): | Linux,Windows |
| Type: | Migration-based tools |
| Repositories: | Database |
| Commercial: | Free |
| Free edition: |
|
Sqitch
Sqitch is a database change management application. Changes are implemented as scripts native to your selected database engine. It manages changes and dependencies via a plan file and employs a Merkle tree pattern similar to Git and Blockchain to ensure deployment integrity.
| Generate change script: |
|
|---|---|
| Runs on: (for desktop): | Linux,Mac OS,Windows |
| Type: | - |
| Repositories: | Database |
| Commercial: | Free |
| Free edition: |
|
Idera DB Change Manager
DB Change Manager puts the power of change tracking, schema comparison, software-generated synchronization scripts, and flexible reporting into the hands of DBAs and developers. It captures and compares schema differences between one or more archived or live databases, handles object dependencies and preserves data. It also generates alter scripts to sync selected objects or restore to a prior state.
| Generate change script: |
|
|---|---|
| Runs on: (for desktop): | Windows |
| Type: | State-based tools |
| Repositories: | Database |
| Commercial: | Commercial |
| Free edition: |
|
