Updating Schema History table for Flyway

Aveek Das
Aveek Dashttps://datacloudmag.com
Data Engineer, Cloud Data Architect, Thinker, Traveler, Amateur Photographer. Enjoys short walks for hot chocolates. Blogs @ https://datacloudmag.com

The default version history table for Flyway has been changed to {schemaname}.flyway_schema_history from Flyway 7.0 onwards. However, for backwards compatibility, we need to set it to fallback to the previous table name {schemaname}.schema_version.

Steps to update

  1. Go the the flyway configuration file.
  2. On MacOS, it can be found under the following directory – ‘usr/local/Cellar/flyway/7.2.0/libexec/conf/flyway.conf‘.
  3. Find the code block flyway.table and assign the name schema_version to it.
  4. Save the file and run flyway.