Schema changes are hard. They're hard because there are multiple different failure modes, some of which require knowledge of how the underlying RDMS system works, especially with regard to object locking. Broadly speaking, there are two classes of breakage that can occur when applying database migrations: Migrations that make incompatible changes to the schema, breaking client applications.Migrations that lock a database object for an unacceptable amount of time, causing the application to becom...