xSQL Schema Compare for SQL Server > Comparing Databases > Entity Filters |
Entity filters allow you to exclude database objects based on some predefined criteria. 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:
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:
![]() |
For a more complex filter, that combines criteria with both OR and AND operators, create multiple groups. Place the OR-criteria in one group and the AND-criteria in another. |
Condition is the filter criteria that an object name or an object schema is checked against. If the object meets the filter criteria, it is excluded from the comparison. A condition can be applied on the name or on the schema of an object.