Comparing Project Data

There are a number of scenarios where database managers might want to compare project data -- the data that are stored and manipulated by the ARCHIBUS modules. Some examples are:

• Check to make sure that a Transfer In function completed successfully.
• Look for differences in reference data between projects.
• Look for discrepancies in data that should be the same between projects.

The Perform Comparison Only option of the Database Update Wizard compares data in exported .csv files to the contents of the database and lists an overview data about what is different about the tables of the two projects; that is, list the number of records, new records, deleted records, and the changed records).

To compare project data:

1. Log into a Project A.
2. Run the Database Update Wizard as follows to create the export .csv files for the data you want to compare.
   • Transfer Type = Transfer Out
   • Specify Tables = Project Data (caution: this is a lot of data) or specify named tables.
   • Select "Start Transfer"
3. Log off of Project A.
4. Log into Project B.
5. Run the Database Update Wizard as follows:
   • Transfer Type=Perform Comparison Only
   • Specify Tables = use the same specification as when you exported the data from Project A
   • Select "Start Compare"

See Also

Comparing Data: Overview