While the type-based selection excludes an entire class of objects, the name-based method allows you to exclude specific objects by name.

To exclude an object by name, use the <ObjectSelection> element of the xml config file and specify one or multiple <Object> elements with the following attributes:

The following xml fragment excludes the table employees and the view v_employees:

<ObjectSelection>
     <Object Schema="dbo" Name="employees" Type="Table" Include="false"/>
     <Object Schema="dbo" Name="v_employees" Type="View" Include="false"/>
</ObjectSelection>

The following list contains the object type that you can exclude:

In addition to these types, one macro-type is supported as well:

You can combine the macro-type None with the real types to achieve the desired results. For example, to include a table named employees and exclude all other objects, you could use following xml fragment:

<ObjectSelection>
     <Object Name="" Type="None" />
     <Object Schema="dbo" Name="employees" Type="Table" Include="true"/>
</ObjectSelection>

Level-two objects, such as columns, constraints, indexes, triggers, statistics, extended properties, permissions can't be excluded directly. These objects are excluded when the parent object is excluded.

 

 

Total compare from data to schema with IDERA SQL Comparison Toolset. Learn more > >

IDERA WebsiteProductsPurchaseSupportCommunityAbout UsResources Legal