I am using Compare Schema (Database | Compare | Compare Schemas) and have set a specific object set to run compare on but even with the Object Set specified Toad is still comparing and bringing up info about other objects.
EX:
I only select TEST1 and TEST2 in the Object Set tab. Then I run the compare but the compare info returned not only shows TEST1 and TEST2, and also includes comparisons for other objects like packages and procedures.
When setting up the compare options please not that what is chosen in the Options tab | Object Types to Compare is also taken into account. Compare will compare all types chosen in this tab, and will only take into account the objects selected in the Object Set tab by limiting the objects compared for that particular type. The Object Set tab only asks as a subfilter to the types chosen in the Object Types to Compare tab.
Example:
In Options tab | Object Types to Compare you only choose to compare only tables and procedures types.
In the Object Set tab you specify to compare only TESTA and TESTB.
When you run the compare, the results will show comparisons based off of all procedures in the schema and comparisons of only the 2 tables specified tables, TESTA and TESTB.
Specifying an object set in the in the Object Set tab is specific to a type. If you specify TESTA and TESTB for table types, it will not limit the compare to any procedures that may also be called TESTA or TESTB. If you want to also limit the procedures you will need to specify the objects of the procedure type also.
The Load Objects icon (blue plus icon in the Object Set tab) will give you the option to append different objects to the object set list so you may need to load objects multiple times if you need to specify objects of different types.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy