Compare results of two SQL statements

Compare results of two SQL statements

Postby 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
Judith
 
Posts: 5
Joined: Tue 08 Sep 2015 18:00

Re: Compare results of two SQL statements

Postby 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/datacompare/docs/index.html?how_to_set_comparison_key.htm
http://www.devart.com/dbforge/oracle/datacompare/docs/index.html?how_to_map_columns.htm
alexa
Devart Team
 
Posts: 2175
Joined: Fri 24 Jun 2011 14:17


Return to dbForge for Oracle