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.