PeopleSoft : DMS Scripts

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;