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).