Break down this database migration into safe steps. Migration goal: {{migration_goal}} Current schema: {{current_schema}} Database: {{database_type}} Table size: {{size}} Decompose into: 1. PRE-MIGRATION VALIDATION - Data validation checks - Backup verification - Rollback plan confirmation 2. SCHEMA CHANGES - Each DDL statement as separate step - Order to minimize locks - Backward compatibility checks 3. DATA MIGRATION - Data transformation scripts - Batch processing strategy - Progress tracking approach 4. INDEX OPERATIONS - New indexes to create - Indexes to drop - Concurrent vs blocking 5. APPLICATION CHANGES - Code changes required - Deployment sequence 6. VALIDATION - Post-migration data checks - Performance validation - Rollback triggers 7. CLEANUP - Old schema/data removal - Documentation updates
Database Migration Breakdown
Break down a database migration into safe, executable steps.
71 copies0 forks
Share this prompt:
Details
Category
CodingUse Cases
Migration planning supportDatabase change breakdownSafe deployment planning
Works Best With
claude-opus-4.5gpt-5.2gemini-2.0-flash
Created Updated Shared