Update flyway.batch to include CREATE files
For flyway.batch can create files be included in batching of files together. This could allow for large set of create statements to be batch together for things when there are hundreds of migrations that can be rolled out faster.
Nick Pileggi
shared this idea
Hi.
I'm not sure if I fully understand the suggestion. You can put multiple CREATE statements in the same V script. In Flyway Enterprise, we can do this for you in SQL Server, Oracle, Postgres, and MySQL; and we work out the dependencies for you.
Another thing might be to consider re-baselining, if you have a lot of V scripts and need to get them all in 1 B script - https://documentation.red-gate.com/fd/rebaselining-208896090.html.
If you'd like to talk more about this so I can better understand this suggestion, please schedule a 15 min zoom with me at https://calendly.com/stephanie-herr/15min-1?month=2023-11.
Thank you!
Stephanie Herr :-)
Product Manager, Database DevOps