NewYour coding agent can read the release notes before it upgrades.Set up the MCP server →
Maven Central, #770 by repository stars
Latest stable
13.12.1
Last release 16 days ago
06 Nov 2026
Ships on a steady schedule
a new release about every 2 weeks
Nearly every release is documented
notes for 60 of the last 60 stable releases
Nothing withdrawn
no release was ever pulled
5 years old
202 releases · first in 2022
Drag across the ruler to compare, or tap a release to open it.
The clean command will also drop services and queues in SQL Server.
Correct redgate-compare options when using TOML with check and drift or changes.
Fixed reports not displaying Teams and Enterprise level features
Thanks to ashtonbatty for reporting these issues.
Issue 3797 Use latest version of Apache Derby dependencies to avoid CVE-2022-46337.
Fix parsing of boolean comparison options
Fixed a bug where comma-separated lists for configuration parameters passed in via command line would fail with a parsing error
Update document on setting environment parameter through environment variable
Upgrade version of Maven dependencies used by the Flyway Maven plugin to 3.9.6.
Make datasource in classic config environment aware
Improve error message for misconfigured environment variables in TOML config.
Issue 3797 Use latest version of Apache Derby dependencies to avoid CVE-2022-46337.
Can now start a trial with the auth command
add supported-databases command.
flyway-sqlserver into flyway-database folder spaceThanks to fage88 for reporting these issues.
Your coding agent can read these notes before it upgrades. Set up the MCP server →
Correct urls for fetching offline permits
Correct urls for fetching offline permits
Fix dropping views from GCP Spanner when running clean.
Add new groupId to flyway-gradle-plugin
Issue 3793 Fix index out of bounds issue in ConfigUtils
Flyway now supports PostgreSQL version 16.
MongoDB 7.0 support available. Currently shipped as preview in Redgate edition CLI.
Thanks to AlejandroYuste for reporting these issues.
Fixed handling of FLYWAY_JDBC_PROPERTIES_ACCESSTOKEN environment variable with toml projects
Fixed handling of FLYWAY_JDBC_PROPERTIES_ACCESSTOKEN environment variable with toml projects
Fixed bug caused by generation of unrecognized parameters when starting the Redgate Comparison engine process.
Fixed making locations relative to the working directory when using TOML configuration.
When using the new TOML configuration format, 'jarDirs' and 'schemas' will no longer be erased when also configuring certain parameters through the command line or environment variables.
Removed deprecated flyway.check.reportFilename. Please use flyway.reportFilename.
Flyway V10 has landed
Removed deprecated flyway.check.reportFilename. Please use flyway.reportFilename.
The 'cherryPick' configuration option has been moved to a configuration extension. When using the API, it can no longer be directly set through configuration object - instead it is set using an 'cherryPickConfigurationExtension' object which must be retrieved from the plugin register. See the docs for this configuration parameter for more information.
License key logic has been moved into a different module ('flyway-key-licensing'). This is not shipped in the open-source edition of Flyway so attempting to configure the license key will cause an error. In the Redgate edition of Flyway, license keys must be configured as a configuration extension (see configuration docs for more information).
Rename lib/community with lib/flyway
Removal of the default sql folder from Flyway CLI and Docker release
Modularized database support in Flyway to allow greater flexibility. This includes; DB2, Derby, HSQLDB, Informix, PostgreSQL, CockroachDB, Redshift, SAP HANA, Snowflake and Sybase ASE. See Database Support page for your database for module dependency. If you are including Flyway in your project, either as a dependency or via the maven and gradle plugins please include the respective database module in your project configuration.
Remove unused Edition flags documentation, E.G -community or -teams. These flags are no longer used by Flyway and have been marked for deprecation.
The lowest supported Gradle version for the Flyway Gradle plugin is now 7.6. This is due to a known issue with older Gradle versions where it cannot handle dependencies with multi-release chars containing Java 19 code.
Move older db support handling into OSS
If flyway fails due to a licensing issue, return a unique (35) exit code
Adjusted the wording on the 'deleted' Repair action to mention it only marks migrations as deleted
Flyway now supports MySQL 8.1.0.
Include singlestore into Flyway Community Edition.
Google Cloud Spanner has been released and is no longer BETA
Info filters are now available in community
Added auth command to authorize Flyway online using Redgate username and password
Added support for REDGATE_LICENSING_PERMIT_PATH and REDGATE_LICENSING_PERMIT environment variables along with offline licensing for offline machines
beforeEachMigrateStatement, afterEachMigrateStatement, afterEachMigrateStatementError, and beforeConnect callbacks are now Community features
add support for LocalSecrets resolvers
Script migrations are now a Community feature
Retired Java 8 from use. Java 17 is now required for development
Move packages and groupID from org.flywaydb.enterprise to com.redgate.flyway. Duplicate packages will be deployed to org.flywaydb.enterprise until a future release.
Keep software.amazon.awssdk:s3 on latest 2.20.X release to get fix for CVE-2023-4586
The AWS-Secrets JDBC driver included in the Commandline package has been upgraded to 2.0.0.
Issue 3752 add "END CASE" support in BigQuery sql script
Keep software.amazon.awssdk:s3 on latest 2.20.X release to get fix for CVE-2023-4586
Upgrade software.amazon.awssdk:s3@2.20.94 to software.amazon.awssdk:s3@2.20.158 to fix CWE-295
Thanks to kankaiz for reporting these issues.
Fixed configuration disclosure in extended debug output. CVE-2023-43564
Fixed configuration disclosure in extended debug output. CVE-2023-43564
improve parsing of 'ACCESSIBLE BY' clauses in Oracle
Fix parsing issue caused by statements containing multiple sets of parentheses.
Issue 3730 Make SLF4J detection also work with SLF4J 2.0
Thanks to hho for reporting these issues.
Correctly parse Oracle wrapped statements.
Correctly parse Oracle wrapped statements.
Fix filter file option detection
Fix invalid flags not correctly erroring at the end of the arguments
Thanks to trourance for reporting these issues.
Fix issue with check.reportFilename parameter
check.reportFilename parameterBaselineVersion configuration if SchemaHistory table is absent.check.buildUrl, check.buildUser and check.buildPassword are now deprecated. These will be replaced by check.buildEnvironment in Flyway 10.0
Flyway now supports Oracle 21.
Issue 3726 Add MariaDB to Flyway H2 compatibility mode
Thanks to oujesky and iamniche-too for reporting these issues.
Added working directory variable to config
fix handling of plugin string array properties
fix handling of plugin string array properties
Previously, when migrating using Flyway's SQL*Plus feature, Flyway parsed the first statement of the migration script before reading 'login.sql'/'glogin.sql' files. These files are now fully read beforehand.
Upgrade AWS SDK to fix SNYK issue CVE-2023-34462
Upgrade AWS SDK to fix SNYK issue CVE-2023-34462
Upgrade google-cloud-spanner to fix SNYK issue SNYK-JAVA-COMGOOGLEGUAVA-5710356
Upgrade Google Cloud Secretmanager to 2.22.5 to fix SNYK-JAVA-COMGOOGLEGUAVA-5710356
Upgrade Google Cloud Storage to 2.22.5 to fix SNYK-JAVA-COMGOOGLEGUAVA-5710356
Update AWS Java SDK to 2.20.69 to fix SNYK-JAVA-IONETTY-5725787
Issue 3690 flyway-core now has a dependency on jackson-dataformat-toml.
Thanks to froque for reporting these issues.
RGCompare MySql support has gone GA
incorrect license shown above correct license
incorrect license shown above correct license
Issue 3682 Fixed parsing of boolean values in configuration
Thanks to TheHenrick for reporting these issues.
Fix missing Jackson-Annotation dependency in CLI bundle
Improved parsing of CASE expressions inside function bodies.
Improved parsing of CASE expressions inside function bodies.
Fixed a bug encountered when cleaning Azure Synapse instances where Flyway referred to 'sys.xml_schema_collections` which only exists in SQL Server.
The SQLite driver shipped with the Flyway CLI has been updated to 3.41.2.2 to avoid CVE-2023-32697
The SQLite driver shipped with the Flyway CLI has been updated to 3.41.2.2 to avoid CVE-2023-32697
Flyway's SQLPlus 'FEEDBACK' output wording has been adjusted to match Oracle SQLPlus.
Extract Oracle code to plugin. This will need to be added as a new dependency. See Oracle documentation.
Extract Oracle code to plugin. This will need to be added as a new dependency. See Oracle documentation.
Change error code on migration failure to be more specific and include script path and line number of failure in JSON error output
Disable GET_LOCK on MariaDB connections when WSRERP=ON is present. This is to allow for usage of MariaDB with Galera clusters
An event connection will be created to handle callbacks, and this connection will be released instantly after the event handle work is done.
Baseline scripts with the same version number as an applied '<< Flyway Baseline >>' are now put in the 'Ignored (Baseline)' state. Also, migrations in this state appear before the '<< Flyway Baseline >>' in the info output instead of being put at the end.
Update RGCompare version to 1.11.2.9265
driver() method to FluentConfigurationBump maven version to address CVE-2021-29425
Avoid hanging indefinitely during 'check' comparisons when running on Windows.
Running check -changes or check -drift now handles schema creation rows in the schema history table.
All undo migrations will no longer have their own rows in the ASCII-table output. This seemed redundant given that there's a separate Undoable column to provide this information. Also, there was some inconsistency whereby undo migrations in the AVAILABLE state were already filtered out but others were not.
Baseline migrations now have the 'baseline' category in info output
Issue 3665 Only warn if reports are unable to write to the default location rather than print an error
BEGIN ATOMIC.Bump maven version to address CVE-2021-29425
Update documentation to provide solution to Snowflake JDBC JRE16+ issues
Thanks to sseide for reporting these issues.
Issue 3664 ]Bump SQLite JDBC to 3.41.2.1 to address CVE-2021-20227, CVE-2022-35737 and CVE-2022-46908
Fixed the issue causing empty dry run reports when running flyway using the Maven plugin.
Issue 3621 The Snowflake SQL parser can now handle escaping single quotes inside strings using backslash.
Undo migrations which have not been applied will no longer cause validation to fail.
add direct support for Alpine linux
Remove unused Edition flags documentation, E.G -community or -teams. These flags are no longer used by Flyway and have been marked for deprecation. These flags will be removed in V10.
Issue 3648 Ensure Flyway uses ALL_CREDENTIALS when using versions of Oracle where ALL_SCHEDULER_CREDENTIALS is deprecated. This is to avoid continuting to rely on functionality only retained in Oracle for backwards compatibility.
Issue 3652 Remove redundant html extension on automatically generated reports and prevent generation of reports for currently unsupported verbs
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.
Update version of snowflake-jdbc to 3.13.29 to fix SNYK-JAVA-NETSNOWFLAKE-5425048
Issue 3664 Bump Snowflake JDBC to 3.13.3
Issue 3664 ]Bump SQLite JDBC to 3.41.2.1 to address CVE-2021-20227, CVE-2022-35737 and CVE-2022-46908
Issue 3664 Bump MariaDB JDBC to 2.7.9 to address race condition, metadata catalog, ArrayIndexOutOfBounceExcetions and other issues in JDBC driver
Thanks to lm-net, ryangraffy, jdmendozaa and frichtarik for reporting these issues.
Remove placeholder text from report summary
Remove placeholder text from report summary
Fix Nullpointer exception on empty exception in reports
Removed unwanted SLF4J messages on stderr
Removed unwanted SLF4J messages on stderr
Issue 3636 EnvironmentModel: swap back connectRetries and connectRetriesInterval default values
Thanks to mihalyr for reporting these issues.
Nothing published for this version
Issue 3618 Fix reading in configuration from standard input in Teams and Enterprise edition.
Issue 3618 Fix reading in configuration from standard input in Teams and Enterprise edition.
Issue 3621 Fixed a parsing error caused by begin transaction statements in Snowflake.
flyway-bom to use correct versioning system and deploy to Maven CentralThanks to eddumelendez, frichtarik and Phil-Factor for reporting these issues.
Update Ant dependency version to address CVE-2020-11979, CVE-2021-36374, CVE-2021-36373 and CVE-2020-1945 vulnerabilities.
SQL errors with configured overrides no longer cause the Oracle SQLPlus spool output to close prematurely and lead to a null pointer exception.
Issue 3621 Further improvements to the Snowflake parser when detecting conditionally creatable objects.
Thanks to frichtarik for reporting these issues.
If Flyway encounters a SQL exception while Oracle Spool is set, the error information is now written to the Spool output.
Thanks to niegowic for reporting these issues.
When Flyway is running in Oracle SQLPlus mode, character escaping is now disabled by default in order to be consistent with Oracle's SQLPlus command-l
Thanks to zihniogmen for reporting these issues.
Issue 3583 Fixed issues with the Snowflake SQL parser which failed to correctly parse scripting blocks containing 'if' and 'for' statements
Issue 3583 Fixed issues with the Snowflake SQL parser which failed to correctly parse scripting blocks containing 'if' and 'for' statements
Fix issue with code analysis reports not generating when major or minor tolerance threshold has been passed and set build to fail.
Issue 3557 Update latest supported MariaDB version to 10.10
Issue 3602 Flyway now officially supports snowflake versions up to 7.1
Thanks to pachu, hackyoMa and frichtarik for reporting these issues.
Nothing published for this version
Nothing published for this version
Nothing published for this version
Explicitly drop Oracle package bodies so that package bodies not tied to an existing package are also cleaned
'check' reports now produce all successful reports and fail on the first non-successful report
Update RGCompare engine to 1.6.0.7325
Update AWS dependency to resolve CVE-2022-41915
version operations (version or -v or --version) will now list the versions of all plugins (and if they are correctly licensed)
Update AWS dependency to resolve CVE-2022-41915
Thanks to nafg for reporting these issues.
Flyway includes a custom SQL Fluff plugin, containing extra rules for enterprise users. Previously, if this custom plugin failed to install it would f
Flyway includes a custom SQL Fluff plugin, containing extra rules for enterprise users. Previously, if this custom plugin failed to install it would fail the whole process citing an absence of the correct SQL Fluff installation. It now only gives a warning so core SQL Fluff rules can still be run.
Incorrectly errored when validating the configuration for the 'check -changes' command, when using a URL and a snapshot.
Config parameter flyway.executeInTransaction should now correctly set when doing so via an environment variable.
Issue 3582 Fix missing setBaselineVersion(MigrationVersion baselineVersion) on ClassicConfiguration
Thanks to bmarcaur for reporting these issues.
Fix NPE that results when configuring either 'workingDirectory' or 'jarDirs'
The version of the Postgres driver included in the CLI has been increased to 42.4.3 to avoid CVE-2022-41946
Removed the parsing of nested multiline comments from Oracle. This is in line with their documentation that states nested multiline comments are not supported.
Drift results now appear in the JSON and HTML reports when 'failOnDrift' is set and drift is present.
The bundled Regex Rules are now case insensitive
Update error message for invalid CLI argument to reflect possible fixes
The version of the Postgres driver included in the CLI has been increased to 42.4.3 to avoid CVE-2022-41946
Issue 3578 Fix documentation to use correct method to configure url, user and password in API
Thanks to gastaldi for reporting these issues.
Upgrade the version of the Apache Ignite core dependency to avoid a new vulnerability.
The version of RG compare included with Flyway has been increased to 1.2.2.6628. This avoids a bug in which 'check' produced empty change/drift reports for certain SQL Server URLs.
Upgrade the version of the Apache Ignite core dependency to avoid a new vulnerability.
Check reports are written when an exception occurs
Fix issue with Regex Rules looking in the wrong directory by default
Fix issue with Regex Rules looking in the wrong directory by default
Issue 3563 Fixed parsing error with batch statements in GCP Spanner.
Thanks to Glavis for reporting these issues.
Issue 3562 The version of 'jackson-dataformat' bundled in the CLI package has been bumped to 2.14.0 to avoid CVE-2022-42003
We now use 'jackson-dataformat-toml' to read TOML config files, instead of 'night-config'.
All 'check' results include the operation in the JSON result
Include the code analysis engine's name in the summary logs
Bump the version of Redgate Compare to 1.0.0.6319
Move documentation to main repo
Create a Dialect configuration to allow configuration of rules engine dialect via Flyway
Add descriptions to shipped Regex Rules in the check report
Bundled Regex Rules are now enabled by default
Issue 3562 The version of 'jackson-dataformat' bundled in the CLI package has been bumped to 2.14.0 to avoid CVE-2022-42003
Issue 1317 Add SingleStoreDB support at the Teams level
Issue 3570 Cockroach DB is now supported up to the latest version of 22.1
The JSON result for the 'check' command now includes the paths to any generated report
SingleStoreDB JDBC driver is now shipped in the CLI
Allows a configuration ('flyway.check.failOnDrift') to trigger an error if drift is detected with check -drift allowing the build to be halted should drift exist.
Thanks to nycjay, engvalla and basweitjens for reporting these issues.
Update version of MSAL4J to fix CVE-2022-42004
Help output for 'check' no longer returns 'null' when 'outputType=json'
Issue 3552 Fix Snowflake parser to handle nested 'BEGIN...END' statements
Rule codes are now visible in Code Analysis HTML Reports
Update version of MSAL4J to fix CVE-2022-42004
Update AWS SecretsManager to fix CVE-2022-42004
Add bundled Code Analasys RegEx rules for Enterprise tiers
A new rule has been added to the Flyway SQL Fluff plugin, which is applied when running code analysis. This rule checks that all tables created in TSQL have an 'MS_Description' extended property set in the same file.
Add REGEX rules engine to -code for Enterprise tier
Thanks to pachu for reporting these issues.
Increase hsqldb version from 2.6.1 to 2.7.1 to resolve CVE-2022-41853
Move SQLFluff specific components into own module
Increase hsqldb version from 2.6.1 to 2.7.1 to resolve CVE-2022-41853
Issue 3489 PostgreSQL history table indexes and constraints now use the configured tablespace
Issue 3516 Drop PostgreSQL DOMAINs with 'CASCADE'
Provide a Mac CLI for arm64 CPUs
Issue 3535 Added error override behavior which excludes the full error/warning message and only shows the SQL state and error code.
Thanks to dev257, Peter-Laws and oaowren for reporting these issues.
Remove in-product warnings when using PostgreSQL 15
Update version of 'commons-text' to fix vulnerability CVE-2022-42889
Ensure correct version of SQL Fluff is installed
Update version of 'commons-text' to fix vulnerability CVE-2022-42889
Add edition to the version model
When urls are unsupported by check, ascertain which ones are unsupported, and include them as part of the exception.
Add custom code analysis rule that requires tables to have a primary key
Add syntax highlighting to dry run reports
Issue 3519 Replace SQLPlus placeholders that begin with a double '&'
Thanks to cowwoc and ben-peacock-uk for reporting these issues.
Code analysis is now available in Community Edition
check codeFix cases of 'cherryPick' causing issues with change and drift reports
Fix cases of 'cherryPick' causing issues with change and drift reports
Fix bug where 'installedBy' wasn't always populated during a baseline
Fixed bug when checking for changes or drift when multiple schemas are configured
Fix issues with Community Fallback
Fix issues with Community Fallback
Fix Windows paths with spaces causing classpath issues
Add Community fallback warning to JSON output object
Add Community fallback warning to JSON output object
Show correct validation message when checking for license keys that have expired.
Fix issue with Flyway not running correctly on Macs with a path that has a space
Fix issue with Flyway not running correctly on Macs with a path that has a space
Added null-check to avoid NPE when scanning inaccessible locations
Fix bug in 'check' when comparing non-Oracle databases with configured schemas
Issue 3515 Drop MariaDB JDBC driver back to major version 2 to enable MySQL compatibility
Thanks to juliahayward and hemberger for reporting these issues.
change and drift reports now fail for incompatible database types
Check report UI improvements
change and drift reports now fail for incompatible database types
Remove JNA dependency as no longer needed by MariaDB
Increase MariaDB driver version to 3.0.7
Move flyway-commandline runtime dependency to correct scope
Thanks to filiprichtarik for reporting these issues.
Fix problems when appending to code analysis reports
Fix problems when appending to code analysis reports
Fix bug in 'check -code' where multiple SQL files were not being correctly linted
Configured suffixes are now case insensitive
Improvements to the 'check' report
Remove the error information from 'CompareResult' so that the existing JSON error handling is used
Remove unnecessary dependencies
Moved Undo command into flyway-proprietary
Remove unnecessary maven-model dependency
Make 'CompositeResult' generic
Issue 3505 Include transitive GAX dependency in CLI
Thanks to jward-premise for reporting these issues.
Issue 3499 connectRetriesInterval now defaults to 120 instead of 0 on the Maven plugin.
Thanks to mihalyr for reporting these issues.
Add SQLFluff to redgate/flyway Docker image for use with new integrations
Issue 3498 Updated dependencies to fix vulnerabilities
Thanks to ggolawski for reporting these issues.
Add access to Community features for Teams and Enterprise artifacts when no license key is given
Add access to Community features for Teams and Enterprise artifacts when no license key is given
Issue 3491 PostgreSQL session locks now use one connection
Thanks to henricook and hackyoMa for reporting these issues.
check includes all transitive dependencies so it runs out of the box
check includes all transitive dependencies so it runs out of the box
Issue 3479 BigQuery procedures containing END AS are not cut off early.
Issue 3487 Update ensured supported to latest documented versions for Oracle and Snowflake
Thanks to arshaknorsoyan, matmannion and odin568 for reporting these issues.
### Due to issues in the release process, this version is to be skipped as the artifacts are incomplete.
### Due to issues in the release process, this version is to be skipped as the artifacts are incomplete.
Change reports now html encode SQL.
One column per quarter.