Skip to main content
APIPLUS
Training
Background and History
Backend
Frontend
Linux
Container
Tools
Knowledge
Careers
Sign In
Design Guidelines
SQL Design Manual
Database Migration
On this page
Unauthorized access. Please log in.
Previous
Database Normalization
Next
Setting up your PC
What are database migrations
Challenges with database migrations
Successfully migrating existing data
Making changes reversible
Testing schema changes
Performance and availability impact
Strategies
Planned maintenance: upgrading schemas with downtime
Blue/Green Deployment
Feature Flags
Canary Releases
Expand and contract pattern
Hitch Hiker's Guide to Schema Migration
Avoid destructive change. Instead, always aim for additive schema change
Follow the convention
Balance database normalization until it hurts. (Then relax)
Thou shall write tests