Flyway (software)

From Wikipedia, the free encyclopedia
Flyway
Developer(s)Redgate
Stable release
10.11.1 / April 18, 2024 (2024-04-18)
Repository
Written inJava
Operating systemCross-platform
TypeSoftware Development
LicenseApache License 2.0
Websiteflywaydb.org Edit this on Wikidata

Flyway is an open-source database-migration tool.

Concept[edit]

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,[1] Dropwizard, Grails, Play, SBT, Ant, Griffon, Grunt, Ninja, and more.[2]

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, and Firebird.[3]

Adoption[edit]

Flyway received 11,500,000 downloads in 2018.

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

In July 2019, Flyway was acquired by Redgate.[5]

Related tools[edit]

References[edit]

  1. ^ "Database migrations with flyway". Baeldung. Retrieved 2020-02-13.
  2. ^ "Flyway by Redgate • Community plugins". Flyway by Redgate. Retrieved 2020-02-13.
  3. ^ "Flyway by Redgate • Database Migrations Made Easy". Flyway by Redgate. Retrieved 2020-02-13.
  4. ^ "Technology Radar | Emerging Technology Trends for 2017 | ThoughtWorks". www.thoughtworks.com. Retrieved 2017-09-15.
  5. ^ "Redgate cements position as leading vendor with Flyway acquisition". www.realwire.com. 24 July 2019. Retrieved 2019-08-19.

External links[edit]