By default, dbForge Fusion 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.
Open the Data Comparison wizard and specify Source and Target. Click Next.
On the Mapping wizard page, select a required object in the grid and click the Filter button. The** WHERE Filter** dialog box opens. It is divided into the 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.
Right-click either Source or Target section and select Insert Column and a required column on the shortcut menu. Type a filter expression.
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.
To apply the filtering expression, click OK. The filtered object will be marked with the ? icon in the Mapping wizard page grid.