Upgrading a P6 EPPM Database with Microsoft SQL Server

If you want to manually upgrade P6 EPPM, you should upgrade your P6 EPPM database using the Primavera Database Setup Wizard.

To upgrade a P6 EPPM database using the Primavera Database Setup Wizard:

To open the Primavera Database Setup Wizard, run dbsetup.bat (with Windows) dbsetup.sh (with UNIX or Linux) at <P6_EPPM_Home>/database where <P6_EPPM_Home> is the P6 EPPM home directory that was set during installation.
Note: Click Next after each of the following steps.
On the Primavera P6 screen, complete the following:
1. Select Upgrade an existing database.
2. Select Microsoft SQL Server.
On the Connection Information screen, enter the connection details for a Microsoft SQL Server database and the administrative database user.
On the Create New Keystore screen, do one of the following:
- If a you want to use an existing keystore, enter the password in the Existing Keystore Password field.
- If you are creating a new keystore, do the following:
1. Select Create New Keystore.
2. In the Enter Keystore Password field, enter a password for the new keystore.
3. In the Confirm Keystore Password field, enter the new password again for verification.
- If you do not want to create a keystore and you do not have an existing keystore, ensure all fields are clear.
On the Upgrade Option screen, enter the credentials for the Px Reporting user. The default is pxrptuser.
On the Ready to Begin Upgrading Data screen, select Yes, upgrade my database.