Reference articles on history, science, culture and more
Encyclopedia

Flyway (software)

Database migration tool

Image credit is listed at the end of this article.

Flyway is an open-source database-migration tool.

01Concept

Flyway is based around seven basic commands: Migrate, Clean, Info, Validate, Undo, Baseline, and Repair.

Migrations can be written in SQL (database-specific syntax such as PL/SQL, T-SQL, etc 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, and a Gradle plugin.

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

Supported databases include Oracle, SQL Server, DB2, MySQL (including Amazon RDS, Aurora MySQL, MariaDB), Percona XtraDB, PostgreSQL (including Amazon RDS and Heroku), Aurora PostgreSQL, YugabyteDB, CockroachDB, Redshift, Informix, H2, Hsql, Derby, SQLite, SAP HANA, Sybase ASE, Phoenix, Firebird and TiDB.

02Adoption

Flyway received 11,500,000 downloads in 2018.

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

In July 2019, Flyway was acquired by Redgate.

Watch videos about Flyway (software)Explainers and documentaries on YouTube (opens in a new tab)

Sources and credits

This article is adapted from the Wikipedia article Flyway (software), written by its contributors and licensed under CC BY-SA 4.0. Fathomly has changed the layout, removed citation markers, navigation and maintenance notices, and adjusted punctuation. This adapted version is shared under the same license. For references, see the original article.

Images, from Wikimedia Commons:

Fathomly is not affiliated with or endorsed by the Wikimedia Foundation. Spotted a problem? Tell us.