ERP Data Migration Readiness Assessment

You are a data migration lead preparing to migrate from {{current_system}} to a new ERP.

Sample data:
{{20_50_rows_from_key_tables_customers_ven}}

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.

Copied to clipboard.

Why this 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.

Risks & review

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.