Database Migrations

Safe migration strategies for production databases.

Development Migrations#

Create Migration#

Reset Database#

Production Migrations#

Deploy Migrations#

CI/CD Integration#

Safe Migration Patterns#

Adding a Column#

Adding Required Column with Default#

Renaming a Column#

Adding an Index#

Changing Column Type#

Zero-Downtime Migrations#

Expand-Contract Pattern#

Dual-Write Pattern#

Handling Breaking Changes#

Deprecate Before Remove#

Feature Flags for Migrations#

Migration Scripts#

Batch Data Migration#

Verify Migration#

Rollback Strategies#

Automatic Rollback Script#

Point-in-Time Recovery#

Best Practices#

1. Always backup before production migrations
2. Test migrations on staging first
3. Use transactions for multi-step migrations
4. Create reversible migrations when possible
5. Monitor database performance during migrations
6. Run migrations during low-traffic periods
7. Have a rollback plan ready

Related Recipes#

• Prisma Setup
• Multi-Tenant Database