prim72333:How to upgrade Microsoft SQL Server Database from Primavera Project Management 5.0, ... [Link]
cn/kb/prim72333
Primavera Online Interaction
Primavera Online Interaction (POINT)
OCT 13
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)
Primavera Project Management Add comments
Electronic Disclosure Global discovery services and litigation support from LDM Global [Link]
Need OpenESB Support? Expertise in ESB Support and Integration Services. Call now! [Link]
Microsoft SQL Azure Need data storage that scales? Try SQL Azure for free today! [Link]
Solution ID: 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)
Status: Reviewed
Version(s): 5.0, 6.0, 6.1
Problem: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)
Problem:How to upgrade a Microsoft SQL Server Database to P6 Version 6.2
Fact: Note: v6.2 and v6.2.1 both use v6.2 version database (there where no database changes going from v6.2 to v6.2.1)
Fix: 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.
you need to upgrade the database(s) by performing the following sets of steps.
1 of 15 5/28/2011 10:39 AM
prim72333:How to upgrade Microsoft SQL Server Database from Primavera Project Management 5.0, ... [Link]
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 200
- 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
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 cont
repository feature in P6 v6.2.
- You must upgrade both the project management and the methodology management databases.
Upgrade a Microsoft SQL Server database
[Link] 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
[Link]-click the [Link]?in the Client_Applications\install\database?folder of the P6 physical media or ESD download to s
2 of 15 5/28/2011 10:39 AM
prim72333:How to upgrade Microsoft SQL Server Database from Primavera Project Management 5.0, ... [Link]
the Database wizard.
[Link] 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.
3 of 15 5/28/2011 10:39 AM
prim72333:How to upgrade Microsoft SQL Server Database from Primavera Project Management 5.0, ... [Link]
Note: Click next?on each wizard dialog box to advance to the next step.
[Link] 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 t
system administrator name.
In the Administrative Password field, type the password for this system administrator. The default password for P5 MSDE databa
is typically prima? The default password for P6 6.0 or 6.1 databases is typically prima123Vera? Other possible default password
include password?
4 of 15 5/28/2011 10:39 AM
prim72333:How to upgrade Microsoft SQL Server Database from Primavera Project Management 5.0, ... [Link]
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
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 of 15 5/28/2011 10:39 AM
prim72333:How to upgrade Microsoft SQL Server Database from Primavera Project Management 5.0, ... [Link]
[Link] 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.
6 of 15 5/28/2011 10:39 AM
prim72333:How to upgrade Microsoft SQL Server Database from Primavera Project Management 5.0, ... [Link]
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.
7 of 15 5/28/2011 10:39 AM
prim72333:How to upgrade Microsoft SQL Server Database from Primavera Project Management 5.0, ... [Link]
[Link] the Upgrading Database… dialog box, click next?after the process has completed.
8 of 15 5/28/2011 10:39 AM
prim72333:How to upgrade Microsoft SQL Server Database from Primavera Project Management 5.0, ... [Link]
Note: If the database upgrade fails, see [Link]?located in the user home directory (for example,
C:\Documents and Settings\Administrator). Contact Customer Support if further assistance is needed.
[Link] the Finish dialog box, click Next to run the Database wizard again if you are using the Methodology Management module a
need to upgrade the Methodology Management database.
Otherwise, if you are just using the Project Management module, click Finish to exit the wizard.
9 of 15 5/28/2011 10:39 AM
prim72333:How to upgrade Microsoft SQL Server Database from Primavera Project Management 5.0, ... [Link]
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.
[Link] Microsoft SQL Server Management Studio.
[Link] a new query window for the updated database and execute the following command:
10 of 15 5/28/2011 10:39 AM
prim72333:How to upgrade Microsoft SQL Server Database from Primavera Project Management 5.0, ... [Link]
dbcc useroptions
3. If the value is set to nead committed snapshot? skip to step 6.
[Link] 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
11 of 15 5/28/2011 10:39 AM
prim72333:How to upgrade Microsoft SQL Server Database from Primavera Project Management 5.0, ... [Link]
connection in the database until the execution of the command is complete.
[Link] 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.
12 of 15 5/28/2011 10:39 AM
prim72333:How to upgrade Microsoft SQL Server Database from Primavera Project Management 5.0, ... [Link]
Note: The version 6.2.1 client applications are installed using the P6 version 6.2.1 [Link]?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.
Fix: Word document “Upgrading a Microsoft SQL Server Database to P6 v621″
13 of 15 5/28/2011 10:39 AM
prim72333:How to upgrade Microsoft SQL Server Database from Primavera Project Management 5.0, ... [Link]
Tags: DBA , SQL Server , Timesheets , [Link]
Related Posts
prim52689:How to move a Project Management database from SQL 2000 to SQL 2005.
prim68129:How to validate a PMDB / MMDB P6.1 database schema?
prim80127:Multiple Byte – Cannot display multiple byte Characters in Timesheets
prim46827:Job Services reporting a ORA-28000: The account is locked error.
prim58617:How to validate a PMDB / MMDB P6 database schema?
1. shaun Says:
May 20th, 2010 at 07:13
hello,
is it really true primavera 6 wont work with sql server 2008?
thanks
2. Agelio L. Palacio Jr. Says:
October 17th, 2010 at 19:19
How to upgrade Microsoft SQL Server Database from Primavera Project Management 6.0 to Primavera Project Management
6.1. Thanks
3. Primavera Says:
October 24th, 2010 at 14:39
Open “Primavera Project Management 6.1″ CD —> “[Link]” —> “Install Other Tools” —> “Server Databases”
—>”Upgrade an existing Primavera database”.
4. Primavera Says:
14 of 15 5/28/2011 10:39 AM
prim72333:How to upgrade Microsoft SQL Server Database from Primavera Project Management 5.0, ... [Link]
October 24th, 2010 at 14:49
Hello shaun, Primavera 6 work well with sql server 2008.
5. keff Says:
December 29th, 2010 at 15:16
But the Job Services Doesn’t work with SQL 2008 Express
15 of 15 5/28/2011 10:39 AM
