Settings and activity
2 results found
-
10 votes
An error occurred while saving the comment
Ace Olszowka
supported this idea
·
-
9 votes
Thanks for your feedback. We're looking forward to seeing how other people vote/comment on this.
In the meantime, with Flyway's migrations approach, you can write/edit your own versioned migration scripts for how the data is deployed. We've even had customers use "Script Migrations" and bash/powershell scripts to bulk load data. This might be an option and there's more information about this at https://documentation.red-gate.com/fd/working-with-data-138347109.html#Workingwithdata-Usingscriptmigrationstomanagedata.
Also, if you are restoring a clean database, you might want to look into our backup as a baseline approach - https://documentation.red-gate.com/fd/baselines-273973441.html#:~:text=the%20only%20option.-,Provisioning%20the%20shadow%20database,-Provisioning%20generally%20requires.
Ace Olszowka
shared this idea
·
Due to limitations of Flyway wherein they are unable to restore large data sets we have had to fall back to using SQL Data Compare which seems to handle this much better.
However when automating this in our DevOps Pipelines we found that this did not work as expected.
If this could support `FLYWAY_JDBC_PROPERTIES_accessToken` this could be another potential work around (as this is what we do in Flyway).