I have a application where one module is developed with Oracle database and other module is developed with DB2 database. I have to create a tool which will compare common entries in tables of the 2 databases.
- Posted by: Dhir T
- Posted on: November 02 2004 05:53 EST
How can I compare the entries in tables of the databases? I have to achieve the result using servlets.
Please guide me.
A prompt response will be highly appreciated.
Thanks in Advance!
To tell the truth the simplest way to do this is to use a product that will let you Join across the two databases and then use a select ... from oracletable INTERSECT select ... from db2table.
The way I know of doing this would involve using a database link from Oracle to DB2 via the relevant transparent gateway (see http://www.oracle.com/technology/products/gateways/index.html) . This is all from the Oracle driving direction, although you could always to the same thing in reverse from DB2 I suspect