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>


IDERAProductsPurchase | Support | Community | Resources | About Us | Legal
  • No labels