Preparing to Run Export Scripts

Before running a PeopleSoft Data Mover export script, you must first prepare the database.

To prepare for an export:

1. Load DDL model information by running all DDL*.DMS files through PeopleSoft Data Mover.

2. To change the DDL model information, use the DDL Model Defaults utility in PeopleTools Utilities.

3. Run DDDAUDIT.SQR and fix any errors that it finds.

4. Run SYSAUDIT.SQR and SYAUD01.SQR and fix any errors.

5. Use the SQL Alter function in Application Designer to alter all tables.

   Either let the files alter in place or run the script that it generates to alter any tables that it marks as out of synchronization.

6. Use the SQL Create function in Application Designer to create all records, using the If table exists ... Never recreate option.