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.