Kalpana Kalpana (Editor)

Flyway (software)

Updated on
Edit
Like
Comment
Share on FacebookTweet on TwitterShare on LinkedInShare on Reddit
Developer(s)
  
Boxfuse GmbH

Written in
  
Java

Type
  
Software Development

Development status
  
Active

Operating system
  
Cross-platform

Stable release
  
4.1.1 / February 16, 2017 (2017-02-16)

Flyway is an open source database migration tool. It strongly favors simplicity and convention over configuration.

Contents

It is based around 6 basic commands: Migrate, Clean, Info, Validate, Baseline and Repair.

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).

It has a Command-line client, a Java API (also works on Android) for migrating the database on application startup, a Maven plugin, Gradle plugin, SBT plugin and Ant tasks.

Plugins are available for Spring Boot, Dropwizard, Grails, Play, Griffon, Grunt, Ninja and more.

Supported databases are Oracle, SQL Server, SQL Azure, DB2, DB2 z/OS, MySQL (including Amazon RDS), MariaDB, Google Cloud SQL, PostgreSQL (including Amazon RDS and Heroku), Redshift, Vertica, EnterpriseDB, H2, Hsql, Derby, SQLite, SAP HANA, solidDB, Sybase ASE and Phoenix.

Adoption

Flyway has been widely adopted in the industry, with 1,600,000 downloads in 2016 alone.

In January 2015, Flyway was placed in the "Adopt" section of the Thoughtworks Technology Radar.

  • Liquibase
  • References

    Flyway (software) Wikipedia