Data Mover Script

Data Mover is one of the best utility export and imports the data in PeopleSoft database.

Example Export Data Mover Script:

set log C:\Sample01_Export.log;
set output C:\Sample01.dat;
export TABLE_NAME;

Example Import Data Mover Script:

set log C:\Sample01_Import.log;
set input C:\Sample01.dat;
import *;

Note:
1.For best practice Type table name Instead of use import *
2.We can where clause statement after the export statement
3.We can export N number of tables though adding export statement
4.Use replace all to drop the table Index to avoid the unique constraints on import
5.Use replace_data for delete the existing data and replace the new data through import
6.For best practice must use the set log statement for validation of import / export
7.For best practice while specify the log input /output must use the C:\ drive