How can we help you today? How can we help you today?

database version upgrade

We use Flyway, and need to upgrade our databases from MySQL 5.7 to 8.0. Our existing SQL will then be invalid, due to some changes in MySQL. However, we can not change the SQL, as Flyway will break. I assume this has been solved many times, apologies but I could not find the answer.
pecks
0

Comments

2 comments

Sort by
  • Robyn
    Hi, 

    Thanks for your post!

    Are you referring the migration checksums would change which flyway would object to? 

    If so, this can be solved by running the repair command to recalculate the checksums.
     
    What we would recommend is:
    • take a backup of their scripts, so they can always revert if needed
    • Make the alterations to the SQL
    • Run repair in flyway to recalculate
    I hope this is useful!
    Robyn
    0
  • pecks
    thanks, I have been playing with repair and it looks like it will solve our issue
    pecks
    0

Add comment

Please sign in to leave a comment.