Question 7 of 10Pro Only
During a database migration, you discover data inconsistencies between the source and target. Some data appears to be missing on the target. How do you investigate, quantify, and resolve this issue while the migration is in progress?
Sample answer preview
Discovering data inconsistencies during migration is a serious situation that requires immediate, methodical investigation. Panic-driven responses like restarting the entire migration can make things worse.
data validationrow count comparisonCDC gapLOB migrationchecksum comparisonDMS validation