Validating workspaces against the cross-reference database

Before loading source data into a geodatabase using a cross-reference database, you may need to ensure the data contains the same datasets and fields as the target geodatabase. The Preload Validate tool can be used to compare the source and target workspaces against the cross-reference database to ensure they are compatible. Initially, the schemas of the source and target workspaces are compared to the cross-reference database to ensure the datasets and fields match. The Preload Validate tool compares the source and target to the cross-reference database based on the names of the datasets and fields. Any discrepancies are reported in a log file.

The source workspace is compared to the cross-reference database first. The datasets that are not included in the cross-reference database are reported in the log file, as are the fields. The same process is then repeated using the target workspace.

The log file reports any datasets and fields that are not in the source or target workspace but are present in the cross-reference database. It also lists the paths to the cross-reference database, source workspace, and target workspace.

Example of a log file generated by the Preload Validate tool

Steps:

1. Start ArcCatalog.
2. On the main menu, click Customize > Toolbars > Production Mapping.
3. Click the Preload Validate button on the Production Mapping toolbar.

   The Preload Validate dialog box appears.

4. Click the ellipsis button (…) next to the Source Workspace text box.

   The Select source workspace dialog box appears.

5. Browse to the workspace that contains the source schema.
6. Click Select.

   The Preload Validate dialog box appears.

7. Click the ellipsis button next to the Target Geodatabase text box.

   The Select target geodatabase dialog box appears.

8. Browse to the workspace that contains the target schema.
9. Click Select.

   The Preload Validate dialog box appears.

10. Click the ellipsis button next to the Cross-reference Database text box.

    The Select cross-reference database dialog box appears.

11. Browse to the cross-reference database you want to compare to the source and target workspaces.
12. Click Add.

    The Preload Validate dialog box appears.

13. Click the ellipsis button next to the Log File text box.

    The Specify log file dialog box appears.

14. Browse to the directory in which you want to save the log file.
15. Type a name for the log file in the Name text box.
16. Click Save.

    The Preload Validate dialog box appears.

17. Click OK.

    The source and target workspaces are compared to the cross-reference database, and any differences are reported in a log file. Once the validation process is complete, a message appears asking if you want to see the log file.

18. Click Yes to view the log file or No to close the message.

    If you click Yes, the log file opens in a text editor. If you click No, the Preload Validate dialog box appears.

19. Click Cancel to close the Preload Validate dialog box.