Table comparison between two databases

[codehead]

Hello,

I am trying to compare the same table on both our development and production databases to find the differences. I can connect to both databases with Access 97 and I have linked to the tables in it (they are too large to import), but I can't seem to figure out how to compare each field for differences. I suspect that I need to write some VBA code, but I need an example. Or I could create a small Java program, but again I need an example to use as a starting point. I asked my DBA to link the two tables, but he refuses to do it because of the administration headaches. Has anyone done this before? Can anyone point me to an example/reference?

Thanks!

 

[alexhu]

This may give you a start

http://www.oracle.com/oramag/code/tips1999/index.html?cod03309.html

Alex

 

[fmorel]

You may also tell your DBA that what's your trying to do should be a part of his job ! ;-)

As described in Alexhu's documents, the most usefull tools seem to be database links and "minus" statements.

But be careful for the network overhead using database links!

 

[Turkbear]

There is ( or was) a product called Oracompare.exe
available from

http://www.niderost.com/OraCompare.zip

That will compare 2 schemas in different instances and show the differences..

I haven't used it lately, but I seem to remember it works ok..