# Multiple Object Compare?

**URL:** <https://forums.toadworld.com/t/multiple-object-compare/9462>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [April 28, 2010, 9:08pm UTC](https://forums.toadworld.com/t/multiple-object-compare/9462 "2010-04-28T21:08:23Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![RSquires](https://avatars.discourse-cdn.com/v4/letter/r/71c47a/32.png) [@RSquires](https://forums.toadworld.com/u/RSquires)\
**Post date:** [April 28, 2010, 9:08pm UTC](https://forums.toadworld.com/t/multiple-object-compare/9462/1 "2010-04-28T21:08:23Z")

</div>

I know we have Single Object Compare, but is there a way of comparing multiple objects at once - or automating the comparisons so I can just provide a list?

My current requirement is that I need to compare about 30 tables in two different databases with slight differences in the names. Something like:

MY\_REAL\_TABLE@DB1 with MY\_FAKE\_TABLE@DB2  
MY\_OTHER\_REAL\_TABLE@DB1 with MY\_OTHER\_FAKE\_TABLE@DB2

Is there a way of doing this in TOAD? Something like the Data Compare in Toad For Data Analysts that allows me to save my comparison set as well.

Cheers

Richard

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [April 29, 2010, 8:21am UTC](https://forums.toadworld.com/t/multiple-object-compare/9462/2 "2010-04-29T08:21:30Z")

</div>

There is no way of doing that now, but if others like the idea, I can put it on  
the to-do list.

---

<div class="post-metadata">

**Author:** ![RayPaschke](https://avatars.discourse-cdn.com/v4/letter/r/b487fb/32.png) [@RayPaschke](https://forums.toadworld.com/u/RayPaschke)\
**Post date:** [April 29, 2010, 8:36am UTC](https://forums.toadworld.com/t/multiple-object-compare/9462/3 "2010-04-29T08:36:09Z")

</div>

> > if others like the idea, I can put it on the to-do list.  
> > Please, do.

---

<div class="post-metadata">

**Author:** ![MGainty](https://avatars.discourse-cdn.com/v4/letter/m/a5b964/32.png) [@MGainty](https://forums.toadworld.com/u/MGainty)\
**Post date:** [April 29, 2010, 12:45pm UTC](https://forums.toadworld.com/t/multiple-object-compare/9462/4 "2010-04-29T12:45:00Z")

</div>

you can export them both and do a diff…  
ableit …not a very elegant solution (and somewhat painful)

other solutions?  
Martin Gainty

* * *

Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité

Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger  
sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung  
oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem  
Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung.  
Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung  
fuer den Inhalt uebernehmen.

Ce message est confidentiel et peut être privilégié. Si vous n’êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l’expéditeur. N’importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l’information seulement et n’aura pas n’importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni.

---

<div class="post-metadata">

**Author:** ![damir.vadas\_250](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/damir.vadas_250/32/37_2.png) [@damir.vadas\_250](https://forums.toadworld.com/u/damir.vadas_250)\
**Post date:** [August 23, 2017, 4:13am UTC](https://forums.toadworld.com/t/multiple-object-compare/9462/5 "2017-08-23T04:13:07Z")

</div>

Why can’t we compare list of objects that are retrieved by simple sql (i.e. SELECT ‘OBJ1’, ‘OBJ2’… from DUAL) and use it for source compare and then on the other side same names or even better as a list as well, where obey corresponding number in the list (i.e. from source nr correspondent to nr 5 on destination list)-for fully customized version.  
Of course this would only define names while other part (obj type) should remain the same.

Brg

Damir