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, including Flyway’s core commands (info, migrate, repair, validate, baseline, undo (Flyway Teams+)) , are supported by 50+ DBMS. See all the Supported Databases and Versions. | Flyway’s advanced capabilities are built on Redgate’s renowned database comparison engine, in continual development and testing since 2000. We offer support for our advanced capabilities across the major DBMS platforms, including Microsoft SQL Server, Postgres, Oracle and MySQL. For more information about the platform flavors we support, see Supported Databases and Versions. |
Database development
Tracking changes and database version control
Flyway Community | Flyway Teams | Flyway Enterprise | |
---|---|---|---|
Migrations-first development model | ✓ | ✓ | ✓ |
Maintaining a Schema Model * | ✓ | ✓ | |
Object history * | ✓ | ✓ | |
Schema change diff viewer * | ✓ | ✓ | |
Reverting schema changes | ✓ | ✓ | |
Integrated git client | ✓ | ✓ | |
Use database clones for dev databases** | | ✓ | |
Use Docker for dev databases | ✓ |
* Available for databases with advanced capabilities (SQL Server, Oracle, PostgreSQL, MySQL, and their variants)
** Requires Redgate Test Data Manager license
Migration script management
Flyway Community | Flyway Teams | Flyway Enterprise | |
---|---|---|---|
Versioned migrations | ✓ | ✓ | ✓ |
Undo migrations | | ✓ | ✓ |
SQL-based migrations | ✓ | ✓ | ✓ |
Java-based migrations | ✓ | ✓ | ✓ |
Repeatable migrations | ✓ | ✓ | ✓ |
Script migrations | ✓ | ✓ | ✓ |
Placeholder replacement | ✓ | ✓ | ✓ |
Callbacks | ✓ | ✓ | ✓ |
Custom migration resolver | ✓ | ✓ | ✓ |
Baseline migrations | ✓ | ✓ | ✓ |
Auto-generate versioned scripts * | | ✓ | |
Auto-generate static data scripts * | | ✓ | |
Auto-generate undo scripts * | ✓ | ||
Auto-generate baseline scripts * | | ✓ | |
Using clones as baselines (eg for shadow databases) ** | | ✓ |
* Available for databases with advanced capabilities (SQL Server, Oracle, PostgreSQL, MySQL, and their variants)
** Requires Redgate Test Data Manager
Database deployment
Deploying database changes
Flyway Community | Flyway Teams | Flyway Enterprise | |
---|---|---|---|
Flyway migrate (command) | ✓ | ✓ | ✓ |
Preview deployment script | ✓ | ✓ | |
Marking migration scripts as applied | ✓ | ✓ | ✓ |
Flyway baseline (command) | ✓ | ✓ | ✓ |
Flyway info (command) | ✓ | ✓ | ✓ |
✓ | ✓ | ✓ | |
✓ | ✓ | ||
State-based deployments from the schema model * | ✓ | ✓ | |
Automated 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) | ✓ (coming soon) |
Dry Run Script | ✓ | ✓ | |
Changes report * | ✓ | ||
Drift check * | ✓ | ||
Find invalid objects ** | ✓ ** | ||
SQLFluff only | SQLFluff only | ✓ | |
✓ | |||
✓ *** | ✓ *** | ||
CI database build | ✓ | ||
Integration with SQL 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 or regex rules.
Recovery and troubleshooting
Flyway Community | Flyway Teams | Flyway Enterprise | |
---|---|---|---|
Flyway repair (command) | ✓ | ✓ | ✓ |
Flyway undo (command) | ✓ | ✓ |
Other
GUIs, command lines, APIs and other interfaces
Flyway Community | Flyway Teams | Flyway Enterprise | |
---|---|---|---|
CLI | ✓ | ✓ | ✓ |
Docker images | flyway/flyway | Redgate/flyway | Redgate/flyway |
Maven plug-in | ✓ | ✓ | ✓ |
Gradle plug-in | ✓ | ✓ | ✓ |
API | ✓ | ✓ | ✓ |
Distribution licenses *** | ✓** | ||
Flyway Desktop GUI | In preview | ✓ | ✓ |
Schema comparison * | ✓ | ||
Data comparison ** | ✓ | ||
Machine readable output | ✓ | ✓ | ✓ |
* Available for databases with advanced capabilities (SQL Server, Oracle, PostgreSQL, MySQL, and their variants)
** SQL Server and Oracle only (PostgreSQL coming soon and 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 | - | |
Supported database versions | See list of supported database versions for each Flyway edition |
Find out more about how these features fit into your development and deployment pipelines.