Data Migration

The Law

EVERY MIGRATION NEEDS A ROLLBACK.
A migration without a rollback plan is a one-way door.
Before you open it, know how to close it.

When to Use

Use this skill before:

• Any ALTER TABLE in production
• Any column rename, type change, or removal
• Any large UPDATE or DELETE (more than 1000 rows)
• Any index creation on a large table
• Any data backfill or transformation script