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

• 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

• 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

• 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

Flyway Desktop

Flyway Desktop