To upgrade a Microsoft SQL Server database:
- Perform a full backup of the current databases.
If you are unsure how to back up your Microsoft SQL Server database, do not proceed with the upgrade. Contact your database administrator, your database vendor, or Oracle Global Customer Support for assistance in backing up your database before performing the database upgrade. Also, ensure that you are familiar with the process of restoring the backup copy of the database in case you need to do so.
- Double-click dbsetup.bat in the Database folder of the P6 Professional physical media or download to start the Database wizard.
Note: Click Next on each wizard screen to advance to the next step.
- On the Primavera P6 dialog box:
- Choose Upgrade an existing database.
- Choose Microsoft SQL Server as the server type.
- On the Connection Information dialog box:
- In the Administrative User Name field, type the Microsoft SQL Server system administrator name to register to the server. If you chose the defaults during the Microsoft SQL Server installation, leave SA as the system administrator name.
- In the Administrative Password field, type the password for this system administrator. If you chose the defaults during the Microsoft SQL Server installation, leave the password field blank.
- In the Database host address field, enter the server machine name or IP address where Microsoft SQL Server is installed.
- In the Database host port field, enter the port number that Microsoft SQL Server is using. The default is 1433.
- In the Database name field, enter the name of the existing database that you want to upgrade.
- On the Ready to Begin Upgrading Data dialog box:
- Verify that the current version of your existing database is listed correctly.
- Choose Yes, upgrade my database.
- Click Upgrade.
The upgrade process could take several minutes, depending on its size.
- On the Primavera Database Setup Wizard dialog box, click Next after the process has completed.
Note: If the database upgrade fails, see PrimaveraDatabaseSetup.log located in the user home directory (for example, C:\Documents and Settings\Administrator). Contact Oracle Global Customer Support if you need further assistance.
- On the Finish dialog box, click Finish to exit the wizard.