Exporting PeopleSoft Table Structures Using PeopleSoft Data Mover

This section describes how to use PeopleSoft Data Mover to export the PeopleSoft database structure to a DAT file.

Note:

This process exports the database table structure only and does not include the database contents.

Sign into the PeopleSoft database using PeopleSoft Data Mover in user mode(non-bootstrap mode), and run the following script.

SET NO TRACE;
SET OUTPUT output_file.dat;
SET NO DATA;
EXPORT *;

The DAT file created by PeopleSoft Data Mover will contain only the structure of your PeopleSoft tables and indexes, not the data.

Save the file created by this process. It will be referred to as the structural export in this appendix.