Share this page

# Compare Custom Database Setup Report

The Compare Custom Database report compares database objects in separate database schemas. Objects to be compared are defined in the tables KENV_OBJECTS and KENV_OBJECT_ATTRIBUTES. These tables include predefined objects that compare two separate PPM entities across two PPM schemas:

- Commands (also called special commands)

- Object types

- Request header types

- Request types

- Security groups

- User data

- Validations

- Workflows

- Workflow step sources (in the execution and decision categories)

Custom comparison entities enable the comparison of actual data within a database, as well as within the data model. Custom entities can be generated for both Oracle and SQL Server.

You can apply a filter to each of the entities. You can view all the entities in the category along with their associated attributes, or view only the entities and attributes that contain differences. To run the Compare Custom Database report, you must define an environment or application code for each schema. In addition, you must have a Deployment Management license.

Table 4-1. Compare Custom Database Setup report field descriptions
Field Name (*Required) | Description
--- | ---
Comparison Name | Type a unique name for the report (200 characters maximum).
*Reference Environment | Select a reference environment from the environments available on your PPM instance.
*Compared Environment | Select an environment available on your PPM instance to compare to the reference environment you selected.
Reference AppCode | Select an application code available on your PPM instance to be used to override the parameters for the reference environment.
Compared AppCode | From the application codes available on your PPM instance, select one to be used to override the parameters for the compared environment.
Only Report Differences | Option to display only the differences between the two environments.
*Object 1 Object 2–5 | Select the custom SQL Server or Oracle objects from those objects available on your PPM instance.
Object 1–5 Filter | Type the values for the selected objects (200 characters maximum).

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: