Toad World® Forums

Change of Compare connection resets comparisons

This issue is similar to, but different than, the issue in

I’m running TDP (64 bit). No matter what Data Compare connections I have, attempting to change the connection results in losing the comparison information. Rebuilding these comparisons takes about a half hour - I have over 200 tables to compare from a 400-table schema.

My comparisons are primarily between Oracle 12 and Postgres 9.5; comparing Oracle to Oracle or Postgres to Postgres (just changing the connection, not the technology) produces the same loss of function. Attempts to hack my way through by editing the XML of the .DCP file have not worked, either.

Please advise.

Thanks for your help!


if I understand right you just need to change your connection and run compare with same pair info. You are right that when you change connection we have to reload all objects and relations so you have to map your tables from scratch. And this is your main problem because you have so many tables which have to be mapped all the time. Is it correct understanding?

Unfortunately only easy way how to change connection is by editing XML file. Specification of connections are in these two elements: SourceConnectionMediator and TargetConnectionMediator.

CurrentDB attribute say what Schema you want to use.

Then there are Connection and ExtraParameter elements.

  • ExtraParameter is usually empty - usually used for backward compatibility or additional encryption of your password.
  • Connection specify your connection info. I don’t recommend you editing this info manually. Instead of this you can export your needed connection from your Connection Manager. Connection manager can export your connection(s) directly to XML. Then you can edit this file and you can find your needed connection. Just copy - paste your Connection element.
    If you want to use it as a part of your automation script you have to play with it little bit more. Separate your connections to file and then you can use Find-Replace activity.

I didn’t test it with Oracle - Postgres combination but I hope it should be enough. If it doesn’t help then let me know and I will try test it once more on your specific combination.