Redgate Flyway

What Redgate Flyway is

Redgate Flyway is a database migration tool for managing schema changes across Windows, Mac, Linux, and API workflows. Its Community plan is free and provides core migration commands through the CLI and API. Teams supports up to 100 schemas. Enterprise adds automated script generation, drift detection, automatically generated rollback scripts, and CI/CD governance. Flyway supports rollback, schema comparison, CI/CD automation, drift detection, self-hosted deployment, and mixed migration formats. These capabilities cover applying migration commands, comparing schemas, detecting changes, and controlling database updates in deployment pipelines. Plan differences determine access to capacity, automation, rollback generation, and governance features. Redgate was founded in 1999 and is headquartered in Cambridge, United Kingdom. Teams choosing Flyway should match the edition to their schema count and the amount of automation or governance required.

Who it suits

It suits development and database teams managing schema changes across multiple operating systems or API-based workflows. Teams can choose a free core command set or higher editions with capacity and governance features.

Limits

The Community plan provides core migration commands, CLI, and API access. Teams supports up to 100 schemas, while automated script generation, drift detection, automatically generated rollback scripts, and CI/CD governance are listed for Enterprise.

Getting started

1. Open the Redgate Flyway website
2. Choose the Community, Teams, or Enterprise plan
3. Use the Community CLI and API or the capabilities provided by your selected plan
4. Run Flyway on Windows, Mac, or Linux, or connect through its API
5. Use migration commands with the mixed migration format

Verdict

Flyway offers a free migration foundation and progressively adds schema capacity, automation, rollback generation, and governance. Review edition boundaries carefully because the most advanced controls are reserved for Enterprise.