Post-Migration Data Integrity Scorecard

The migration is "done." The cutover happened Friday night. Users are back in the system Monday morning. Your project manager sent the completion email.

But you're not celebrating. You're refreshing queries.

Did the customer records make it? All of them? Are the relationships intact—does Account A still connect to Contact B and Opportunity C? What about the historical data, the attachments, the custom fields nobody documented?

You ran validation scripts. They passed. But "passed" means "no errors thrown," not "everything is correct." The scripts check what you told them to check. They don't surface what you forgot to ask.

Record counts match. That's not the same as data integrity.

This scorecard turns "I think we're good" into a number you can defend.

Score your migration across four dimensions: completeness (did everything make it?), accuracy (is it correct?), consistency (do relationships hold?), and timeliness (is temporal data intact?). Each dimension breaks down into specific checks. Each check produces a score. The aggregate tells you—with confidence—whether your data survived the journey.

When checks fail, issues flow to the remediation tracker. Not a generic backlog—a kanban built for data integrity work, with severity levels, owners, and resolution status. The scorecard updates as you fix. Your integrity score climbs from 94.2% to 97.8% to 99.1%.

Sample data shows a CRM migration with 2.3 million records: 98.7% record count match, but 847 orphaned contacts, 23 broken account relationships, and 12 records with corrupted date fields. See how the scorecard surfaces what COUNT(*) misses.

Transform "did everything make it?" into measurable confidence. Score completeness, accuracy, consistency, and timeliness—then track remediation for anything that didn't survive intact.