You can specify a custom key when the table or view has no built-in key or when the existing key is not suitable for data compare.
The following rules apply to custom keys:
<LeftObject>
or <RightObject>
of the <Pair>
elementThe following xml fragment defines a custom key for the pair of table HR.EMPLOYEES:
<TablePairs>
<Pair>
<LeftObject Name="HR.EMPLOYEES">
<Key Name="Custom_Key">
<Column>EMPLOYEE_ID</Column>
</Key>
</LeftObject>
<RightObject Name="HR_COPY.EMPLOYEES">
<Key Name="Custom_Key">
<Column>EMPLOYEE_ID</Column>
</Key>
</RightObject>
</Pair>
</TablePairs>
Total compare from data to schema with IDERA Comparison Toolset. Learn more > >
|