Category Archives: DMS

MVPRDEXP.DMS is your friend…

In the scripts directory of your PS_HOME you will find core tables for many PeopleTools objects. Use it as a reference.

MVPRDEXP.DMS

Example…

— PORTAL REGISTRY USER FAVORITES
EXPORT PSPRUFDEFN;

— PORTAL USER REGISTRY HOMEPAGE
EXPORT PSPRUHDEFN;
EXPORT PSPRUHTAB;
EXPORT PSPRUHTABPGLT;

PeopleSoft definitions that will NOT copy to a file…

There are two PeopleSoft definitions that will NOT copy to a file…
Message Catalog Entries
Roles

If you cant copy from database to database then you need to write a DMS script to move these…

--ROLES
EXPORT PSROLEDEFN;
EXPORT PSROLEDEFNLANG;
EXPORT PSROLECANGRANT;
EXPORT PSROLECLASS;

-- MESSAGES
EXPORT PSMSGSETDEFN;
EXPORT PSMSGSETLANG;
EXPORT PSMSGCATDEFN;
EXPORT PSMSGCATLANG;