Flyway Stream Setting
Published 15 January 2025
Description
Whether to stream SQL migrations when executing them. Streaming doesn't load the entire migration in memory at once. Instead each statement is loaded individually.
This is particularly useful for very large SQL migrations composed of multiple MB or even GB of reference data, as this dramatically reduces Flyway's memory consumption.
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
./flyway -stream="true" info
TOML Configuration File
[flyway]
stream = true
Configuration File
flyway.stream=true
Environment Variable
FLYWAY_STREAM=true
API
Flyway.configure()
.stream(true)
.load()
Gradle
flyway {
stream = true
}
Maven
<configuration>
<stream>true</stream>
</configuration>