Data Mover

PeopleSoft Data Mover enables you to:
·         Transfer application data between PeopleSoft databases.
·         Move PeopleSoft databases across operating systems and database platforms.
·         Execute Structured Query Language (SQL) statements against any PeopleSoft database, regardless of the underlying operating system or database platform.
Most Used DMS Scripts:
--DMS for exporting a record.
set log D:\DataMover-Scripts\ ORG_JOB _EXPORT.log;
set output D:\DataMover-Scripts\ ORG_JOB.dat;
export ORG_JOB_TBL;

--DMS for importing a record.
set log D:\DataMover-Scripts\ORG_JOB_IMPORT.log;
set input  D:\DataMover-Scripts\ ORG_JOB.dat;
import  ORG_JOB_TBL;