Page History

Command line allows you to exclude specific columns from data compare. In order to exclude columns, you must identify the pair of entities that columns belong to.

Rules for excluding columns are as follows:

...

The following xml fragment excludes the columns DateCreated, CreatedBy FIRST_NAME, LAST_NAME from the table dboHR.Employees EMPLOYEES and the column Address ADDRESS from the table dboHR.CustomersCUSTOMERS:

<TablePairs>
     <Pair>
          <LeftObject Name="dboHR.EmployeesEMPLOYEES"></LeftObject>
          <RightObject Name="dboHR_COPY.EmployeesEMPLOYEES"></RightObject>
          <Columns Action="Exclude">
               <ColumnPair>
                    <LeftColumn>DateCreated<<LeftColumn>FIRST_NAME</LeftColumn>
                    <RightColumn>DateCreated<<RightColumn>FIRST_NAME</RightColumn>
               </ColumnPair>
               <ColumnPair>
                    <LeftColumn>CreatedBy<<LeftColumn>LAST_NAME</LeftColumn>
                    <RightColumn>CreatedBy<<RightColumn>LAST_NAME</RightColumn>
               </ColumnPair>
          </Columns>
     </Pair>
     <Pair>
          <LeftObject Name="dboHR.CustomersCUSTOMERS"></LeftObject>
          <RightObject Name="dboHR_COPY.CustomersCUSTOMERS"></RightObject>
          <Columns Action="Exclude">
               <ColumnPair>
               <LeftColumn>Address<<LeftColumn>ADDRESS</LeftColumn>
               <RightColumn>Address<<RightColumn>ADDRESS</RightColumn>
               </ColumnPair>
          </Columns>
     </Pair>
</TablePairs>

...