Page History

Entity filters are a new feature introduced in the version 4 of IDERA SQL Schema Compare. They allow you to include or exclude database objects based on some predefined criteria. Entity filters have replaced the schema filters supported by the previous versions of SQL Schema Compare. You can access the entity filters from the context menu of the comparison grid.

To learn more about entity filters, click on the following topics:

...

You could exclude, for example, tables whose name starts with TEST_, views ending with "_TEMP", procedures by name, function using regular expressions and more.

There are many ways to launch the entity filters:

• The Entity Filters button, in the Database Selection form, before starting the comparison.
• In the comparison form, the Entity Filter link located at the Ribbon
• In the comparison form, the Entity Filters from the context menu.

Schema Compare creates filters for specific object types, such as tables, views, procedures. A filter is set of criteria, combined with the OR/AND operator. If you wish to exclude, for example, all tables whose name starts with DEV_ or TEST_, you could create the following filter (notice the OR operator):

Table filter: name starting with "DEV_" OR name starting with "TEST_"

If you wish to exclude all views, except V_EMPLOYEES and V_JOBS, the filter would be as follows (notice the AND operator):

View filter: name != "V_EMPLOYEES" AND name != V_JOBS

You create an entity filter as follows:

1. Launch the Entity Filters from the Ribbon link, the Comparison Form context menu, or via the Entity Filters button in the database selection form.
2. Select the object type, for which the filter is intended, such as the Tables or Views.
3. Click on the (new...) link, and then create the filter criteria. Add as many criteria as you need.

To change the criteria operator from OR to AND or vice versa, simply click on one operator.

Image Added

...