Comparing Definitions for Upgrade Using the Command Line
Use the same command line syntax as identified previously to compare definitions.
See Understanding PeopleSoft Application Designer Command Line Parameters.
Use the command line statement for an Upgrade Compare process to:
Connect to the source database.
Connect to the target database.
Perform a project or database compare (based on parameters).
Create compare reports in the specified output directory.
Example: Comparing to Database
Use this example as a guide for running an Upgrade Compare process:
Run a database Compare process against the source Microsoft SQL Server database, FSDMO, and the target database, PTTST.
Source database uses connect ID and password as defined in pscfg.
Log process and error messages to c:\temp\compare.log.
Set the commit limit to 150.
Show the audit flag and DDL differences between databases.
Compare records, indexes, pages, queries, and process definitions.
Compare only English and Spanish translations.
Set the database compare type.
Set the target orientation to keep the customizations.
Compare by release 8.52.00.000.
Generate compare reports to the c:\temp\upgreports directory.
Set target database server connect id to people.
Set target database server connect password to 123456.
PSIDE.EXE −HIDE -CT MICROSFT -CD FSDMO -CO PTDMO -CP password -PJM PPLTOOLS -TD PTTST -TO PTDMO -TP password -QUIET -LF C:\TEMP\COMPARE.LOG -CL 150 -AF 0 -DDL 0 -OBJ 0,1,5,10,20 -LNG ENG, ESP -CMT 0 -TGT 1 -CBY REL Core 8.52.00.000 -ROD C:\TEMP\UPGREPORTS -TI people -TW 123456
Example: Comparing from File
Use this example as a guide for running an Upgrade Compare From File process:
Run a Compare From File process on the T855805B database (target) against the file C:\PROJECTS\CUSTPRJ (source).
Project name is CUSTPRJ.
Log process and error messages to C:\TEMP\COMPARE.log.
Set the commit limit to 100.
Compare all definitions.
Compare all languages.
Set the database compare type.
Set the report filter.
Set the target orientation to PeopleSoft Vanilla.
Compare by release PeopleTools 8.54.00.000.
Generate PrintProject report.
Generate compare reports to the D:\Reports directory.
PSIDE.EXE -CT ORACLE -CS -CD T855805B -CO PTTRN -CP password -PJFC CUSTPRJ -FP C:\PROJECTS\ -LF C:\TEMP\COMPARE.log -CL 100 -AF 1 -OBJ All -LNG All -PPL 1 -CFD 1 -CFF 1 -FLTR 00000 00011 00011 01111 01111 -TGT 0 -CBY REL PeopleTools 8.54.00.000 -CMPRTPRJ 1 -ROD C:\Reports\ -HIDE -QUIET