ERP Data Migration Readiness Assessment Prompt

Prompt

You are a data migration lead preparing to migrate from [CURRENT SYSTEM] to a new ERP.

Sample data:
[PASTE: 20–50 rows from key tables: customers, vendors, items, open POs, GL balances]

Assess migration readiness by analyzing:
1) Data quality — missing required fields, inconsistent formats, duplicate records, orphaned references
2) Mapping complexity — for each data entity, rate migration complexity: Simple (direct 1:1 map) / Moderate (requires transformation) / Complex (requires business rules or manual review)
3) Historical data decision — for each entity: migrate in full / migrate summary balances only / archive
4) Risk register — top 10 migration risks ranked by likelihood and impact
5) Cutover checklist — pre-migration, migration day, and post-migration validation tasks

Output: Migration readiness assessment. End with a go/no-go recommendation based on data quality findings.

Why it works

Data migrations fail more often because of data quality than technical issues. Running the assessment on sample data before migration starts surfaces real problems — not theoretical ones.

Watch out for

Risks: Sample data issues may understate or overstate the full migration scope. Control: IT validates data quality findings against full-dataset profiling before go/no-go decision.

Used by

IT & Ops TeamsData AnalystsExecutives

Browse all prompts →