CODEWITHSUNDEEP
flyway
Dennis
Dennis

Reputation: 51

Is there a limit on the migration file size in Flyway?

We have massive reference data that we want to load when creating environments using Flyway. We can split it, but it will be useful to know if there is a limit on script file size in Flyway. I understand it's most probably related to memory and heap size, in this case, is there a way to calculate the maximum file size?

Upvotes: 4

Views: 1993

Answers (1)

Axel Fontaine
Axel Fontaine

Reputation: 35169

Flyway Community Edition will load and parse your files in memory, so the heap size will be the biggest constraint.

Flyway Pro and Flyway Enterprise 5.1 and newer now also have the flyway.stream flag which makes Flyway stream the contents instead. This lets Flyway handle much larger files (multiple GBs are not an issue) with drastically lower memory requirements. See https://flywaydb.org/documentation/commandline/migrate#stream

Upvotes: 3

Related Questions