Is there a way to compare environments?

bigoteetoe

Active Member
Is there a program/report that can compare objects between environments? We'd like to have a report that shows all the object differences in payroll objects between our PY and PD environments.

We are on E1 8.11 SP1 8.95H
 
Got some SQL for versions, I guess it could be adapted for PathCodes:

/* Versions in PD810 not in or newer than PY810 */

select t1.VRPID, t1.VRVERS, t1.vrjd from
COPY810.f983051 t1 LEFT OUTER JOIN COPD810.f983051 t2
on t1.vrpid = t2.vrpid and t1.vrvers = t2.vrvers
where (t2.vrpid is NULL or t1.vrvcd > t2.vrvcd)
and (t1.vrvrsavail = 'Y')

order by VRPID, VRVERS;
 
I think you also want to look at UDC differences between environments as well as central objects.
 
You'd also want to account for business function code stored on the deployment server. 'diff' and some light scripting could help here.
 
Back
Top