# Detect differences in databases

This window is displayed by clicking on the Detect differences button on the Differences between databases option.

This form is modal. You must close it before you can access other forms or the menu

1. Select the remote database to compare. The data files from that remote site should be copied to a subdirectory called Data under the site database , eg C:\IDW\RIGA\DATA

2. Select the tables to compare from the lest lists and move them to the right list. (see dual lists in the user guide). Often a single click on the [>>] key is all that is required if all tables are to be compared.

3. Click OK to process.

4. The progress bar will c\display the operation occurring and its progress

5. The program processes each table check first for records in the remote that aren’t in the master, then vice versa and then where the two are different. As each table is processed the number of differences detected is written in the right list.

The actual records will now be added to the difference table.

Document DetectDiff.htm