Copying Projects to a Target Database

To copy a project:

1. (Optional) Lock target database definitions.

   Before PeopleSoft Application Designer replaces or deletes a definition in the target database, it checks to determine whether the definition has a change control lock applied. If so, PeopleSoft Application Designer takes action on that definition if it has been locked by the same user ID that is performing the copy. Consequently, the speed of a copy might be slow because every definition to be deleted or replaced in the target must be checked.

   You can avoid the performance degradation by locking all of the database definitions in the target database by using the Change Control Administrator dialog box. This sets a flag telling PeopleSoft Application Designer not to check the lock status of every definition. When all target definitions are locked, the copy is faster.

2. Deactivate all system tracing.

3. Select Tools, and then Copy Project, and then To Database from the PeopleSoft Application Designer toolbar.

   The Target Signon dialog box appears, prompting you to sign in to a target database.

4. Sign in to the target database as you do with any PeopleSoft database.

   The Copy dialog box appears.

5. In the Copy dialog box, specify the types of definitions to copy and start the Copy process.

6. (Optional) Select the Reset Done Flags check box.

   Any definition with a selected Done check box is not copied. The first time that you copy a project, all Done check boxes are cleared. When you're repeating a copy due to problems found the first time, however, you might want to clear the Done check boxes of definitions that were copied incorrectly. Clear all project Done check boxes from the Copy dialog box by selecting Reset Done Flags. This option is selected by default.

7. (Optional) Select the Copy Project Definition check box.

   If you select this check box, the project definition is copied to the target database.

8. Select the definition types to copy.

   Only the definition types that exist in the project are displayed in the Object Type(s) list. To select all types, click Select All. You can also copy one definition type at a time (repeat this procedure each time).

   Note:

   If you copy definition types individually, copy them in the order in which they’re presented in the dialog box. For instance, start with records, then indexes, and so on.

9. Click Copy.

   As the Copy process runs, a progress indicator appears on the status bar of the dialog box, displaying the definition type, the total number of definitions to copy, and the number copied so far.

10. After the copy completes, check for messages.

    If you find any problems, correct them and repeat the copy.

11. Stamp the database.

    To track the history of the configuration upgrades, PeopleSoft recommends that you stamp the target database after each copy.