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 Website | Products | Purchase | Support | Community | About Us | Resources | Legal |
---|