Flyway

Flyway v10 - upgrading from Flyway V9

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 use reportFilename 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.


Didn't find what you were looking for?