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

To migrate your P6 EPPM schema to P6 Professional:

1. Open the Migrate Database wizard by completing the following:
   1. Navigate to the database folder of your P6 EPPM installation. For example, C:\P6EPPM_1\database\ (for Windows) or /u01/P6EPPM_1/database/ (for Linux).
   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 EPPM users for P6 Professional, 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.