It’s possible to configure SQL migrations on a per-script basis.
This is achieved by creating a script configuration file alongside the migration. The script configuration file name must match
the migration file name, with the
.conf suffix added.
For example, a migration file
V2__my_script.sql would have a script configuration file
Script Config Files have a separate set of options from the other ways of configuring Flyway (e.g.
flyway.conf). See the Reference at the bottom of the page for the complete list of options.
Script config files have the following structure:
# Settings are simple key-value pairs key=value
# Manually determine whether or not to execute a migration in a transaction. This is useful for # databases like PostgreSQL and SQL Server where certain statements can only execute outside a transaction. executeInTransaction=false