• the structure of two HFSQL data files.
• the data in two HFSQL data files.
• the common data files found in two different directories.

Comparing the structure of two HFSQL data files

1. On the "Tools" tab, in the "Database" group, click "WDHFDiff".
2. Click the "Compare 2 files" button.
3. Select the two data files to be compared.
4. If necessary, enter the passwords for the data files to be compared.
5. Click the "Compare the structure" button. The differences found are automatically listed:
   • differences in the WLanguage properties of the data files compared.
   • list of items present in the first data file, in the second data file and common to both data files.
   • differences in the WLanguage properties of the fields in the compared data files.

Comparing the data found in two HFSQL data files

1. On the "Tools" tab, in the "Database" group, click "WDHFDiff".
2. Compare the structure of the two data files. For more details, see the above paragraph.
3. Click the "Compare the data" button.
4. Select the type of comparison to perform:
   • comparison by record number. The records found in the data files will be compared according to their identifier.
   • comparison by unique key. Records in the data files will be compared according to the unique key(s) common to both data files.
     Note: In this type of comparison, crossed-out and/or deleted records will not be compared.
5. Select the items to compare.
   Reminder: Use the "All" button to select all available headings. The "None" button is used to deselect the selected items.
6. Click "OK". The differences found are automatically listed.
7. Double-click a difference to find out its characteristics.

1. On the "Tools" tab, in the "Database" group, click "WDHFDiff".
2. Click the "Compare 2 directories" button.
3. Select the two directories to compare.
4. Click the "Scan" button. The data files common to the two selected directories are automatically listed.
5. Select the data files to compare.
   Reminder: The "All" button selects all available data files. The "None" button deselects the selected data files.
6. Click the "Compare" button. The number of differences found in each data file is automatically displayed.
7. Double-click on a data file to see its differences:
   • differences in the WLanguage properties of the data files compared.
   • list of items present in the first data file, in the second data file and common to both data files.
   • differences in the WLanguage properties of the fields in the compared data files.
8. Click the "Compare the data" button to perform a comparison by record number on the data files. The differences found are automatically listed.
9. Double-click a difference to find out its characteristics.