database version upgrade

pecks

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. 

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!

pecks

thanks, I have been playing with repair and it looks like it will solve our issue