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 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>


| | | | |