Is there a cleaner/more straightforward way to undo a bad migration in a dev/test environment? I had a migration that was committed to a dev branch deployed to a test system. The migration failed, so I simply deleted the

migration.sql

file, and deleted the record in

_prisma_migrations

and tried to re-deploy but it didn’t work. My flow now is to restore the db to the point before I deployed the broken migration, but it would be nice if there was a easier way to simply remove a migration and not do it before it goes to a higher level environment

Hey Adam, could you elaborate on “it didn't work”? What command did you run after modifying the migrations table?