The agile database migration framework for Java
It just works. Refreshingly simple.
Migrate from any version (incl. an empty database) to the latest version of the
schema
Plain Old Sql
Plain SQL scripts (incl. placeholder replacement). No proprietary XML formats, no lock-in.
Zero required dependencies
All you need is Java 5+ and your Jdbc driver and you're good to go!
Convention Over Configuration
Classpath Scanning to automatically discover Sql and Java migrations
Auto-migration on startup
Ship migrations together with the application and run them automatically on startup using the API
Fail fast
Inconsistent database or failed migration prevents app from starting.
Your relational database. Supported.
Choose from the wide range of supported databases
Feature Comparison
Pick the right tool for the job.
| Flyway | Liquibase | c5-db-migration | dbdeploy | mybatis | MIGRATEdb | migrate4j | dbmaintain | AutoPatch | |
Migration types |
|||||||||
| Plain Old Sql migrations | 1 | ||||||||
| Java migrations | 1 | ||||||||
| Groovy migrations | |||||||||
| Xml migrations | |||||||||
| DDL abstraction DSL | |||||||||
Execution |
|||||||||
| API | |||||||||
| Maven plugin | |||||||||
| Ant tasks | |||||||||
| Command-line tool | |||||||||
Databases |
|||||||||
| Oracle | |||||||||
| SQL Server | |||||||||
| DB2 | |||||||||
| MySQL | |||||||||
| PostgreSQL | |||||||||
| H2 | |||||||||
| Hsql | |||||||||
| Derby | |||||||||
Sql Parser |
|||||||||
| Oracle PL/SQL | 2 | ||||||||
| SQL Server T-SQL | 2 | ||||||||
| DB2 SQL PL | 2 | ||||||||
| MySQL stored procedures | 2 | 3 | |||||||
| PostgreSQL stored procedures | 2 | ||||||||
Other |
|||||||||
| Auto creation of schema | |||||||||
| Auto creation of metadata table | |||||||||
| Cluster-safe | |||||||||
| Checksum validation | |||||||||
| Placeholder replacement | |||||||||
| Multiple schema support | |||||||||
| Clean existing schema | |||||||||
| Output to SQL file | |||||||||
| Available on Maven Central | |||||||||
| License | Apache v2 | Apache v2 | Apache v2 | BSD | Apache v2 | BSD | LGPL v3 | Apache v2 | Apache |
1. Sql files and Java classes can be used indirectly through references in xml migrations
2. Only a single statement at a time is supported. No mixed delimiters.
3. Only Oracle-style PL/SQL delimeters. No MySQL standard syntax using the DELIMITER statement.
Ready to get started?
Pick any of these to learn more.
© 2010-2013 Axel Fontaine and the many contributors. Made with <3 in München.
Icons from Glyphicons Free,
licensed under CC BY 3.0