PeopleSoft Data Mover Overview

• 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.
  
• Control database security and access.
  
• Create, edit, and run scripts.
  These scripts may include any combination of SQL commands and PeopleSoft Data Mover commands for exporting and importing data.
  
  Data Mover Modes
  
  
  • Regular mode.
    Most of the time, you use regular mode. To sign in to regular mode, enter your PeopleSoft user ID and password during sign-in. In regular mode, all commands are valid.
    
  • Bootstrap mode.
    In bootstrap mode, you use a database access ID and password when signing in. Typically, you use bootstrap mode for database loading, because no PeopleSoft security tables are established yet. You also use bootstrap mode for running some security commands, such as ENCRYPT_PASSWORD
    
    Data Mover Script Commands
  • 
    ENCRYPT_PASSWORD
    EXPORT
    IMPORT
    REM
    REMAR
    RENAME
    REPLACE_ALL
    REPLACE_DATA
    REPLACE_VIEW\
    RUN
    SET
    SET IGNORE_ERRORS
    SET BASE_LANGUAGE
    SWAP_BASE_LANGUAGE