Customizing tables

The "Table Settings" step allows you to customize various table settings. You can change all or some of the following settings:

The key that should be used to compare the data between tables. This is useful when a table has no primary key or other unique indexes in SQL Server.
A where clause that should be used to filter the table data.
Columns that should be excluded from the comparison.

The following fragment is the xml generated when some table settings have changed:

<TablePairs>
    
    
    <Pair Action="Include">
      <LeftObject Schema="HumanResources" Name="Employee">
        <Key Name="af0abe6d-ff56-4b7b-94a8-1a794c51bf00">
          <Column>EmployeeID</Column>
        </Key>
      </LeftObject>
      <RightObject Schema="HumanResources" Name="Employee">
        <Key Name="61745db7-7eaf-4693-b68b-fc4c3637290e">
          <Column>EmployeeID</Column>
        </Key>
      </RightObject>
      <Columns Action="Exclude">
        <ColumnPair>
          <LeftColumn>rowguid</LeftColumn>
          <RightColumn>rowguid</RightColumn>
        </ColumnPair>
        <ColumnPair>
          <LeftColumn>ModifiedDate</LeftColumn>
          <RightColumn>ModifiedDate</RightColumn>
        </ColumnPair>
      </Columns>
      <WhereClause>EmployeeID &gt; 200</WhereClause>
    </Pair>
    
</TablePairs>