35 / 65 · 15 SQL & Database Testing · Migration Testing← prev⊞ allnext →☰ Read as one page
5.3Migration Testing Checklist
| Test | How |
|---|---|
| Migration applies cleanly | Run on a copy of production schema |
| Rollback works | Apply, roll back — schema returns to original state |
| Data is preserved | Insert known data before migration, verify after |
| Default values | New NOT NULL column must have a default — verify existing rows |
| Performance | Adding index on large table must not lock for minutes |
| Application compatibility | New schema works with both old and new application code |