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>