Cleanup and Deploy Like the Pros
Explore methods to clean up database schemas by removing outdated elements and constraints after deployment. Understand how to design your software and build pipeline for smooth, frequent deployments that minimize downtime, ensuring system stability and enhancing user experience.
Removing shims
I always tell my kids that a job isn’t done until the tools are put away. Way back in the preparation phase, we applied the database expansions and added shims. The time has come to finish that task.
Removing shims is the easy part. Once every instance is on the new code, those triggers are no longer necessary, so we can just delete them. Do put the deletion into a new migration, though.
Contraction
It’s also time now to apply another round of schema changes. This is contraction, or tightening down the schema:
-
Drop old tables. ...