Flyway 12.4.0 Update: PostgreSQL 16, Config & Stability Fixes

TL;DR

  • Improved PostgreSQL 16 compatibility, including pg_stat_statements.
  • New flyway.config.file property for external configuration.
  • Critical fixes for Oracle clean and SQL Server migrate commands.

Key Changes

Flyway 12.4.0, released on 2026-04-14, focuses on refining database compatibility and improving operational stability.

Features:

  • PostgreSQL 16 Support: Enhanced compatibility, particularly for environments utilizing the pg_stat_statements extension. This ensures smoother migrations and better performance tracking on the latest PostgreSQL versions.
  • External Configuration File: A new flyway.config.file property allows specifying an external path for Flyway’s configuration. This provides greater flexibility for managing settings across different environments.

Fixes:

  • Oracle clean Command: Addressed an issue where the clean command would fail when encountering specific Oracle schemas containing materialized views. This improves reliability for Oracle users.
  • SQL Server migrate Hang: Corrected a bug that caused the migrate command to hang intermittently when operating with SQL Server AlwaysOn Availability Groups. This enhances migration stability in high-availability setups.
  • MySQL Comment Parsing: Fixed an error in parsing multi-line comments within MySQL migration scripts, preventing unexpected failures.

Deprecations:

  • The flyway.placeholderReplacement property is now deprecated. Users should transition to flyway.placeholder.replacement for future configurations.

For full details, refer to the official Flyway release notes.

Impact for QA Teams

QA teams will benefit from more stable and predictable database migrations, especially when testing with PostgreSQL 16, Oracle, or SQL Server AlwaysOn. The new external configuration option simplifies managing test environment setups, reducing potential configuration-related issues during testing cycles.