You can verify the transformation logic and compare the data in the old and new DB.
Verifying all the rows of a particular table manually is too time consuming and requires huge effort. You can write scripts to verify and compare each column value in every row. But this might get really messy if there is huge change in the DB.
I think you should take up jonty's suggestion and not use QTP.