Using Object Filter

The Object Filter feature allows filtering objects right in the Comparison Document. Applying advanced filters makes the analysis of schema comparison results more effective, informative, and bespoke. The feature also allows applying multiple filters and creating custom filters with Filter Editor which can be saved, and used for further comparisons.

Using the Object Filter:

To open the Object Filter click Object filter button in the Comparison results window.

You can use filters to define which objects are displayed in the Comparison results. To include or exclude objects, click to select or unselect a checkbox next to them.

The default filter is Nothing Excluded. If you edit this filter, Custom* is shown in the Filter box. An asterisk is displayed next to the name of any filter you edit, to show that there are unsaved changes.

You can save your filter for use in multiple projects. To save a filter click a diskette icon next to the Filter box. To choose a different filter, in the Filter box select the filter you want to use; if the filter is not listed, click the folder icon and browse to the filter. When you save an edited filter, you can either save it with the same name to overwrite it or change the name to create a new filter.

Note:

All unsaved changes to a Custom* filter will be lost when you select another filter.

If you modify an existing filter, make sure you have saved the changes before closing the tool.

To open a Filter Editor click the filter button next to the required object.

Filter Editor

Filter rules

With Filter Editor you can create rules to control the specific objects that a filter includes or excludes.

Filter Editor Rule

In the Filter rule for box, you can select individual object types or All object types, and edit the rules applying to those objects.

When you create a filter rule, its conditions can be selected from a drop-down list.

Add drop-down list

Conditions drop-down list

To add a new condition click plus icon. To remove a condition click cross icon correspondingly.

You can clear all current filter rules just by selecting the filter Nothing Excluded from the Filter box.

Filters and synchronization

The filter determines which objects will be displayed in the Comparison results window and which therefore can be selected for synchronization.

When you use a filter to exclude an object or object type, it is removed from the Comparison results and cannot be selected for synchronization.

If an excluded object is referenced by an object you selected for synchronization, you will be notified of this dependency, and can choose to synchronize the affected object on the Dependencies tab of the Schema Synchronization wizard.

A filter defines which objects are displayed in the Comparison results window. If an object matches the term in the Search box and is excluded by a filter, it is not displayed in the Comparison results.

Using filters from the command line

To use a filter from the command line, use the /filter switch and specify the path to filter you want to use. For example:

/filter:<filepath>