About Flyway
Flyway is a database migration tool from Redgate. It applies versioned schema changes to a database in a repeatable way, so each environment ends up in the same state.
What it does
Teams write migrations as SQL scripts or code, store them in version control and run them from the command line or a CI pipeline. Redgate says Flyway supports more than 60 database platforms. Its enterprise edition adds policy checks, schema drift detection and an audit trail for database changes.
Key features
- Versioned migrations stored in version control
- Support for more than 60 database platforms
- CI/CD integration with GitHub and Azure DevOps
- Schema drift detection in the enterprise edition
- Generated rollback scripts in the enterprise edition
Who it's for
Backend teams and DevOps engineers who want database changes to follow the same review and release path as application code. Enterprise teams that need audit trails will find the governance features useful.
Pricing and good to know
The core Flyway project is open source under the Apache 2.0 licence. Enterprise features are sold by Redgate, and a free trial is listed on its website. Check which edition has the features you need before you plan a rollout.
Highlights
- Versioned migrations kept in version control
- Support for more than 60 database platforms
- CI/CD integration with GitHub and Azure DevOps
- Schema drift detection in the enterprise edition
- Generated rollback scripts in the enterprise edition
