Im working on a data migration project and Im looking for a tool that would allow us to validation of the data after the load. The target db is an Oracle database and I would like to be able to find a way to automate the process of validating each record that was added coming in from the extract file. Does anyone have experience in this or worked with a tool that would have this type of function.
One path Im thinking of is to capture/playback to run the sql scripts and then compare the results on a line by line basis.
Any help would be appreciated.
I usually do an extract from the source, extract from the target and then difef the two. Or you can data-link in Excel to create and import two sets of the same data (source & target), and then use an Excel formula to compare the result sets.
Ive tested data warehouses like this with a lot of success.
I just did a data migration project and I used Selenium with Excel (and some macros).
But my project was a webbased app, so I also had to check the values in the application, and because of that Selenium was a good choice.
So one row in Excel was the testcase that contained the keyphrase, input parameters and expected results (versus database and application user interface) Through the iSQL webinterface of Oracle I could enter the SQL queries on the new database.
In my case testing all data was not possible because of the size of the databases. So I had to use Equivalence Partitioning and Boundary Value Analysis to find testcases.