You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

The Entity Filters step allows you to exclude database objects using filters. for more information about filters, see 9.0 SQL Schema Compare Entity Filters.

The following xml fragment contains a set of filters for the database tables, views and procedures:

<EntityFilters>
<Filter EntityType="Table">
<Group ConditionOperator="Or">
<Condition>
<ConditionType>StartingWith</ConditionType>
<Expression>TEMP</Expression>
</Condition>
<Condition>
<ConditionType>StartingWith</ConditionType>
<Expression>TMP</Expression>
</Condition>
</Group>
</Filter>
<Filter EntityType="View">
<Group ConditionOperator="Or">
<Condition>
<ConditionType>StartingWith</ConditionType>
<Expression>V_TEMP</Expression>
</Condition>
<Condition>
<ConditionType>StartingWith</ConditionType>
<Expression>V_TEMP</Expression>
</Condition>
</Group>
</Filter>
<Filter EntityType="StoredProcedure">
<Condition>
<ConditionType>Containing</ConditionType>
<Expression>_DEV_</Expression>
</Condition>
</Filter>
</EntityFilters>



IDERA |  Products | Purchase | Support |  Community |  Resources |  About Us  | Legal
  • No labels