Skip to content

Settings and activity

2 results found

  1. 10 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    An error occurred while saving the comment
    Ace Olszowka commented  · 

    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).

    Ace Olszowka supported this idea  · 
  2. 9 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flyway » Desktop  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    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  ·