Use 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 the application of multiple filters and the creation of custom filters with Filter Editor, which can be saved and used for further comparisons.
Using the Object Filter:
To open the Object Filter, click 
on the Schema Comparison toolbar or press Ctrl+L.
You can use filters to define which objects are displayed in the Comparison results. To include or exclude objects, click to select or clear a checkbox next to them.
The default filter is Nothing Excluded. If you modify this filter, Custom* appears in the Filter box. An asterisk is displayed next to the name of any filter you edit, indicating unsaved changes.
To open a Filter Editor, click the filter button next to the required object.
Filter rules
With Filter Editor, you can create rules to control the specific objects that a filter includes or excludes.
In the Filter rule for box, you can select individual object types or All object types and edit the rules that apply to those objects.
When creating a filter rule, its conditions can be selected from a drop-down list.
Additionally, you can add a condition or a group by clicking Use the Insert or Add Key.
You can also select from a list of different conditions and properties when building a filter rule.
1. Operation describes what happens to a source object during schema synchronization. It can be one of the following: None, Drop, Create, or Update.
2. Source Object and Target Object refer to an object in either Source or Target for schema comparison and synchronization.
3. Status indicates the status of an object as a result of schema comparison. It can be one of the following: Equal, Different, Only in Source, Only in Target, Unknown, or Inconsistent.
To add a new condition, click the plus icon. To remove a condition, click the cross icon correspondingly.
You can clear all current filter rules just by selecting the filter Nothing Excluded from the Filter box.
Saving filters
You can save your filter and later use it across multiple projects. To save a filter, click a diskette icon next to the Filter box and type the name of the filter.
Saved filters have the .scflt file extension. 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 filters saved earlier. Select a filter from the list of existing filters.
When saving an edited filter, you have the option to either save it with the same name to overwrite the existing filter, 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.
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 that you selected for synchronization, you will be notified of this dependency, and you can choose to synchronize the affected object on the Dependencies page of the Schema Synchronization wizard.
Filters and Search
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 shown in the results.
Using filters from the command line
To apply a filter from the command line, use the /filter switch and specify the path to the filter you want to use. For example:
C:\Program Files\Devart\dbForge Schema Compare for MySQL/schemacompare.com /schemacompare /compfile:"D:\workDir\dev-test-comparison.scomp" /filter:"D:\Custom Filters\Table-filter.scflt"
Want to Find out More?
Overview
Request a demo
