Flyway

Feature Summary

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 capabilitiesAdvanced 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 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


  

* Available for databases with advanced capabilities (SQL Server, Oracle, PostgreSQL, MySQL, and their variants)

** 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
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 CommunityFlyway TeamsFlyway Enterprise
Flyway migrate (command)
Preview deployment script 
Marking migration scripts as applied
Flyway baseline (command)
Flyway info (command)

Limit migration scripts to specific environments

Deploy rules

 

Cherry picking migrations for deployment


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, pgpassAll

Secrets Management integration



* Available for databases with advanced capabilities (SQL Server, Oracle, PostgreSQL, MySQL, and their variants)

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

Creating custom Regular Expression rules



Configure pipeline to fail on rule violations


✓ *** ✓ ***

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

Other

GUIs, command lines, APIs and other interfaces


Flyway CommunityFlyway TeamsFlyway 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 CommunityFlyway TeamsFlyway Enterprise
Redgate Standard Support  Community support only

Redgate Premium Support Community support only-

Contact us

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.


Didn't find what you were looking for?