Database Migration

Overview

Help create and manage database migrations, generating complete migration files following the project's database framework conventions.

Steps

1. Migration Analysis
   • Review current database schema changes needed
   • Identify data transformation requirements
   • Check for potential data loss or corruption risks
   • Analyze performance impact of schema changes
2. Migration Script Generation
   • Create up and down migration scripts
   • Include proper indexing and constraint management
   • Add data migration logic where needed
   • Implement rollback procedures
3. Best Practices
   • Ensure migrations are atomic and reversible
   • Add proper error handling and validation
   • Include progress monitoring for large datasets
   • Consider zero-downtime deployment strategies
4. Testing Strategy