Feature Summary
Published 15 July 2022
Foundational and advanced capabilities in Flyway
While all supported databases have foundational capabilities, not all databases have the additional "advanced capabilities" denoted with asterisks (*) in the features tables below.
| Foundational capabilities | Advanced capabilities |
|---|---|
| Flyway’s foundational migrations capabilities includes Flyway’s core commands (info, migrate, repair, validate, baseline, undo (Flyway Teams+)) and supports over 50 database systems. See all the Supported Databases and Versions. | Flyway’s advanced capabilities are built on Redgate’s renowned database comparison technology, in continual development and testing since 2000. Our advanced capabilities support the major DBMS platforms, including Microsoft SQL Server, Postgres, Oracle , MySQL, and their cloud variants. Learn more about all the supported platform flavors at Supported Databases and Versions. |
Database development
Tracking changes and database version control
| Flyway Community | Flyway Teams | Flyway Enterprise | |
|---|---|---|---|
| Native SQL migrations runner | ✓ | ✓ | ✓ |
| Choice of migrations or state-based projects | ✓ | ✓ | |
| Built-in Git client | ✓ | ✓ | ✓ |
| Maintaining a Schema Model * | ✓ | ✓ | |
| Maintain object level history * | ✓ | ✓ | |
| Schema change diff viewer * | ✓ | ✓ | |
| Reverting schema changes | ✓ | ✓ | |
| Static data versioning * | ✓ | ✓ | |
| Static data filtering and controls * | ✓ | ||
Fire up databases using Docker | ✓ (Preview) |
* Available for databases with advanced capabilities (SQL Server, Oracle, PostgreSQL, MySQL, and their cloud variants)
Migration script management
| Flyway Community | Flyway Teams | Flyway Enterprise | |
|---|---|---|---|
| Versioned migrations | ✓ | ✓ | ✓ |
| SQL-based migrations | ✓ | ✓ | ✓ |
| Java-based migrations | ✓ | ✓ | ✓ |
| Repeatable migrations | ✓ | ✓ | ✓ |
| Script migrations | ✓ | ✓ | ✓ |
| Placeholder replacement | ✓ | ✓ | ✓ |
| Custom migration resolver | ✓ | ✓ | ✓ |
| Baseline migrations | ✓ | ✓ | ✓ |
| Callbacks | ✓ (limited) | ✓ | ✓ |
| Undo migrations | | ✓ | ✓ |
| Generate versioned scripts * | | ✓ | |
| Generate undo scripts * | ✓ | ||
| Generate baseline scripts * | | ✓ | |
| Auto-generate migration scripts via CLI * | ✓ | ||
| ✓ (Preview) |
* Available for databases with advanced capabilities (SQL Server, Oracle, PostgreSQL, MySQL, and their variants)
Database deployment
Deploying database changes
| Flyway Community | Flyway Teams | Flyway Enterprise | |
|---|---|---|---|
| Flyway migrate (command) | ✓ | ✓ | ✓ |
| Marking migration scripts as applied | ✓ | ✓ | ✓ |
| Flyway baseline (command) | ✓ | ✓ | ✓ |
| Auto-generate baseline scripts | ✓ | ||
| Flyway info (command) | ✓ | ✓ | ✓ |
| ✓ | ✓ | ✓ | |
| Preview deployment script | ✓ | ✓ | |
| ✓ | ✓ | ||
| ✓ | ✓ | ||
Unlimited tags | ✓ (coming soon) | ||
| State-based deployments from the schema model * | ✓ | ✓ | |
| Automate state-based deployments * | ✓ | ||
| Authentication | Plain text, Oracle Wallet, Windows Authentication, Azure Active Directory, SCRAM, key-based authentication | + Kerberos, MySQL Option Files, pgpass | All |
| ✓ |
* Available for databases with advanced capabilities (SQL Server, Oracle, PostgreSQL, MySQL, and their variants)
Deployment confidence
| Flyway Community | Flyway Teams | Flyway Enterprise | |
|---|---|---|---|
| Flyway validate (command) | ✓ | ✓ | ✓ |
| Flyway clean (command) | ✓ | ✓ | ✓ |
| Verifying migration script execution | | ✓ (coming soon) | |
| Dry Run Script | ✓ | ✓ | |
| Changes report * | ✓ | ||
| Drift detection * | ✓ | ||
| Detect invalid objects ** | ✓ ** | ||
| SQLFluff only | SQLFluff only | ✓ | |
| ✓ | |||
| ✓ *** | ✓ *** | ||
CI database build | ✓ | ||
| Integration with Redgate Monitor | ✓ |
* Available for databases with advanced capabilities (SQL Server, Oracle, PostgreSQL, MySQL, and their variants)
** SQL Server and Oracle only (PostgreSQL and other databases on our Roadmap)
*** Works with SQLFluff rules only for Flyway Teams. For Flyway Enterprise, you can use either SQLFluff and custom regex rules.
Recovery and troubleshooting
| Flyway Community | Flyway Teams | Flyway Enterprise | |
|---|---|---|---|
| Repair (command) | ✓ | ✓ | ✓ |
| Undo (command) | ✓ | ✓ | |
| Auto-repair on failed migration | ✓ (coming soon) | ||
| Save schema snapshots* | ✓ |
* Available for databases with advanced capabilities (SQL Server, Oracle, PostgreSQL, MySQL, and their variants)
Other
GUIs, command lines, APIs and other interfaces
| Flyway Community | Flyway Teams | Flyway Enterprise | |
|---|---|---|---|
| CLI | ✓ | ✓ | ✓ |
| Unlimited data retention in Flyway Pipelines | ✓ | ||
| Docker images | Redgate/flyway | Redgate/flyway | Redgate/flyway |
| Maven plug-in | ✓ | ✓ | ✓ |
| Gradle plug-in | ✓ | ✓ | ✓ |
| API | ✓ | ✓ | ✓ |
| Machine readable output | ✓ | ✓ | ✓ |
| Flyway Desktop GUI | Preview | ✓ | ✓ |
| Schema comparison tool * | ✓ | ||
| Data comparison tool ** | ✓ | ||
| Distribution licenses *** | ✓*** |
* Available for databases with advanced capabilities (SQL Server, Oracle, PostgreSQL, MySQL, and their variants)
** SQL Server and Oracle only (PostgreSQL coming soon; other databases on our Roadmap)
*** Contact sales for more information on per-distribution licensing add-on
Support
| Flyway Community | Flyway Teams | Flyway Enterprise | |
|---|---|---|---|
| Redgate Standard Support | Community support only | ✓ | ✓ |
| Redgate Premium Support | Community support only | - |
Find out more about how these features fit into your development and deployment pipelines.
This documentation contains proprietary information and is protected by copyright law.
Copyright © 2026 Red Gate Software Limited. All rights reserved
