flyway

Project Information

Project feeds
Code license
Apache License 2.0
Labels
Database, migration, Java, DB2, SQL, flyway, MySQL, oracle, hsqldb, h2, Ant, Agile, PostgreSQL, Maven, SQLServer

Members

axel.fontaine.business@gmail.com

christia...@gmail.com

chris.we...@gmail.com

15 contributors

Featured

Downloads

Wiki pages

Links

New: Are you using Flyway in Production? We would LOVE to hear about it! More info

The agile database migration framework for Java

Latest Version

Flyway 1.6.1 (Released 2012-04-21) - Download - Release Notes

Highlights

It just works - Refreshingly simple. Migrate from any version (incl. an empty database) to the latest version of the schema.

Automatic migration on startup - Ship migrations together with the application and run them automatically on startup using the API.

Convention Over Configuration - Classpath Scanning to automatically discover Sql and Java migrations

Plain Old Sql - SQL scripts for regular migrations (incl. placeholder replacement). No proprietary XML formats, no lock-in.

No limits - Java classes for advanced migrations

Highly reliable - Safe for cluster environments (Multiple machines can migrate in parallel)

Build tool support - Maven plugin and Ant tasks for migrating manually

Not only for Java - Command-line tool for non-JVM users and environments without Maven

Fail fast - Inconsistent database or failed migration prevents app from starting.

Schema Clean - Drop all tables, views, triggers, ... from a schema without dropping the schema itself

Features

	Flyway	Liquibase	c5-db-migration	dbdeploy	mybatis	MIGRATEdb	migrate4j	dbmaintain	AutoPatch
Migration types
Plain Old Sql migrations		⁽¹⁾
Java migrations		⁽¹⁾
Groovy migrations
Xml migrations
DDL abstraction DSL
Execution
Migrate from within application (API)
Maven plugin
Ant tasks
Command-line tool
Databases
Oracle
SQL Server
DB2
MySQL
PostgreSQL
H2
Hsql
Derby
Sql Parser
Oracle PL/SQL		⁽²⁾
SQL Server T-SQL		⁽²⁾
DB2 SQL PL		⁽²⁾
MySQL stored procedures		⁽²⁾						⁽³⁾
PostgreSQL stored procedures		⁽²⁾
Other
Automatic creation of metadata table
Cluster-safe
Checksum validation
Placeholder replacement
Multiple schema support
Clean existing schema
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.}

Installation

Both Flyway, the Flyway Maven Plugin and the Flyway Ant Tasks are available from Maven Central.

Alternatively you can also use the download page.

Just add this to your POM and you're good to go:

<dependency>
    <groupId>com.googlecode.flyway</groupId>
    <artifactId>flyway-core</artifactId>
    <version>1.6.1</version>
</dependency>

Flyway Maven Plugin

<plugin>
    <groupId>com.googlecode.flyway</groupId>
    <artifactId>flyway-maven-plugin</artifactId>
    <version>1.6.1</version>
    <configuration>
        ....
    </configuration>
</plugin>

Maven plugin configuration and goal info available here

Flyway Ant Tasks

For Ant and Ivy simply add the following line to your ivy.xml

<dependency org="com.googlecode.flyway" name="flyway-ant" rev="1.6.1"/>

Requirements

Java 5+
Spring Jdbc 2.5+
Jdbc driver for your database

Supported Databases

Oracle 10g and later
SQL Server 2008 and later
DB2 9.7 and later
MySQL 5.1 and later
Google Cloud SQL 1.6 and later
PostgreSQL 9.0 and later
HsqlDb 1.8 and later
H2 1.2.137 and later
Derby 10.8.2.2 and later

More info available here