Flyway Engine is a database migration tool that strongly favors simplicity and convention over configuration.

It is based around just several core commands: Migrate, Clean, Info, Validate, Undo, Baseline and Repair.

Plus an extended set of commands for more advanced use-cases: Auth, Check and Snapshot

Migrations can be written in:

• SQL - database-specific syntax (such as PL/SQL, T-SQL, ...) is supported
• Java - for advanced data transformations or dealing with LOBs.

It has a Command-line client. It also allows Java API integration for migrating the database on your application startup. Alternatively, you can also use the Maven plugin or Gradle plugin.

And if that's not enough, there are plugins available for Spring Boot, Dropwizard, Grails, Play, SBT, Ant, Griffon, Grunt, Ninja and more!

Next Steps

• If you haven't checked out the Getting Started section yet, do it now. You'll be up and running in no time!
• If you are looking for a GUI experience with more comprehensive authoring tools then take a look at Flyway Desktop

Supported databases

Flyway engine supports a large number of databases:

• Aurora MySQL
• Aurora PostgreSQL
• Azure Synapse
• Cassandra Database
• Clickhouse Database
• CockroachDB
• Databricks
• DB2
• DB2 zOS Database
• Derby
• Firebird
• Google BigQuery
• Google Cloud Spanner
• H2
• HSQLDB
• Ignite
• Informix
• MariaDB
• MongoDB
• MySQL
• Oracle Database
• Percona XtraDB Cluster
• PostgreSQL Database
• Redshift
• SAP HANA (Including SAP HANA Cloud)
• SingleStoreDB
• Snowflake
• SQLite
• SQL Server Database
• Sybase ASE
• TestContainers
• TiDB (Titanium DB)
• TimescaleDB
• YugabyteDB