Page History
...
The following xml fragment defines a where clauses on the employees table that excludes records with emp_id = 3. The where clause is set for both the left and the right databaseschema:
<TablePairs>
<Pair>
<LeftObject Name="dboHR.employeesEMPLOYEES"/>
<RightObject Name="dboHR_COPY.employeesEMPLOYEES"/>
<WhereClause>emp<WhereClause>EMPLOYEE_id ID != 3</WhereClause>
</Pair>
</TablePairs>
The following xml fragment defines separate where clauses on the employees table for the left and the right databaseschema. On the left databaseschema, it excludes records with empEMPLOYEE_id ID = 3; on the right databaseschema, it excludes records with empEMPLOYEE_id ID = 4.
<TablePairs>
<Pair>
<LeftObject Name="dboHR.employeesEMPLOYEES"/>
<RightObject Name="dboHR_COPY.employeesEMPLOYEES"/>
<LeftWhereClause>emp<LeftWhereClause>EMPLOYEE_id ID != 3</LeftWhereClause>
<RightWhereClause>emp<RightWhereClause>EMPLOYEE_id ID != 4</RightWhereClause>
</Pair>
</TablePairs>
...