flyway icon indicating copy to clipboard operation
flyway copied to clipboard

Script squashing

Open juliahayward opened this issue 4 years ago • 2 comments

Another feature request for consideration - functionality to squash a number of small scripts into one larger one and make the corresponding updates to the history table.

juliahayward avatar Mar 11 '21 16:03 juliahayward

This would be really helpful at my current client as well. They had a script populating a metadata table that was 10k lines, where the deployment took < 5 minutes. At my recommendation, they split it up into multiple files, but now the deployment takes around 20 minutes, with the same amount of data. Even with separate INSERT statements, I suspect something like this would dramatically reduce the deployment time.

davidov541 avatar Feb 02 '23 17:02 davidov541

We want this, but the only thing we care about is to squash all sql files into 1 file, not to squash X amount of files. Related to https://github.com/flyway/flyway/issues/470

gregjotau avatar Aug 11 '25 16:08 gregjotau