I would recommend setting up a staging app with a copy of the production database, testing a migration script there, then running the same script on production

I would recommend setting up a staging app with a copy of the production database, testing a migration script there, then running the same script on production once you're confident.