# Flyway (software)

> Mediated Wiki article. Canonical URL: https://mediated.wiki/source/Flyway_(software)
> Markdown URL: https://mediated.wiki/source/Flyway_(software).md
> Source: https://en.wikipedia.org/wiki/Flyway_(software)
> Source revision: 1356813963
> License: Creative Commons Attribution-ShareAlike 4.0 International (https://creativecommons.org/licenses/by-sa/4.0/)

**Flyway** is an [open-source](/source/Open-source_software) [database-migration](/source/Schema_migration) tool.

## Concept

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

Migrations can be written in [SQL](/source/SQL) (database-specific syntax such as [PL/SQL](/source/PL/SQL), [T-SQL](/source/T-SQL), etc is supported) or [Java](/source/Java_(programming_language)) (for advanced data transformations or dealing with LOBs).

It has a command-line client, a Java API (also works on [Android](/source/Android_(operating_system))) for migrating the database on application startup, a [Maven](/source/Apache_Maven) plugin, and a [Gradle](/source/Gradle) plugin.

Plugins are available for [Spring Boot](/source/Spring_Boot),[1] Dropwizard, [Grails](/source/Grails_(framework)), [Play](/source/Play_Framework), [SBT](/source/SBT_(software)), [Ant](/source/Apache_Ant), [Griffon](/source/Griffon_(framework)), [Grunt](/source/Grunt_(software)), [Ninja](/source/Ninja_(build_system)), and more.[2]

Supported databases include [Oracle](/source/Oracle_Database), [SQL Server](/source/Microsoft_SQL_Server), [DB2](/source/IBM_Db2), [MySQL](/source/MySQL) (including [Amazon RDS](/source/Amazon_RDS), Aurora MySQL, [MariaDB](/source/MariaDB)), Percona XtraDB, [PostgreSQL](/source/PostgreSQL) (including [Amazon RDS](/source/Amazon_RDS) and [Heroku](/source/Heroku)), Aurora PostgreSQL, [YugabyteDB](/source/YugabyteDB), [CockroachDB](/source/CockroachDB), [Redshift](/source/Amazon_Redshift), [Informix](/source/Informix), [H2](/source/H2_(DBMS)), [Hsql](/source/Hsql), [Derby](/source/Apache_Derby), [SQLite](/source/SQLite), [SAP HANA](/source/SAP_HANA), [Sybase ASE](/source/Sybase_ASE), [Phoenix](/source/Apache_Phoenix), [Firebird](/source/Firebird_(database_server)) and [TiDB](/source/TiDB).[3]

## Adoption

Flyway received 11,500,000 downloads in 2018.

In January 2015, Flyway was placed in the "Adopt" section of the [Thoughtworks](/source/Thoughtworks) Technology Radar.[4]

In July 2019, Flyway was acquired by [Redgate](/source/Redgate).[5]

## Related tools

- [DBmaestro](/source/DBmaestro)
- [Liquibase](/source/Liquibase)

## References

1. ["Database migrations with flyway."](https://www.baeldung.com/database-migrations-with-flyway). *Baeldung*. 29 September 2016. Retrieved 2020-02-13.

1. ["Flyway by Redgate • Community plugins."](https://flywaydb.org/documentation/plugins/). *Flyway by Redgate*. Retrieved 2020-02-13.

1. ["Flyway by Redgate • Database Migrations Made Easy."](https://flywaydb.org/documentation/). *Flyway by Redgate*. Retrieved 2020-02-13.

1. ["Technology Radar | Emerging Technology Trends for 2017 | ThoughtWorks"](https://www.thoughtworks.com/radar/tools/flyway). *www.thoughtworks.com*. Retrieved 2017-09-15.

1. ["Redgate cements position as leading vendor with Flyway acquisition"](https://www.realwire.com/releases/Redgate-cements-position-as-leading-vendor-with-Flyway-acquisition). *www.realwire.com*. 24 July 2019. Retrieved 2019-08-19.

## External links

- [Official website](https://flywaydb.org/)

---
Adapted from the Wikipedia article [Flyway (software)](https://en.wikipedia.org/wiki/Flyway_(software)) by Wikipedia contributors ([contributor history](https://en.wikipedia.org/wiki/Flyway_(software)?action=history)). Available under [Creative Commons Attribution-ShareAlike 4.0 International](https://creativecommons.org/licenses/by-sa/4.0/). Changes may have been made.