Creation of Demo and System PeopleSoft Databases

A PeopleSoft Demo database contains all the data of the System database (tools and application) and demo data needed for testing or demonstration.

If you create the database manually, without using the Database Configuration Wizard, one of the main steps is to create the Data Mover script to import the system/demo data from the *.db files.

After you log in Data Mover (Bootstrap mode) and open the menu File > Database Setup, here are some things to consider:

1. In the second panel of the wizard, in the Database Type frame, you have to select what kind of application to create:
- choose Demo to have your core application along with demo data
- choose System if you don’t need the demo application data

2. Add the PeopleSoft application you want to create along with all the languages you need, no matter if you create a Demo or a System environment.

3. DO NOT ADD the PeopleTools System Database. This is used only if you want to create from scratch a custom application outside the delivered PeopleSoft applications.

4. When you finish this wizard, Data Mover will create a DMS file that will import data from the PS_HOME\data\*.db files according to your previous selections.

According to the PeopleSoft application, the .db files are named as follows:
hcengs.db, hcengl.db, etc. for HRMS
crengs.db, crengl.db, etc. for CRM
epengs.db, epengl.db, etc. for FSCM
lmengs.db, lmengl.db, etc. for ELM
etc.

Replace further xx with hc, cr, ep, lm, etc. according to your application.

The xxengs.db file will create all the Application and PeopleTools tables, and will import the system data. This file needs to be present in the dms script for both the Demo and System environments.

The xxengl.db file will import Application sample data in existing tables. This file needs to be present only in the script for the Demo environment.

The xxfraa.db, xxitaa.db, xxduta.db, etc. files will import language related data in existing tables. These files are needed for both the Demo and System environments.

The ptengs.db is used ONLY if you want to create from scratch a custom application outside the delivered PeopleSoft applications.

5. The logs of the Data Mover import will be found in the path set in Configuration Manager > Profile > Default > Edit > Common > Log Directory. They are in the format xxengs.log, xxengl.log, xxfraa.log, etc. and can be open to see what data has been imported from every *.db file.