Relational Database Schemata
Learn about programmatic control, relational database schema, schema changes, and combining old and new schema.
We'll cover the following...
Programmatic control
Database changes are one of the driving factors behind “planned downtime,” especially schema changes to relational databases. With some thought and preparation, we can eliminate the need for dramatic, discontinuous, downtime-inducing changes. We probably have a migration framework in place already. If not, that’s definitely the place to start. Instead of running raw SQL scripts against an admin CLI, we should have programmatic control to roll our schema version forward.
Remember: It’s good for ...