I am trying to find out if I can compare all schemas between two databases at the same time and if it does, how do you do it? I read that Toad has come out with this recently where you can add multiple target schemas to compare. Can someone please tell me the steps to do this.
All schemas: no.
Multiple schemas: Open the schema compare screen. Click “add” to add
a target schema. Repeat as needed.
If you have the dba module, you can use the compare database screen to compare
all the users (just the users, not the objects they contain) between two
databases.
-John