DB Migration Strategy

Overview

Use this skill to evolve schemas in production without service disruption or hidden data corruption.

Scope Boundaries

• Schema changes affect live read/write paths.
• Multiple service versions must coexist during rollout.
• Data backfill or contract transition is required.

Core Judgments

• Migration pattern: expand-contract, dual-write, shadow-read, or phased cutover.
• Compatibility window duration and supported versions.
• Backfill approach and execution safety.
• Rollback semantics and data reconciliation strategy.