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