Flyway v10 - upgrading from Flyway V9
Published 02 November 2023
There are a few things to be aware of when migrating your project from Flyway v9 to v10.
Things that may affect you
Flyway reports
- If you are using the
check.reportFilename
you will have to now usereportFilename
instead, see the reportFilename Documentation - Report generation is now off by default, see the reportEnabled documentation for information on how to change Flyway's reporting behavior.
SQL folder
This was a default location for Flyway to look for your migration scripts but it is regarded as bad practice to have your migrations located in the same place as the tool itself so we have removed the folder altogether. You can direct Flyway to look in a specific location using the Locations parameter.
SQL Server clean behavior
There was a private parameter, plugins.clean.mode
, that may have been included in your configuration if you used Flyway Desktop previously.
This has been renamed and made public now, see sqlserver.clean.mode for details.
API Users (Java/Maven/Gradle)
Database modules
Be aware that a number of databases have moved into their own modules from flyway-core.
You will need to update your dependencies if you are using: DB2, Derby, HSQLDB, Informix, PostgreSQL, CockroachDB, Redshift, SAP HANA, Snowflake and Sybase ASE. See the specific database support page for further information.
Changed Configuration Parameters
These only exists in the Redgate distribution
licenseKey - this has moved, see License Key for further information
undoSqlMigrationPrefix - this has moved, see undoSqlMigrationPrefix for more information
cherryPick - this has moved, see Cherry Pick for more information
Opportunities to update
Support for older databases included in Community
We are keen for our users to adopt the latest version of Flyway and previously this required purchasing a license key to use old versions of databases. We've taken away this requirement so now there is no reason not to upgrade Flyway.
TOML
Flyway now supports a new configuration format that is clearer and more extensible than the existing conf format. We haven't removed support for the .conf file but it won't be developed further.
You can find out more in: What is TOML ? and the TOML Configuration File documentation. If you want to get started then Flyway Desktop can convert your existing .conf file into a toml format automatically
Redgate Licensing
We've added online licensing to Flyway so you can use the Auth verb to get your license online and avoid the pain of managing the legacy Flyway license key. The legacy system still works though but we don't plan on issuing new license keys this way.