How to Compare Two Definer Repositories

Previous Next

See Also


Before comparing two Definer repositories, you have to determine the Source and the Target repository version, and make sure they are defined as repository versions.

To compare two Definer repositories:

1. From the menu, select Define, Comparisons [CTRL+X], or click the button with the XML icon in the toolbar.

The Comparisons window opens.


You can also click the Configure tab of the catalog, and double-click Definer Comparisons.

2. Enter a Name for the comparison.


The name of a Comparison cannot contain any of the following characters: \ / : * ? " < >

3. Select the Source and Target repository version from the dropdown list
4. Specify whether these repositories are already exported to XML (the default setting), or in the Database and should first be exported as part of the compare process.
5. Optionally, select a Basket from the dropdown list.

This exports and compares the part of the repository that is defined in the repository basket. See: How to Define a Repository Basket.


If you use a basket, you cannot use the Sections tab page.

6. If you do NOT use a basket, select the sections of the Definer to be exported and compared on the Sections tab page.

You can use the Select All and Clear All buttons for your convenience.

7. Optionally, set or change several comparison settings on the Settings tab page:
· From the Change Type dropdown list, select whether All changes are reported (default), or Inserts, Deletes, or Updates only.
· Select the Show OLD Values checkbox to specify that in the case of Updated records, the OLD (source) values are reported in the Comparison.
· By default, OLD values are not reported.
· Specify a By User value to report only the changes made by a specific user.


For this purpose, Definer columns with the following names are compared:


· Select the USoft Import XML checkbox to generate an XML document that can be used to change the SOURCE into the TARGET repository.
· These manipulations can then be executed in the Definer of the Source repository.


Executing these manipulations is at your own risk.


Currently, inserts in the ESI (external) repository are not generated in the Import XML document.


· Select the PDF Differences checkbox to generate a difference report in PDF format.
8. Save your changes.


The Type field in the Comparisons window is set to a value characterizing the comparison, depending on the XML and Database radio button settings:


· Offline XML Analysis (Source XML, Target XML).
· Export and Compare (Source Database, Target Database).
· Track Changes (Source XML, Target Database).
· Synchronize and Import (Source Database, Target XML).
9. Click the Compare button to compare the two Definer repositories.


For each of the two repositories that first have to be exported (are set to Database), an information message is shown that the repository will be exported.


· A DOS command box is opened, and a USoft Definer is opened for the specified account. In this Definer, the repository is exported.


Depending on the size of the repository, this may take a while.

Once the export is finished, the DOS command box and the USoft Definer window are closed.


If you did NOT use a basket, exported repositories have name:

<Repositories folder>\<Repository Version Code>.xml

If you DID use a basket, exported repositories have name:

<Basket Exports folder>\<Repository Version Code>_<basket name>.xml

· In the Repository Manager, this message appears.

Source Repository Exported.


Target Repository Exported.


Only acknowledge this message AFTER the DOS command box and the USoft Definer window are closed.

Then, the comparison is made, resulting in information message:

XML Difference Report generated.

Finally, if you selected the PDF Differences checkbox, the information message appears:

PDF Difference Report generated.

At the top of the Comparisons window, the current date and time are filled.