When comparing two schemas between two databases, under Options tab | Misc. Options, when you select the option: 'Only Compare Object Names like' and then select the 'NOT Like' option, if you enter a constraint name in the field, and run the Schema Compare, the results don't filter out the requested constraint name.
If you try excluding table names in this field, the filtering works, but this does not work with constraints.
Steps to Replicate:
- Open Schema Compare | Options tab -> Misc. Options
- Select the option: Only Compare Object Names like...
- and then select NOT Like option.
- type in the name of a FK constraint, e.g.: fk_test%;
- Run schema compare
- In the results page, the FK is still listed.
WORKAROUND:
None.
STATUS:
Waiting for fix in a future release of Toad for Oracle
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center