Flyway 12.9.0 is now available, bringing a series of refinements and fixes to this essential database migration tool. This update, released on 2026-06-18, focuses on improving stability and compatibility.

TL;DR

  • Resolved critical bugs impacting schema history and undo operations.
  • Enhanced database compatibility, particularly for PostgreSQL 16 and SQL Server.
  • Introduced a new configuration option for more controlled schema cleanup.

Key Changes

Flyway 12.9.0 builds upon its predecessor, Flyway 12.8.1, with targeted improvements.

Features

This release includes minor yet significant feature enhancements. Compatibility with PostgreSQL 16 has been further optimized, now offering improved support for advanced data types, complex function definitions, and declarative partitioning syntax. For SQL Server users, the update refines the parsing of GO batch terminators, particularly within scripts containing linked server queries or dynamic SQL. A notable addition is the flyway.clean.ignoreSchemas configuration option. This allows users to specify a comma-separated list of schemas to be explicitly excluded from the clean command, providing a crucial safety net against accidental data loss in shared development or testing environments. For example, flyway.clean.ignoreSchemas=audit_schema,external_data would prevent these schemas from being dropped.

Fixes

Flyway 12.9.0 addresses several critical bug fixes that enhance the tool’s overall stability. Issues related to the schema history table, specifically concerning concurrent writes during parallel migrations, have been resolved. This prevents potential deadlocks and ensures the integrity of migration metadata. A long-standing problem with undo operations failing on Oracle databases due to specific PL/SQL block parsing errors has been corrected, significantly improving the reliability of rollback procedures. Furthermore, error reporting for failed migrations is now more precise, offering clearer stack traces and contextual information, which greatly aids in quicker root cause analysis. Performance optimizations for handling large sets of migration scripts have also been implemented.

Deprecations

No significant deprecations are noted in this release. Users can continue with their existing configurations and migration scripts without immediate concerns about compatibility breaks.

For official details and a complete list of changes, refer to the Flyway 12.9.0 release notes.

Impact for QA Teams

QA teams will find Flyway 12.9.0 contributes to more stable and predictable database testing environments. The improved reliability of schema history and undo operations means fewer unexpected issues during test environment setup and teardown. Enhanced error reporting allows for faster identification and debugging of migration failures, streamlining the testing of database changes. The new flyway.clean.ignoreSchemas option provides an added layer of safety, preventing critical test data or shared schemas from being inadvertently removed during clean operations, thus reducing test environment re-creation time.

FAQ

Q: Is Flyway 12.9.0 a mandatory upgrade? A: No, it’s a minor update. Upgrade if your projects require the specific bug fixes, enhanced database compatibility, or the new clean configuration option.

Q: Are there any breaking changes in this release? A: No major breaking changes are reported for Flyway 12.9.0. Existing migration scripts and configurations should remain compatible. Always consult the official release notes for full details.

Q: How does this update affect existing migration scripts? A: Existing migration scripts should remain fully compatible. The update primarily focuses on internal stability, database compatibility, and minor feature enhancements rather than changes to migration script syntax or execution logic.