Flyway Documentation
Published 11 October 2021
Flyway is an industry leading database versioning framework that aims to unlock DevOps for the database. It strongly favors simplicity and convention over configuration.
Flyway Community Edition provides a free open source tier for database developers who need to version and automate their database deployments.
Flyway Teams Edition extends Flyway's scope in support of team-based database development, managing database objects as code objects in version control.
Flyway Enterprise Edition, available as part of Redgate Deploy, adds advanced capabilities such as automated script generation, and advanced pipeline checks for organizationt to gain further confidence in their deployments.
Flyway Command-line & API
Flyway is based around just a small number of basic commands: Migrate, Clean, Info, Validate, Undo, Baseline, Repair, Check and Snapshot.
Migrations can be written in SQL (native database-specific syntax such as PL/SQL and T-SQL is supported) or Java (for advanced data transformations or dealing with LOBs).
It has a Command-line client. If you are on the JVM, we recommend using the Java API for migrating the database on application startup. Alternatively, you can also use the Maven plugin or Gradle Plugin.
And if that's not enough, there are community plugins available for Spring Boot, Dropwizard, Grails, Play, SBT, Ant, Griffon, Grunt, Ninja and more!
Supported databases are Oracle, SQL Server (including Amazon RDS and Azure SQL Database), Azure Synapse (Formerly Data Warehouse), DB2, MySQL (including Amazon RDS, Azure Database & Google Cloud SQL), Aurora MySQL, MariaDB, Percona XtraDB Cluster, TestContainers, PostgreSQL (including Amazon RDS, Azure Database, Google Cloud SQL, TimescaleDB, YugabyteDB & Heroku), Aurora PostgreSQL, Redshift, CockroachDB, SAP HANA, Sybase ASE, Informix, H2, HSQLDB, Derby, Snowflake, SQLite and Firebird.
We recommend using the free new Flyway Hub and automated migration script testing service for getting started with Flyway and database CI.
Flyway Desktop
Flyway Desktop offers a GUI-based experience for database developers and data professionals.
Watch this 6.5 minute video for a quick overview.
For more information, visit:
We are actively improving our x-Database DevOps solution. If your team has any feedback, please get in touch with our development team.
