How to filter rows included into comparison

By default, Studio 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.

Download dbForge Studio for SQL Server and try it absolutely free for 30 days!

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Studio for SQL Server.
All Features

All features

Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo

Request a demo

If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for SQL Server?