You can exclude specific tables or views from data compare by listing them under the xml element <TablePairs>
or <ViewPairs>
.
Rules for excluding database objects are as follows:
The following xml fragment excludes the tables dbo.Employees and dbo.Customers from the comparison:
<TablePairs>
<Pair Action="Exclude">
<LeftObject Name="dbo.Employees"></LeftObject>
<RightObject Name="dbo.Employees"></RightObject>
</Pair>
<Pair Action="Exclude">
<LeftObject Name="dbo.Customers"></LeftObject>
<RightObject Name="dbo.Customers"></RightObject>
</Pair>
</TablePairs>
Total compare from data to schema with IDERA SQL Comparison Toolset. Learn more > > |
IDERA Website | Products | Purchase | Support | Community | About Us | Resources | Legal |
---|