xSQL Comparison Bundle for SQL Server
Excluding tables

The "Excluded Tables" step allows you to exclude database tables by name.

The following fragment is the xml generated when some tables have been excluded by name:

  <TablePairs>
    <!--**** excluded tables ****-->
    <Pair Action="Exclude">
      <LeftObject Schema="HumanResources" Name="Employee" />
      <RightObject Schema="HumanResources" Name="Employee" />
    </Pair>
    <Pair Action="Exclude">
      <LeftObject Schema="HumanResources" Name="EmployeeAddress" />
      <RightObject Schema="HumanResources" Name="EmployeeAddress" />
    </Pair>
    <Pair Action="Exclude">
      <LeftObject Schema="Sales" Name="SalesOrderHeader" />
      <RightObject Schema="Sales" Name="SalesOrderHeader" />
    </Pair>
    <Pair Action="Exclude">
      <LeftObject Schema="Sales" Name="SalesOrderDetail" />
      <RightObject Schema="Sales" Name="SalesOrderDetail" />
    </Pair>
    <Pair Action="Exclude">
      <LeftObject Schema="Sales" Name="SalesPerson" />
      <RightObject Schema="Sales" Name="SalesPerson" />
    </Pair>
    <!--**** ********************** ****-->
  </TablePairs>


 

 


Copyright © 2022 xSQL Software - All rights reserved.