Migrations


Here's a checklist of steps when migrating Application Designer projects between a source and target database. For example the source might be a development environment and the target a test environment.

Source database

  1. Validate the source Project
  2. Compare the Project to the target environment. Ensure you have the right compare settings
  3. Check the upgrade flags for all object types and ensure they are correct (be especially wary of deletes)
  4. Copy the project to the target enviroment. Again, ensure you have the right copy settings
  5. Re-compare your project with the target enviroment and check the flags - make sure it seems everything has been copied

Target database

  1. Validate the project. This will more than likely tell you of most migration problems.
  2. Build the project script in the target environment with the appropriate build settings.
  3. Run the build script. Track if anything fails.

The most likely causes for the build script failing are the order in which the objects are created (e.g. a view is being built before a record that the view uses) or there are objects missing in the target environment (either left out of the project or due to a dependency on another project).

When the migration is complete:

  • Have the PeopleSoft administrator clear the web/application server cache
  • If security is being migrated, run portal security sync

Revision #1
Created Mon, Jul 29, 2019 10:35 AM by PeopleSoft Wiki
Updated Mon, Jul 29, 2019 10:38 AM by PeopleSoft Wiki