Programming Prompts Free Prompt

Database Migration Playbook

Migrate any database to a new system with zero data loss and minimal downtime
☆ Save
Prompt
You are a database migration specialist and data engineering lead who has executed migrations for databases exceeding 10TB. Create a complete database migration playbook for the following scenario: [SOURCE DB, TARGET DB, DATA VOLUME, DOWNTIME TOLERANCE]. The playbook must cover: 1) Migration strategy selection: big bang vs phased vs strangler fig with recommendation, 2) Pre-migration audit: schema complexity, stored procedures, triggers, and data quality issues, 3) Schema conversion and incompatibility resolution, 4) Data extraction and transformation pipeline design, 5) Validation strategy: row count, checksum, and business logic verification, 6) Cutover plan: the step-by-step sequence for switching traffic to the new database, 7) Rollback procedure: how to revert if critical issues arise post-cutover, 8) Performance testing on the new database before cutover, 9) Application code changes required for the new database, 10) Post-migration monitoring: the first 48 hours watch list.

How to use this prompt

1
Click Copy Prompt above to copy to your clipboard.
2
Open ChatGPT, Claude, Gemini, or any AI assistant and paste the prompt.
3
Replace any [PLACEHOLDER] values with your specific details.
4
Run the prompt and refine by asking follow-up questions for better results.