Flyway

Flyway Documentation

Flyway extends DevOps to your databases to accelerate software delivery and ensure quality code. 

From version control to continuous delivery, Flyway builds on application delivery processes to automate database deployments.

Flyway Desktop offers a GUI-based experience for database developers and data professionals to track changes to their database objects and manage migration scripts in version control. 

The Flyway command-line is a standalone Flyway distribution. It runs on Windows, macOS and Linux and it is primarily meant for users who wish to migrate their database from the command-line without having to integrate Flyway into their applications nor having to install a build tool.

Flyway can be integrated within an application using the API, allowing migrations to be applied when the application starts.




Flyway Desktop

Flyway Command-line & API

The Flyway command line and API are included as part of your Flyway Desktop installer.

Flyway has the following commands at its disposal:   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).

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. 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.

You can try the new  Flyway Hub and automated migration script testing service  for getting started with Flyway and database CI.

Flyway Editions

Community

Perfect for individual developers, or non-commercial projects looking for a basic and reliable framework for versioning and automating the deployment of database changes

Teams

Ideal for organizations looking to improve collaboration and fine tune their processes during development and the deployment of database changes

Enterprise

Ideal for medium and large enterprises who require secure and automated processes with compliance control to develop, test and deploy database changes

Explore more details about the differences between these editions in our feature glossary.  

Contact Us

We are actively improving our x-Database DevOps solution.  If your team has any feedback, please get in touch with our development team.


Didn't find what you were looking for?