Flyway (software)
| Company type | Open-source software |
|---|---|
| Industry | Software |
| Founder | Redgate |
| Products | Database migration utility |
| Parent | Redgate |
Flyway is a database migration utility available as open-source software, created by Redgate.
Concept
Flyway functions through seven primary commands: Migrate, Clean, Info, Validate, Undo, Baseline, and Repair. It supports migrations written in SQL, including specialized dialects such as PL/SQL and T-SQL, as well as Java for more complex migration needs.
The tool provides a command-line interface, a Java API compatible with Android, and integrates via plugins with build tools like Apache Maven and Gradle, along with frameworks including Spring Boot, Dropwizard, Grails, Play, among others.
Flyway is compatible with a wide range of database systems such as Oracle, SQL Server, DB2, MySQL (including variants like Amazon RDS, Aurora MySQL, and MariaDB), Percona XtraDB, PostgreSQL (covering Amazon RDS and Heroku), Aurora PostgreSQL, YugabyteDB, CockroachDB, Redshift, Informix, H2, Hsql, Derby, SQLite, SAP HANA, Sybase ASE, Phoenix, and Firebird.
Adoption
By 2018, Flyway had been downloaded 11.5 million times. It was featured in the "Adopt" segment of the Thoughtworks Technology Radar in January 2015. In July 2019, Redgate acquired Flyway, enhancing their portfolio in database migration technologies.