Improve the comparison performance

The topic describes the ways to improve the performance of data comparison and synchronization in dbForge Studio. In some cases, the comparison process may take longer than expected. To optimize performance, consider the following options:

• Change the location of temporary files.
• Filter the comparison.
• Review comparison options.
• Schedule comparison and synchronization.

Change the location of temporary files

By default, dbForge Studio stores cache files in the Windows Temporary Folder. To optimize performance, you can change the cache location to a different folder or hard drive.

To change the cache location:

1. In the top menu, select Tools > Options.

2. Navigate to Data Comparison > General.

3. Under Cache Folder, select Custom Folder.

4. Specify the path to the folder where you want to store the cache files or click the ellipsis (…) to browse and select the required folder.

5. Click OK to save the changes.

Filter the comparison

By default, dbForge Studio compares all tables, columns, and rows, and temporarily stores any data differences between the sources on your computer.

To reduce the size of temporary files, apply filters to compare only the required data.

Filter tables and views

You can exclude all tables from the comparison while retaining the views.

To exclude tables, clear the checkbox for Compare tables on the Options page of the New Data Comparison wizard.

Filter columns

To improve the performance of your data comparison and synchronization, you can filter out specific columns.

1. Run the data comparison.

2. Navigate to the Mapping page of the New Data Comparison wizard.

3. In the Columns in Comparison column, click the ellipsis (…) for the required table to open the Column Mapping dialog.

4. Select the Comparison Key column for the required row.

5. To ignore differences between columns, in the Compare column, clear the checkboxes for the required columns.

6. To exclude columns from synchronization, clear the checkboxes for the required columns.

7. Click OK to save the changes.

Filter rows

You can exclude rows by applying a WHERE clause to the comparison.

Note

WHERE clauses cannot be used for the Backup or Scripts Folder data sources.

To filter rows:

1. Run the data comparison.

2. Navigate to the Mapping page of the New Data Comparison wizard.

3. Select the object to apply the filter to.

4. On the Mapping toolbar, click Filter.

5. In the WHERE Filter dialog, enter a valid Transact-SQL WHERE clause.

6. Click OK to save the changes.

Review comparison options

By default, dbForge Studio includes identical records in the comparison results and temporarily stores them during the comparison process.

To exclude identical records from the comparison, clear the checkbox for Identical records on the Options page of the New Data Comparison wizard.

Schedule comparison and synchronization

You can schedule or automate comparison and synchronization tasks using dbForge Studio and a task scheduler tool, allowing resource-intensive operations to run during off-peak hours.

First, create a script to compare and synchronize the data sources. Then, schedule the script execution using a task scheduler, such as Windows Task Scheduler.

To schedule the script execution using Task Scheduler:

1. Run Task Scheduler.

2. In the Actions pane, select Create Basic Task.

3. In the Create Basic Task Wizard, specify the task and optional description, then click Next.

4. On the Trigger page, select the trigger for the task, then click Next.

5. On the Action page, click Start a program.

6. Under Program/script, click Browse and specify the path to the .bat file containing comparison and synchronization settings.

7. On the Finish page, verify the task details, then click Finish.