Date: Fri, 29 Mar 2024 09:59:20 +0000 (UTC) Message-ID: <1419558130.69875.1711706360985@ip-10-0-1-26.ec2.internal> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_69874_2118130213.1711706360981" ------=_Part_69874_2118130213.1711706360981 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
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&=
gt;
or <RightObject>
of the <Pair> element
The following xml fragment defines a custom key for the pair of table db= o.Employees:
<TablePairs>
<Pair>
<LeftObject Name=3D"d=
bo.Employees">
=
<Key Name=3D"Custom_Key">
=
<Column>EmployeeID</Column>
=
</Key>
</LeftObject>
<RightObject Name=3D"=
dbo.Employees">
=
<Key Name=3D"Custom_Key">
=
<Column>EmployeeID</Column>
=
</Key>
</RightObject>
</Pair>
</TablePairs>
Total compare from data to schema with IDERA SQL Comparison Toolset. Learn more > >=20