Prerequisites for Schema Migration

In order to migrate schema between P6 EPPM and P6 Professional, you must be on the same version of both applications.

If you are using Oracle for your RDBMS, ensure that you have completed the following prerequisites before attempting to migrate your schema:

Create an empty Oracle database for your target database.
Set the open_cursors system parameter to a value of 1000 or greater depending on the size of your source database.
Run the manual_script_before_install.sql script from the P6 EPPM or P6 Professional installation folder on your target database. Alternatively, if you are migrating your schema to P6 Professional, you can run the following script on the P6 Professional database:
GRANT SELECT ON sys.DBA_EXTENTS

TO SYSTEM with grant option;

If you are using Microsoft SQL Server for your RDBMS, you must enable FILESTREAM.

Last Published Tuesday, December 12, 2023