xSQL Comparison Bundle for SQL Server
Excluding objects using entity filters

The "Entity Filters" step allows you to exclude database objects using filters. For more information on filters, see the topic 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_TMP</Expression>
        </Condition>
      </Group>
    </Filter>
    <Filter EntityType="StoredProcedure">
      <Condition>
        <ConditionType>Containing</ConditionType>
        <Expression>_DEV_</Expression>
      </Condition>
    </Filter>
  </EntityFilters>


 

 


Copyright © 2022 xSQL Software - All rights reserved.