Toad World® Forums

compare

Hello ,

I need to know compare data, the tables should have the same table name & the same columns name

and we can compare tables in different database ?

and also compare schema in different database or the same database

Thanks

and we can compare tables in different database ?

Yes. If there is no DB link between them, then we can compare two tables if they are small enough to be loaded into your PC’s memory. If there IS a DB link between them, then they can be much larger (in this case, we’ll use queries to do the comparison work).

compare schema in different database or the same database

Either one.

ok thanks for your reply

but what about table name or column name …it should be the same or not?

Sorry, I missed that one. Table names do not need to match. Column names do. But if they do not, you can work around that by creating a view for one of the tables, and make the column names in the view match the column names in the table that you are comparing it to. Then you can compare the view to the table.