Compare MS SQL Server 7 Environments Report

Use the Compare MS SQL Server 7 Environments report to compare the data model of two SQL Server Version 7 databases. The report can compare tables, views, procedures, and triggers. You can specify a unique filter for each category. Users can either view all the objects in the category along with their associated attributes, or view only the objects and attributes that differ. To run the report, you must define an environment or application code for each PPM database schema.

To run the Compare MS SQL Server 7 Environments report, you must have a Deployment Management license.

Table 4-3. Compare MS SQL Server 7 Environments 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, the first environment, from the environments available on your PPM instance.
*Compared Environment	Select the second environment from the environments available on your PPM instance.
Reference AppCode	Select an application code to be used to override the parameters for the reference environment from the application codes available on your PPM instance.
Compared AppCode	Select an application code to be used to override the parameters for the compared environment from the application codes available on your PPM instance.
Only Report Differences	Option to show only the differences between the two environments.
Compare Tables	Option to compare tables.
Table Filter	Specify a table. Type any alphanumeric string (up to 200 characters in length).
Compare Views	Option to compare views.
View Filter	Specify a view. Type any alphanumeric string (up to 200 characters in length).
Compare Procedures	Option to compare procedures.
Procedure Filter	Specify a procedure. Type any alphanumeric string (up to 200 characters in length).
Compare Triggers	Option to compare triggers.
Trigger Filter	Specify a trigger. Type any alphanumeric string (up to 200 characters in length).