# Compare large set of tables between two databases.

**URL:** <https://forums.toadworld.com/t/compare-large-set-of-tables-between-two-databases/6676>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [June 27, 2011, 8:24am UTC](https://forums.toadworld.com/t/compare-large-set-of-tables-between-two-databases/6676 "2011-06-27T08:24:42Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![AmyM](https://avatars.discourse-cdn.com/v4/letter/a/e9bcb4/32.png) [@AmyM](https://forums.toadworld.com/u/AmyM)\
**Post date:** [June 27, 2011, 8:24am UTC](https://forums.toadworld.com/t/compare-large-set-of-tables-between-two-databases/6676/1 "2011-06-27T08:24:42Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\
**Post date:** [June 27, 2011, 12:05pm UTC](https://forums.toadworld.com/t/compare-large-set-of-tables-between-two-databases/6676/2 "2011-06-27T12:05:13Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![AmyM](https://avatars.discourse-cdn.com/v4/letter/a/e9bcb4/32.png) [@AmyM](https://forums.toadworld.com/u/AmyM)\
**Post date:** [June 27, 2011, 12:12pm UTC](https://forums.toadworld.com/t/compare-large-set-of-tables-between-two-databases/6676/3 "2011-06-27T12:12:24Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\
**Post date:** [June 27, 2011, 12:44pm UTC](https://forums.toadworld.com/t/compare-large-set-of-tables-between-two-databases/6676/4 "2011-06-27T12:44:03Z")

</div>

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](https://global.discourse-cdn.com/quest/original/2X/5/5634745d32b46e1ae1c7c9e9f1e55b4f96938f0f.png)