Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

A where clause is an SQL expression that is used as a data filter. Only the records that meet the where clause criteria are compared and synchronized. You can specify any valid SQL expression as the where clause. The "where" keyword should not be included in the expression.

...

<TablePairs>
     <Pair>
          <LeftObject Name="dbo.employees"/>
          <RightObject Name="dbo.employees"/>
          <LeftWhereClause>emp_id != 3</LeftWhereClause>
          <RightWhereClause>emp_id != 4</RightWhereClause>
     </Pair>
</TablePairs>

 


Excerpt

Total compare from data to schema with IDERA SQL Comparison Toolset. Learn more > >