Migrating P6 Professional Schema to P6 EPPM for Microsoft SQL Server Database

To migrate your P6 Professional schema to P6 EPPM:

1. Open the Migrate Database wizard by completing the following:
   1. Navigate to the \database folder of your P6 Professional installation.
   2. Run migrate.bat (for Windows) or migrate.sh (for Linux).

      Note: After each step, click Next.

2. On the Select Migration Type screen, select Schema Migration.
3. On the Select Source screen, select Microsoft SQL Server.
4. On the Connection Information screen, enter the connection details for the source SQL Server database and the administrative database user.
5. On the Select Target screen, select Microsoft SQL Server.
6. On the Connection Information screen, enter the connection details for the target SQL Server database and the sys admin database user.
7. On the Configure Database Users screen, complete one of the following steps:
   • If you want to use the existing P6 Professional users for P6 EPPM, complete the following:
     1. Select the Use Existing check box.
     2. In each User Name list, select the username of the database user.
     3. In each Password field, enter the password for each database user.
   • If you want to create database users for P6 Professional, enter the login credentials for each database user in the User Name, Password, and Confirm Password fields.
8. On the Configure Microsoft SQL Server/SQL Express Database screen, enter the required information in the Database name, Data file, Log file, and Database code page for the P6 Professional schema.
9. On the Migrate Options screen, enter the size of the batch that will be used for the SQL insert of P6 data into the P6 Professional database.

Legal Notices | Your Privacy Rights
Copyright © 1999, 2020

Last Published Friday, March 19, 2021