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
Compare results of two SQL statements
Re: Compare results of two SQL statements
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
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