Migration Writing

Purpose

Write database migrations that safely modify schema while preserving data integrity.

When to Use

• New table/column additions
• Schema modifications
• Index changes
• Data transformations

Process

1. Plan migration
2. Write forward migration
3. Write rollback (if needed)
4. Test in development
5. Test with production-like data