Contents 

AdeptSQL Diff Reference
Getting started
Connecting to databases
Scanning available servers
Saving and opening comparisons
Running from command line
Working with the schema
Viewing schema differences
Comparing objects side-by-side
Dragging and dropping schema items
Using schema filters
Configuring schema options
Comparing table data
DataDiff overview
Data comparison options
Column configuration file
Special situations comparing data
Executing the SQL
SQL errors and warnings
Keyboard shortcuts
Editing commands and keyboard shortcuts
Using keyboard templates
Choosing debugger's key mapping
Using COM Automation interface
Automating schema comparison
Automating data comparison
Licensing and contact info
Registration of AdeptSQL Diff
Contact information
Version history (last updated for ver. 1.90 [Build 58])

AdeptSQL Diff Online Help

Prev Page Next Page

Using schema filters

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.

   
The CHM file was converted to HTML by chm2web software.