Filtering Rows Included into Comparison

By default, Data Compare for SQL Server compares all the rows in the selected tables or views. If they contain a large amount of data, the comparison can take a lot of time and even result in running out of disk space. You can simply avoid such things by filtering the rows to compare specific ranges.

  1. Open the Data Comparison wizard and specify Source and Target. Click Next.

  2. On the Mapping wizard page, select a required object in the grid and click the Filter button. The WHERE Filter dialog opens. It is divided into Source section (on the left) and Target one (on the right). If you want to filter Source rows, use the left section. To filter Target rows, use the right section.

  3. Right-click either Source or Target section and select Insert Column and a required column from the right-click menu. Type a filter expression.

    WHERE filter

  4. If you want to apply the expression to both Source and Target rows, type the expression and select Use the same expression for source and target.

  5. To apply the filtering expression, click OK. The filtered object will be marked with
  6. the ? icon in the Mapping wizard page grid.