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.