Version control tools for H2
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.
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: |
|
Apricot DB
Git based project/snapshot synchronization
| Generate change script: |
|
|---|---|
| Runs on: (for desktop): | Windows |
| Type: | State-based tools |
| Repositories: | - |
| Commercial: | Free |
| Free edition: |
|
Amazon Redshift
Azure SQL Database
DBT
Google Big Query
IBM DB2
MariaDB
SAP HANA
Snowflake
SQLite
Teradata