There are tools that will break each statement into a different migration, and apply a larger grouping by the files you create. I have actually never seen peop

There are tools that will break each statement into a different migration, and apply a larger grouping by the files you create. I have actually never seen people adopt those. And the "enterprise" tools people tend to circle around seem to create more failure modes than it helps solving. But I imagine somebody uses them somewhere. Without those tools, you can break your migration around the failure point and mark the first half as complete. You should have some way to mark them, because you always need some channel for "free" management of a database. Anyway, transactional DDL is great.