|
When you work with complex databases that may contain hundreds of tables,
procedures and other objects, it may be convenient to see only those of them
relevant to what you are currently doing. In AdeptSQL Diff, this can be
accomplished using schema filters. The
 button on the
schema view toolbar invokes a menu controlling the filtering.
|
Filter menu commands:
|
|
Clear filters |
Remove any filtering, display the whole schema
tree. |
|
Hide identical objects
|
Only those objects that differ in the primary and the
secondary databases are
displayed. |
|
Hide RIGHT-only objects |
You won't see the objects that are not present in the
primary (left-hand) database. Supposedly, the primary database may be your test
database containing only a subset of the schema in the secondary one and you are
not interested to see any objects outside this subset. |
| Hide LEFT-only objects |
Don't show schema objects which are only present in the left-hand database.
|
|
Hide changed objects
|
Usually you need to see the changed objects, but if you
wish to view left-only and right-only schema items, but not the changed
ones, you can do so by setting this filter.
|
|
Persistent filters
|
This menu item can be in either checked and un-checked state. If you check it, the current filter
settings will be saved when you exit the program and restored the next time you run the Diff. Otherwise,
the program starts with no filters set.
|
|
|
