Re: Compare Databases How ?

EZSQL (www.ezsql.net) will compare 2 schemas and tell you all the differences between them. It costs about $400 less than TOAD becuase it is sold by an individual, not a big corporation.

It won't tell you the data differences within a table (although it's on the enhancement list) but here is an easy way for you to do that :

1. Create a DB Link in one database to the other.
2. Run these queries :

    Select * from mytable
    minus
    select * from mytable_at_the_other_db;

    select * from mytable_at_the_other_db
    minus
    Select * from mytable;

    The queries will only return rows that are different or missing from one database or the other. If it does not return any rows, the data is the same in both tables!

Sent via Deja.com
http://www.deja.com/ Received on Tue Feb 06 2001 - 11:22:08 CST