Compare results of two SQL statements

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
Judith
Posts: 5
Joined: Tue 08 Sep 2015 18:00

Compare results of two SQL statements

Post by Judith » Tue 08 Sep 2015 18:04

I am trialing dbForge for Oracle and am not clear on this point. Can I compare results of two SQL statements? They will be on different Oracle databases but will retrieve equivalent columns of data.

Can I save the statements so I can compare them again? Can I save the pair of statements and the parameter settings so I can run the whole test again?

Thanks for any help; I was not able to figure it out.

More info: I put in the two custom queries. I get a screen with a progress bar that doesn't seem to change. If I click "Compare", I get this message "Some objects are incorrectly mapped. They will be ignored during comparison. Do you want to continue?"

If I choose 'Yes', I get this: "No objects to compare". If I choose "No", I'm put back to the progress bar.

Later: I've gotten farther. I think I got it to work, with some confusion. At this point, if someone could list for me which parts of the Help contents are relevant, I would very much appreciate it.

Judith

alexa
Devart Team
Posts: 2430
Joined: Fri 24 Jun 2011 14:17

Re: Compare results of two SQL statements

Post by alexa » Wed 09 Sep 2015 11:22

To perform comparison, you have to specify key columns. For this, please perform the following:

1. On the 'Mapping' page, in the drop-down menu under the 'Comparison Key' column, select <Custom...>. The 'Column Mapping' dialog opens.
2. Select the 'Key' checkbox against the columns that will be used as a comparison key.

Please also see the following topics in the product's Help documentation:
http://www.devart.com/dbforge/oracle/da ... on_key.htm
http://www.devart.com/dbforge/oracle/da ... olumns.htm

Post Reply