Peoplesoft Data Mover:

Data Mover is an administrative tool used by DBA’s. It is used for many purpose as mentioned:

• It is used to move data from one database to another.
• With Data mover we can create scripts not objects.
• To install PeopleSoft database we require Data Mover.
• using Data Mover we can take backup of data.
• We can rename record’s and field’s
• We can encrypt the password field that exists in PSOPRDEFN record.
• We can grant access to user’s using grant command.

DATA MOVER

Data Mover can be login in two modes:

1. Normal Mode
2. Bootstrap Mode

1. Normal Mode :- In normal mode we can login with the peoplesoft userid and password. In short the PIA userid and password. e.g. Default PS/PS

2. Bootstrap Mode :- In Bootstrap mode we login with database access id and ssword e.g. sa / sa for SQL server and SYSADM / SYSADM for oracle by default.

Data Mover Commands:

• IMPORT
• EXPORT
• REPLACE_ALL
• REPLACE_DATA
• RENAME
• ENCRYPT_PASSWORD
• GRANT
• SET

Data Mover command one example:

• IMPORT

SET LOG D:\IMPORT.LOG

SET INPUT D:\IMPORT.DAT

IMPORT *

IMPORT PSOPRDEFN