Feature Glossary

Features Overview 

Advanced capabilities

Foundational capabilities
Functionality Flyway EditionSQL Server,  Oracle, PostgreSQL, MySQL*Other DBMS*
Version control
Object Level History Teams/Enterprise-
Versioned MigrationsAll
Migration Script auto-generation
Schema Changes (DDL) Enterprise ✓-
Static Data Changes (DML) Enterprise✓**-
Versioned script generationEnterprise-
Undo script generation Enterprise-
Continuous Integration (CI) and Repeatable Deployments
Build ValidationTeams/Enterprise
Automated script deploymentAll
Code AnalysisAll
Code Analysis - custom rulesEnterprise
Drift DetectionEnterprise-
Change ReportEnterprise-

** 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 CommunityFlyway TeamsFlyway 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 CommunityFlyway TeamsFlyway Enterprise
Versioned migrations
Undo migrations
SQL-based migrations
Java-based migrations
Repeatable migrations
Script migrations
Placeholder replacement
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 CommunityFlyway TeamsFlyway 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, 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

Integration with SQL Monitor

*Databases with support for advanced capablities

Recovery and troubleshooting

Flyway CommunityFlyway TeamsFlyway Enterprise
Flyway repair (command)
Flyway undo (command)


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, Yugabyte, MySQL, MariaDB

**SQL Server, Oracle

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

Contact us

Supported databases and versions 5 yearsStandard supportExtended support

Find out more about how these features fit into your development and deployment pipelines.

Didn't find what you were looking for?