This report compares the current metadata repository to a remote repository.

Objects Included

All object types are included in this report.

Parameters

This report requires connection information for the remote repository to be entered. Specifically:

• ODBC Connect (the ODBC source for the other repository)
• User Name (user name for the remote repository)
• Password (password for the remote repository)
• Meta Repository (database/user the remote repository metadata is stored in)

Four additional parameters can be specified:

• Optional filter on Local Groups
• Optional filter on Local Projects
• Do detail report
• Only validate procedures that have been modified

Results

The results of this report are displayed as a list of differences with the following columns:

• Object Name
• Comments (Summary difference between current and selected repository)
• Local
• Remote

The result set is sortable by clicking the appropriate column heading.

Report Example 

Checking result details

• Right-click the object name with validation errors.
• Select Detail.
• This will rerun the report just for the selected object and will display more details about the errors in the Comments, Local, and/or Remote Column(s).

Sending Results to Microsoft Excel

• Right-click the result set and click Output to File to send the results of this report to Microsoft Excel.