Data Migration Script With Validation and Rollback
Move data between systems safely.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
Plan and write a data migration with validation and rollback. Source and target systems: [SOURCE_AND_TARGET]. Data entities and approximate volumes: [ENTITIES_AND_VOLUMES]. Mapping rules and transformations: [MAPPING_RULES]. Allowed downtime: [DOWNTIME]. Language: [LANGUAGE]. Use this checklist as requirements and show how each is met: [ ] A full, tested backup of the target and a verified copy of the source before any change [ ] Dry run on a copy with production-sized data; timings recorded [ ] Mapping document: each source field to target field, type, default, and transformation, with unmapped fields listed [ ] Idempotent and resumable: the script records progress and can restart without duplicates [ ] Batching with transactions and sensible batch sizes [ ] Validation before: schema checks, required fields, referential integrity, duplicates [ ] Validation after: row counts per entity, checksums or sums of key numeric fields, sample record comparison, orphan checks [ ] Error handling: rejected records written to a file with reasons, not silently skipped [ ] Logging with run ID and counts [ ] Rollback plan: how to restore, the point of no return, and a decision rule [ ] Cutover plan with freeze, final delta sync, switch, and a smoke test [ ] Communication plan for users Deliver the script, the validation queries, a runbook with timings, and a go/no-go criteria list.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.