I have somebody creating a C# class to migrate data from one SQL database to another slightly differently structured SQL database.
Please can anybody suggest ways to verrify that the data has migrated successfully, in whole and acurrate??
I feel a sample approach would not quite be substancial.
I want to keep it seperate from the migration process itself (having my person write a verification script may also not work as he will be using the same thought processes and knowledge that he used for the migration)
Free Software, scripts, utilities, packages, industry approaches??
Sorry Im no Tech wizzard, Any ideas appreciated.....................
Sorry can you expand on that.
I appologise for not being able to be very specific with my question at this stage.
What kind of dependancies? could you give some examples.
What possible verification methods are there?
This would probably help me plan the migration (its important to know this now before the data is migrated and it is too late to consider verification).