Redgate logo for print use

Redgate Flyway

Roadmap

Find out what the teams are developing, and check out what’s new in Flyway

The mission

To make it as easy to deliver database changes as it is for application code changes.

Our Database Deployment development teams aim to enable companies to achieve effortless continuous delivery of database changes, mirror the application DevOps processes to speed up the software development lifecycle and avoid data being a bottleneck for innovation.

Interested in discussing any of these new or upcoming features with a Product Manager? Sign up for a 30 min Zoom call.

Subscribe for new version alerts

The history of Flyway

Engineering teams at Redgate have continually developed new and innovative capabilities for Flyway since 2019. Today, Flyway is used across multiple industries worldwide, including finance, healthcare, federal government and more.

Find out more about Flyway’s journey

What's new

Flyway Engine version 11 (11-21-2024)

New features

  • Automated state-based deployments, including checks – change report, drift detection, and code analysis
  • Automated developer workflowsautomate project setup, saving to schema model, generating a baseline and migration scripts

Flyway Engine version 10

New features

  • Full compatibility for all databases in Flyway Community without a restriction on the age of the database engine
  • Unified flyway.toml with Flyway Desktop, which allows environment settings to be used
  • SinglestoreDB support
  • Google Cloud Spanner support
  • Full comparison support for MySQL and Maria DB
  • Use Redgate Licensing with Flyway auth
  • MongoDB preview – NoSQL migration capabilities
  • EnterpriseDB Support
  • TimescaleDB Support

New features in Flyway Community

  • Info Filters
  • Script migrations
  • Callbacks: beforeEachMigrateStatement, afterEachMigrateStatement​, afterEachMigrateStatementError​, beforeConnect

Flyway Desktop

New features

  • Backup as Baseline – Restore a backup file instead of creating database from scratch in the baseline script 
  • Partitions for PostgreSQL 
  • Viewing the full Schema Model
  • Accessing Git history 
  • Deploy rules for applying migration scripts, e.g., deploy this script to only this environment 
  • Manual state-based deployments
  • Improved version control integration
  • Static data for SQL Server, PostgreSQL and Oracle
  • Ignore invalid objects during baselining
  • GUI for editing comparison options
  • Import SQL Source Control projects
  • Import Source Control for Oracle projects

Flyway Engine version 9

New features

  • Full comparison support for MySQL
  • When running the SQL*Plus ‘@’ command, Flyway will also search ‘SQLPATH’ and ‘ORACLE_PATH’ for runnable scripts. It will also attempt to load from absolute paths
  • Added table feedback for SQL Plus
  • Added driver() method to FluentConfiguration
  • Flyway now handles defining PostgreSQL functions using BEGIN ATOMIC.
  • Add Info report. You can now get a report of an info call as a tab in a flyway HTML report
  • We have improved support for WHENEVER SQLERROR EXIT in Oracle SQL*Plus. This now works on its own and no longer needs to be followed by FAILURE or SQL.SQLCODE.
  • Add migration report
  • Adding Flyway Reports; Single file HTML reports that expose important details and stats about your Flyway pipeline in an easy to read and share format
  • Introduced a flyway-bom pom for Maven. This BOM includes all modules of Flyway which are compatible with each other to be used in Maven dependency management
  • Added ‘NON_EMPTY_SCHEMA_WITHOUT_SCHEMA_HISTORY_TABLE’ as a new error code
  • Regex Rule code analysis results now include the line and column number of where violations occurred

See the full release notes

What's next

In Development

Flyway

  • IBM2 z/OS Support
  • ClickHouse Support
  • Cassandra Preview
  • Databricks Support

Flyway Desktop

  • Automatic shadow database 
  • Enhanced onboarding experience 
  • Integration with Test Data Manager for dedicated development databases and dedicated databases for Git branches
  • Integration with Docker for dedicated development databases
  • Flyway Desktop in the Flyway Community Tier – Currently available in Preview; What else would you like to see in this version?

Researching

Flyway Desktop

  • IDE Integration (e.g., SSMS) 
  • An improved experience for pulling and applying changes to development databases
  • More location options when adding migrations
  • GUI for object filters
  • Full comparison support for Snowflake
  • Easier re-baseline experience
  • Other NoSQL Databases

Learn more about Flyway in our blog

We're here to help

0800 028 0309

Whether you want more details about Redgate Flyway, a demo, or to know about best practice – get in touch.

The industry standard tools for over 25 years

Redgate has specialized in database software for over 25 years. Our products are used by 92% of the Fortune 100. 200,000 customers rely on Redgate worldwide.

World-class support

Redgate offers comprehensive documentation and a friendly, helpful support team. An average 87% of customers rate our support 'Excellent'.