Page Comparison

...

1. Internals

2. Customizations

3. Database

4. Datamover

Notes: DataMover Scripts(.dms)

Data Mover is the best way to export and import data between PeopleSoft databases.

PeopleSoft Data Mover requires two files to be available on the target before execution:

• Control file (which ends with a .dms extension)

• Data file (could be any file CSV, db, DAT)

Sample EXPORT script is

-- REF0001 DD/MM/YYYY Author
-- Brief explanation of what is being exported
 
SET LOG C:\REF0001_EXPORT.log;
SET OUTPUT C:\REF0001.dat;
 
EXPORT TABLE_NAME;

sample IMPORT script is

-- REF0001 DD/MM/YYYY Author
-- Brief explanation of what is being exported
 
SET LOG C:\REF0001_EXPORT.log;
SET INPUT C:\REF0001.dat;
 
IMPORT TABLE_NAME;

If a package contains both EXPORT and IMPORT scripts,

During the packageBuild operation, the DMS EXPORT scripts are executed, generating an output DAT file.

This generated output is then saved to the artifact along with the EXPORT and IMPORT scripts.

During the packageDeploy operation, the IMPORT scripts read the input DAT file from the artifact (generated by the build operation) and execute the IMPORT scripts.