Hi,

If you want to make sure that data is the same between
2 databases, the fastest way is probably to clone one
database to another. Unless you have a small db, I
think this is the fastest way.

If you want something to compare table structures, etc,
there are a number of tools available. One of them is
at http://www.ezsql.net.

If you want to compare the data just one table at a time,
do it like this : (you don't need a tool!)

select * from mytable
MINUS
select * from mytable@remote_db;

If you don't get any rows, then reverse it like this :

select * from mytable@remote_db
MINUS
select * from mytable;

If you STILL don't get any rows, then your tables are identical.

-John
http://www.ezsql.net