QA Fundamentals · Senior · Question 53 of 76
How do you test a data migration?
- 1Compare counts, checksums and samples before and after, plus rollback
- 2Check that the migration script has no syntax errors before running
- 3Test only that new records can still be created after the migration
Show the answer
Correct answer: Compare counts, checksums and samples before and after, plus rollback
Explanation
Migrations can silently lose or corrupt data. Reconciliation queries, spot checks of tricky records and a rehearsed rollback reduce the risk.