You can exclude specific tables or views from data compare by listing them under the xml element <TablePairs> or <ViewPairs>.
Rules for excluding database objects are as follows:
- The attribute Action of <Pair> element should be set to Exclude
- The left and right object must be both specified for each excluded pair
The following xml fragment excludes the tables HR.EMPLOYEES and HR_COPY.EMPLOYEES from the comparison:
<TablePairs>
<Pair Action="Exclude">
<LeftObject Name="HR.EMPLOYEES"></LeftObject>
<RightObject Name="HR_COPY.EMPLOYEES"></RightObject>
</Pair>
<Pair Action="Exclude">
<LeftObject Name="HR.EMPLOYEES"></LeftObject>
<RightObject Name="HR_COPY.EMPLOYEES"></RightObject>
</Pair>
</TablePairs>