I’m in the midst of trying to lead non-test professionals (business analysts & users) through a total dat a migration from one CRM system to another. There have been two test runs of the conversion scripts so far (which are being written by consultants). It’s going badly in the sense that the second test migration had more errors in it than the first. 
That means another test run of the migration has to happen before we get to the go-live, and I’ve been asked, “isn’t there a better way to run these conversion tests?” Well, we were doing a partial reconciliation based on the UI, because we have non-technical folks to do the testing (not SQL users). Then we added in functional tests to start to check out workflows. But there are so many errors, just the bug writing is bogging everything down. I don’t really know how to come up with a magical “better way” to test the migration. Any suggestions?