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 an Oracle database, 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, you must enable FILESTREAM.