Testing in data conversion projects
During legacy migration its imperative that the migrated data be tested for logical consistency
When working on projects involving Conversion of data or Migration/Moving of data from a legacy database. The testing effort is enormous and testing takes a lot of time, some test automation can help this effort.
Since data is moved/changed from a source database to destination database, we can write sql which should provide results for the types of tests you want to perform, for example: write a sql to give us number of customers, write a sql to give us account balance for a specific account.
Posted by Pramod Sadalage on Wednesday, November 18, 2009