Toad World® Forums

Compare large set of tables between two databases.

I have two oracle database environments (PeopleSoft) and a set of 1296 tables that I need to compare. How do I accomplish this? I know how to do 1 table to 1 table but need a better method. New to Data Analysts; appreciate the help.

Amy

If you need to compare data, use the Data Compare utility located under Tools | Compare.

If you need to do a schema compare I would use Schema Compare in the Toad for Oracle tool.

Debbie

From what I can tell, the data compare only allows me to compare one table at a time and it takes forever to process. I have 1200 tables…is there a way for me to select all the tables I need to compare?

To can compare all tables in the same schema. Just set up the target and key columns for each table. See screenshot.

Debbie
Compare.png