Easy to setup, simple to master. Flyway lets you regain control of your database migrations with pleasure and plain sql.
Solves only one problem and solves it well. Flyway migrates your database, so you don't have to worry about it anymore.
Made for continuous delivery. Let Flyway migrate your database on application startup. Releases have never been this easy.
For non-JVM users and environments without build tools
> flyway migrate -url=... -user=... -password=...Get Started with the Command-line Tool
Migrate directly from within your application
Flyway flyway = new Flyway(); flyway.setDataSource(url, user, password); flyway.migrate();Get Started with the Java API
Seamless integration with Maven 2/3 builds
> mvn flyway:migrate -Dflyway.url=... -Dflyway.user=... -Dflyway.password=...Get Started with the Maven Plugin
Seamless integration with Gradle builds
> gradle flywayMigrate -Dflyway.url=... -Dflyway.user=... -Dflyway.password=...Get Started with the Gradle Plugin
Antlib with tasks for Ant 1.8 and above
<flyway:migrate url="..." user="..." password="..."/>Get Started with the Ant Tasks
First class SBT integration
> sbt flywayMigrate -Dflyway.url=... -Dflyway.user=... -Dflyway.password=...Get Started with the SBT plugin
Plain SQL scripts (incl. placeholder replacement). No proprietary XML formats, no lock-in.
Java-based migrations for advanced data transformations and handling with LOBs
All you need is Java 6+ and your Jdbc driver and you're good to go!
Classpath Scanning to automatically discover Sql and Java migrations
Safe for cluster environments (Multiple machines can migrate in parallel)
Ship migrations together with the application and run them automatically on startup using the API
Inconsistent database or failed migration prevents app from starting.
Drop all tables, views, triggers, ... from a schema without dropping the schema itself
|Plain Old Sql migrations||1|
|DDL abstraction DSL|
|SQL Server T-SQL||3|
|DB2 SQL PL||3|
|MySQL stored procedures||3||4|
|PostgreSQL stored procedures||3|
|Auto creation of schema|
|Auto creation of metadata table|
|Multiple schema support|
|Clean existing schema|
|Output to SQL file|
|Available on Maven Central|
|License||Apache v2||Apache v2||Apache v2||LGPL||Apache v2||BSD||LGPL v3||Apache v2||Apache|