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.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center