Does anyone suggests testprocess for datamigration testing. We have one old website that would be redesigned by adding some extra features. But all the profiles exsiting in old website are migrated to new site.
From testing point of how can we compare the data, can we do this comparision by using any automation tool.
Replies are helpful.
I've been involved in several projects which included data migration. Just a few questions:
1. How is the data going to be migrated? What format? spreadsheet, data tables?
2. What is your test approach? Have you said what QA will be testing? Data integrity once it has been migrated? Will you be using a data loader?
3. What is the time frame for the data migration test? This will dictate the amount of testing you will be able to accomplish
The important thing is not to stop questioning.
1.create some simple Query in Source and Destination Db and import that record into excel to check easily
2.in the front view you can check the Constraints like primary, foreign key, not null etc
3.do simple walk through for that new Application to check all the front end validation (edit, delete functionality) for only that old records