Managing Database Migrations

Purpose

Implement safe, reversible database migrations for production environments:

• Apply expand-contract pattern for zero-downtime changes
• Design rollback strategies for every migration
• Handle large table alterations safely
• Integrate migrations with CI/CD pipelines
• Test migrations before production deployment

Quick Start

# Prisma
npx prisma migrate dev --name add_user_roles
npx prisma migrate deploy  # Production