Feature Glossary

Features Overview 

ProcessFunctionality SQL ServerOracle PostgreSQLMySQL22 Other RDBMS
Version ControlObject Level History✓*-

Versioned Migrations
Migration Script auto-generationSchema Changes (DDL)✓*-

Static Data Changes (DML)Coming Soon✓*-
Continuous Integration (CI)Build Validation
Repeatable DeploymentsAutomated script deployment

SQL Code Analysis

Drift Detection✓*-

Change Report✓*-
On-Demand Database ClonesDatabase VirtualizationComing 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 CommunityFlyway TeamsFlyway 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

*SQL Server, Oracle, PostgreSQL, MySQL (coming soon)

Database deployment

Deploying database changes

Flyway CommunityFlyway TeamsFlyway 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, pgpassAll

Secrets Management integration

*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 CommunityFlyway TeamsFlyway 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


Code analysis

SQLFluff onlySQLFluff 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 CommunityFlyway TeamsFlyway Enterprise
Flyway repair (command)
Flyway undo (command)

Test Data Management


Flyway CommunityFlyway TeamsFlyway 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)


GUIs, command lines, APIs and other interfaces

Flyway CommunityFlyway TeamsFlyway Enterprise
Docker imagesflyway/flywayRedgate/flywayRedgate/flyway
Maven plug-in
Gradle plug-in
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


Flyway CommunityFlyway TeamsFlyway Enterprise
Redgate Standard Support  Community support only

Redgate Premium Support Community support onlyFuture*


Supported database versions 5 yearsStandard supportExtended support
Named Customer Success Manager


*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.

Didn't find what you were looking for?