Flyway is an open source database migration tool. It strongly favors simplicity and convention over configuration.
It is based around 7 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, ...) 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 are Oracle, SQL Server, DB2, MySQL (including Amazon RDS), MariaDB, PostgreSQL (including Amazon RDS and Heroku), CockroachDB, Redshift, H2, Hsql, Derby, SQLite, SAP HANA, Sybase ASE and Phoenix.
Video Flyway (software)
Adoption
Flyway has been widely adopted in the industry, with 4,300,000 downloads in 2017 alone.
In January 2015, Flyway was placed in the "Adopt" section of the Thoughtworks Technology Radar.
Maps Flyway (software)
References
External links
- Flyway Home
- Flyway 3.1 announcement & interview on InfoQ
- Flyway introduction in Methods & Tools
- JavaZone conference Flyway Talk
- DB migrations in a Spring project
- Continuous database migration with Liquibase and Flyway
Related tools
- Liquibase
Source of article : Wikipedia
0 Comments