Importing Database Contents Using PeopleSoft Data Mover

Run PeopleSoft Data Mover in bootstrap mode against the new database. Login in bootstrap mode using the OwnerID and password. Once signed in, run the following script:

SET NO TRACE;
SET INPUT inputfile;
SET UNICODE ON;
SET ENABLED_DATATYPE 9.0;
IMPORT *;

Note:

SET ENABLED_DATATYPE 9.1 is also valid and has the same effect as SET ENABLED_DATATYPE 9.0.

This will import the entire contents of your original database into the new database, while creating character columns using the NVARCHAR data type (for SQL Server) or VARBINARY data type (for DB2), and converting your data to Unicode.