Feature Glossary
Published 15 July 2022
Features Overview
| Process | Functionality | SQL Server | Oracle | PostgreSQL | MySQL | 22 Other RDBMS |
|---|---|---|---|---|---|---|
| Version Control | Object Level History | ✓ | ✓ | ✓ | ✓* | - |
| Versioned Migrations | ✓ | ✓ | ✓ | ✓ | ✓ | |
| Migration Script auto-generation | Schema Changes (DDL) | ✓ | ✓ | ✓ | ✓* | - |
| Static Data Changes (DML) | ✓ | ✓ | Coming Soon | ✓* | - | |
| Continuous Integration (CI) | Build Validation | ✓ | ✓ | ✓ | ✓ | ✓ |
| Repeatable Deployments | Automated script deployment | ✓ | ✓ | ✓ | ✓ | ✓ |
| SQL Code Analysis | ✓ | ✓ | ✓ | ✓ | ✓ | |
| Drift Detection | ✓ | ✓ | ✓ | ✓* | - | |
| Change Report | ✓ | ✓ | ✓ | ✓* | - | |
| On-Demand Database Clones | Database Virtualization | ✓ | Coming Soon | ✓ | ✓ | - |
* Features available in preview only. Find out more on how to join the Early Access Program please sign up here.
The 22 databases other RDBMS
Azure Synapse, CochroachDB,DB2,Derby,Firebird,Google BigQuery, Google Cloud Spanner (Beta), H2, HSQLDB, Ignite, Informix, MariaDB, Percona XtraDB Cluster, Redshift, SAP HANA, SingleStoreDB, Snowflake, SQLite, Sybase ASE, TestContainers, TiDB (Titanium DB), TimescaleDB, YugabyteDB.
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 | ✓ | ✓ | |
Using database clones for development * | | ✓ | |
| Spinning up per-branch database clones * | | ✓ |
*SQL Server, Oracle, PostgreSQL, MySQL (coming soon)
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 * | | ✓ |
*SQL Server, Oracle, PostgreSQL, MySQL (coming soon)
Database deployment
Deploying database changes
| Flyway Community | Flyway Teams | Flyway Enterprise | |
|---|---|---|---|
| Flyway migrate (command) | ✓ | ✓ | ✓ |
| 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 | ✓ | ||
| Using database clones for the CI process * | ✓ | ||
| Using database clones for continuous deployment testing * | ✓ | ||
| Integration with SQL Monitor | ✓ |
*SQL Server, Oracle, PostgreSQL, MySQL (coming soon) **Roadmap
Recovery and troubleshooting
| Flyway Community | Flyway Teams | Flyway Enterprise | |
|---|---|---|---|
| Flyway repair (command) | ✓ | ✓ | ✓ |
| Flyway undo (command) | ✓ | ✓ |
Test Data Management
Provisioning
| Flyway Community | Flyway Teams | Flyway Enterprise | |
|---|---|---|---|
| Provision developer DBs * | ✓ | ||
| Per branch database clones * | ✓ | ||
| Provision database clones "instantly" for use in CI process * | ✓ |
*SQL Server (supported); Oracle, PostgreSQL, MySQL (early access)
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 (schema comparison), MySQL (coming soon) **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 | Future* | Future* |
| Supported database versions | 5 years | Standard support | Extended support |
| Named Customer Success Manager | Available* |
*Please contact your sales representative if you're interested in finding out more.
Find out more about how these features fit into your development and deployment pipelines.
