prim72333:How to upgrade Microsoft SQL Server Database from Primavera Project Management 5.0, 6.0, or 6.1 to Primavera Project Management 6.2 (6.2.1)

Upgrading a Microsoft SQL Server Database to P6 v. 6.2 (6.2.1)

In a client/server environment, if you want to use the databases from Primavera v5.0, v6.0, or v6.1 with P6 version v6.2 (v6.2.1), you need to upgrade the database(s) by performing the following sets of steps.

Notes:

- If the database to be upgraded is running on MS SQL SERVER 2000, it is first required to upgrade the database server version to MS SQL SERVER 2005.  See also:  Solution ID prim52689: ”How to move a Project Management 5.0 or 6.0 database from SQL 2000 to SQL 2005.”

- If current database is version 6.2, you do not need to upgrade the database to v 6.2.1.  Only the application modueles need to be upgraded.      

- Microsoft SQL Server 2008 is not yet supported.     

- It is not required that these steps be performed by an experienced database administrator.

- The wizard runs the necessary scripts to upgrade the database structure and add database objects needed for Document content repository feature in P6 v6.2.
- You must upgrade both the project management and the methodology management databases.

Upgrade a Microsoft SQL Server database

1.Perform a full backup of the current databases.

If you are unsure how to back up your SQL Server database, do not proceed with the upgrade. Contact your database administrator, your database vendor, or see Solution 20001027152711: How to backup and restore a SQL Server database.

2.Double-click the dbsetup.bat?in the Client_Applications\install\database?folder of the P6 physical media or ESD download to start the Database wizard.

3.On the Primavera P6 dialog box choose upgrade an existing database?

Choose Microsoft SQL Server/SQL Express?as the server type.

In the product Key?field, enter the product code that was provided via e-mail or as listed on the License CD label.

Note: Click next?on each wizard dialog box to advance to the next step.

4.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. The default password for P5 MSDE databases is typically prima? The default password for P6 6.0 or 6.1 databases is typically prima123Vera? Other possible default passwords include password?

SA? and primavera? If you changed the default password to one of your own, you will have to supply the password you created.

In the Database Host Address field, enter the server machine name or IP address where Microsoft SQL Server is installed. For a named SQL instance the instance name may or may not be needed as part of the Database host address (i.e.: support-vmtmp1 instead of support-vmtmp1\primavera, where \primavera is the name of the SQL instance).

In the Database Host Port field, enter the port number that Microsoft SQL Server is using. The default is 1433. To verify the port number go to Start / (all) programs/Microsoft SQL Server 2005 / Configuration Tools / SQL Server Configuration Manager / SQL Server 2005 Network Configuration / Protocols for Primavera and double click TCP/IP. In the TCP/IP properties window click the IP Addresses tab and under IPALL, if a TCP dynamic port is defined or if there is a TCP port other than 1433, replace the default Database host port 1433 in the connection Information?screen with the port defined under IPALL.

In the Database Name field, enter the name of the existing database that you want to upgrade.

5.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? then click Upgrade.

The upgrade process could take several minutes, depending on its size.

Note: By clicking on the blue arrow you can display the individual scripts that are executed.

6.On the Upgrading Database… 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 Customer Support if further assistance is needed.

7.On the Finish dialog box, click Next to run the Database wizard again if you are using the Methodology Management module and need to upgrade the Methodology Management database.

Otherwise, if you are just using the Project Management module, click Finish to exit the wizard.

Note: If you click next?you will be repeating the same steps 3 through 7 for the Methodology Management database upgrade.

Configure the Microsoft SQL Server database

Follow the instructions below to verify that the isolation level setting on the upgraded database has been set to nead committed snapshot.

1.Open Microsoft SQL Server Management Studio.

2.Open a new query window for the updated database and execute the following command:

dbcc useroptions

3.   If the value is set to nead committed snapshot? skip to step 6.

4.If the value is set to nead committed? proceed to the next step.

Note: Only the connection executing the alter database command is allowed in the database. There must be no other open connection in the database until the execution of the command is complete.

5.Execute the following command to fix the isolation level setting:

alter database <database name> set read_committed_snapshot on

6.  Execute the dbcc useroptions?command again for visual confirmation.

Note: The version 6.2.1 client applications are installed using the P6 version 6.2.1 setup.exe?found in the \Client_Applications folder of the P6 physical media or download. The version 6.2.1 may be installed over top of prior versions 5.0, 6.0, 6.1 and 6.2 without uninstalling the prior version. Earlier versions required first uninstalling prior versions.