xSQL Comparison Bundle for SQL Server
Excluding objects by name

The "Excluded Objects" step allows you to exclude various database objects by name.

The following fragment is the xml generated when a few objects have been excluded from the comparison by name:

  <ObjectSelection>
    <Object Type="Table" Schema="HumanResources" Name="Employee" Include="false" />
    <Object Type="Table" Schema="HumanResources" Name="EmployeeAddress" Include="false" />
    <Object Type="Table" Schema="HumanResources" Name="EmployeeDepartmentHistory" Include="false" />
    <Object Type="Table" Schema="Sales" Name="SalesOrderHeader" Include="false" />
    <Object Type="Table" Schema="Sales" Name="SalesOrderDetail" Include="false" />
    <Object Type="View" Schema="Sales" Name="vSalesPerson" Include="false" />
    <Object Type="View" Schema="Sales" Name="vIndividualCustomer" Include="false" />
    <Object Type="StoredProcedure" Schema="dbo" Name="uspPrintError" Include="false" />
    <Object Type="StoredProcedure" Schema="dbo" Name="uspLogError" Include="false" />
  </ObjectSelection>


 

 


Copyright © 2022 xSQL Software - All rights reserved.