Page History

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>