In 12.12, the legacy Schema Compare feature (Toad 12.10) has been combined with the Compare Multiple
Schemas feature (Toad 12.11) to produce a new Compare Multiple Schemas features. It can be launched from
Database | Compare | Schemas
The following is an excerpt from the Help (Chapter: Work with Database Objects | Compare Objects | Compare Schemas)
To compare multiple pairs of schemas between a source and target database
- Under Source, select Database.
- Under Source, select the source database under Connection, then select from the Schema dropdown.
- Under Target, select the target database under Connection.
(Optional) Under Target, use the Schema filter box to match the schemas to a particular pattern. For example, in the screenshot below, I could change the filter to “COMP%” to only compare the schemas that begin with the letters COMP.
- Select Match schema names automatically to have Toad automatically match the source and target schemas by name when you run the comparison. The match is shown in the lower half of the window. (Note: Built-in schemas like SYS, SYSTEM, ORDSYS, etc, are excluded. Look for “MultipleSchemasToIgnore” in the Toad.ini file if you want to edit the list of schemas that Toad will ignore).
- Deselect Match schema names automatically to choose the schemas to compare manually. Toad will display the schemas found in the Source and Target Connections, and it will check the ones it finds that exist in both schemas. You can change the Target schema if you want to match a source to a schema by a different name, and you can check/uncheck in the Include column to indicate which schema pairs to compare.
- Click Next.
- Select options from the Choose Options window.
- Click Compare to run the comparison.
A video that demonstrates the Schema Compare is available in ToadWorld.
