Command line allows you to exclude specific columns from data compare.
Rules for excluding columns are as follows:
- Excluded columns should be listed under the xml element
<ColumnPair>
of the<Columns>
element - The attribute Action of the
<Columns>
element should be set to Exclude
The following xml fragment excludes the columns FIRST_NAME
, LAST_NAME
from the table HR.EMPLOYEES
and the column ADDRESS
from the table HR.CUSTOMERS
:
<TablePairs>
<Pair>
<LeftObject Name="HR.EMPLOYEES"></LeftObject>
<RightObject Name="HR_COPY.EMPLOYEES"></RightObject>
<Columns Action="Exclude">
<ColumnPair>
<LeftColumn>FIRST_NAME</LeftColumn>
<RightColumn>FIRST_NAME</RightColumn>
</ColumnPair>
<ColumnPair>
<LeftColumn>LAST_NAME</LeftColumn>
<RightColumn>LAST_NAME</RightColumn>
</ColumnPair>
</Columns>
</Pair>
<Pair>
<LeftObject Name="HR.CUSTOMERS"></LeftObject>
<RightObject Name="HR_COPY.CUSTOMERS"></RightObject>
<Columns Action="Exclude">
<ColumnPair>
<LeftColumn>ADDRESS</LeftColumn>
<RightColumn>ADDRESS</RightColumn>
</ColumnPair>
</Columns>
</Pair>
</TablePairs>