How to Improve Performance of P6 Database Migrations with the Migrate.bat/sh Utility
(Doc ID 2068053.1)
Last updated on AUGUST 17, 2022
Applies to:Primavera P6 Enterprise Project Portfolio Management - Version 18.104.22.168 and later
Information in this document applies to any platform.
The migrate.bat /.sh utility is a Java-based data pump utility, which can be used pump data from one database (source) to another (target). However, in all releases prior to r22.214.171.124, the process completes a regular insert operation into the target database which can result in performance degradation during the data loading process. This document will provide suggestions to improve the performance of the migration utility when run against larger databases.
For additional information about using the schema migration utility see How to Use Migrate.bat (Data Pump) to Move Data from a Source Database Instance to a Newly Created Target Database Instance (Doc ID 911740.1).
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!