Feature Glossary
Published 15 July 2022
Features Overview
Advanced capabilities | Foundational capabilities | ||
|---|---|---|---|
| Functionality | Flyway Edition | SQL Server, Oracle, PostgreSQL, MySQL* | Other DBMS* |
| Version control | |||
| Object Level History | Teams/Enterprise | ✓ | - |
| Versioned Migrations | All | ✓ | ✓ |
| Migration Script auto-generation | |||
| Schema Changes (DDL) | Enterprise | ✓ | - |
| Static Data Changes (DML) | Enterprise | ✓** | - |
| Versioned script generation | Enterprise | ✓ | - |
| Undo script generation | Enterprise | ✓ | - |
| Continuous Integration (CI) and Repeatable Deployments | |||
| Build Validation | Teams/Enterprise | ✓ | ✓ |
| Automated script deployment | All | ✓ | ✓ |
| Code Analysis | All | ✓ | ✓ |
| Code Analysis - custom rules | Enterprise | ✓ | ✓ |
| Drift Detection | Enterprise | ✓ | - |
| Change Report | Enterprise | ✓ | - |
** PostgreSQL, MySQL coming in 2024
* For a full list of databases with advanced and foundational capabilities, visit Supported Database Systems.
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 | ✓ |
*Databases with support for advanced capablities
**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) ** | | ✓ |
*Databases with support for advanced capablities
**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) | ✓ | ✓ | ✓ |
| Cherry picking migrations for deployment | ✓ | ✓ | |
| State-based deployments from the schema model | ✓* | ✓ | |
| Authentication | Plain text, Oracle Wallet, Windows Authentication, Azure Active Directory, SCRAM, key-based authentication | + Kerberos, MySQL Option Files, pgpass | All |
| ✓ |
*For manual deployments, requires separate purchase of SQL Compare or Schema Compare for Oracle; for automated state-based deployments, Flyway Enterprise is required.
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 | ✓ | |
Custom code analysis rules | ✓ | ||
CI database build | ✓ | ||
| Integration with SQL Monitor | ✓ |
*Databases with support for advanced capablities
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 | ✓ | ✓ |
| Flyway Hub (preview) | ✓ | ✓ | ✓ |
| Schema comparison * | ✓ | ||
| Data comparison ** | ✓ | ||
| Machine readable output | ✓ | ✓ | ✓ |
*SQL Server, Oracle, PostgreSQL, Yugabyte, MySQL, MariaDB
**SQL Server, Oracle
***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 databases and versions | 5 years | Standard support | Extended support |
Find out more about how these features fit into your development and deployment pipelines.
