Currently our site is about to undertake a major migration to Oracle from
a proprietary platform. To test whether the conversion has been
successful we need to compare groups of tables in the same tablespace,
different tablespaces, and different databases.
e.g. Comparing the data in BORROWER table with data in
OLD_BORROWER table
We will be dealing with quite large tables and our current approach was
that programs were written in PRO*COBOL to compare data on a field level
and spitting out details when fields did not match. This was a very slow
option and I was wondering if there was any other way to do it or if
there was some third party software that existed to do this.
Thanks in advance for any help or suggestion,
PETER HAYES DBA, Analyst/Programmer, Chief cook and Bottlewasher
Received on Fri Apr 28 1995 - 00:00:00 CEST