How To Compare Objects In Two Databases

The above sections provided background information about comparing objects in two environments; the following section reiterates this information in step-by-step instructions:

Note: Remember, you always execute the comparison background process from the "target" environment (i.e., the one that will be changed)

Make sure that an environment reference exists in the "target" database pointing at the source database. This environment reference must be defined as either a Compare Source or a ConfigLab.
Create a batch control for the DB process (if one doesn't already exist).
Create a DB process to define the maintenance objects to be compared. Make sure to reference the batch control created in the previous step. Also inspect the DB process instructions to make sure they are consistent with what you want to compare.
Submit the DB process's batch control.

Note: Time saver. The batch control's context menu has an entry that transfers you to the batch submission page. It also contains an entry that transfers you to the Difference Query (after the batch job completes).

After the comparison batch process completes, transfer to the Difference Query to view the results of the comparison.
- Approve all changes using the Difference Query.
- Reject all changes that you don't want applied.
After the changes are marked as desired, submit the apply changes background process ( CL-APPCH ). After this process completes, return to the Difference Query to check that all of your approved changes have become complete (this means that the target database has been changed).

Note: Time saver. A simple business process script in the demonstration database can be used to submit the apply changes background process from the Difference Query. It's called CI_APPCH.