Flyway Mixed Setting - Flyway

Description

Whether to allow mixing transactional and non-transactional statements within the same migration. Enabling this automatically causes the entire affected migration to be run without a transaction.

Note that this is only applicable for PostgreSQL, Aurora PostgreSQL, SQL Server and SQLite which all have statements that do not run at all within a transaction.

This is not to be confused with implicit transaction, as they occur in MySQL or Oracle, where even though a DDL statement was run within a transaction, the database will issue an implicit commit before and after its execution.

Type

Boolean

Default

false

Usage

Flyway Desktop

This can't be set in a config file via Flyway Desktop, although it will be honoured, and it can be configured as an advanced parameter in operations on the Migrations page.

Command-line

powershell

./flyway -mixed="true" info

TOML Configuration File

toml

[flyway]
mixed = true

Configuration File

properties

flyway.mixed=true

Environment Variable

properties

FLYWAY_MIXED=true

API

java

Flyway.configure()
    .mixed(true)
    .load()

Gradle

groovy

flyway {
    mixed = true
}

Maven

xml

<configuration>
    <mixed>true</mixed>
</configuration>