Database-attach full upgrade to Project Server 2010

When you upgrade from Microsoft Office Project Server 2007 to Microsoft Project Server 2010 by using the database attach upgrade process, you upgrade only the content for your environment, and not the configuration settings.

Before you begin the database attach full upgrade to Office Project Server 2007, review the following information about permissions, hardware requirements, and software requirements.

Step1-Review required hardware and software

You must be running one of the following products on the database servers to perform these procedures:

  • On your project server 2007, you need to install project server service pack 1, 2 and cumulative update for project server (oct 2009) and Windows SharePoint Services 3.0 with SP2
  • On your Project Server 2010 environment: a 64-bit version of one of the following products:
  • SQL Server 2008 Service Pack 1 with Cumulative Update 2
  • SQL Server 2005 Service Pack 3 with Cumulative Update 3

Step2-Database attach full upgrade overview

The following databases are upgraded in a database attach full upgrade:

Draft, Archive, Publish, Reporting, SharePoint content database (containing your Project Web Access site data)

Step3-Verify your Project Server 2007 data

To perform a database attach full upgrade, you must verify that your Office Project Server 2007 data is in a valid state to help ensure that your upgrade will be successful. You must verify the following:All projects should be checked-in.(Read and Write mode)

Extract your Project Web Access site from a content database to a new content database (Optional)

If you do not have a separate content database for your Project Web Access site .In this situation, we recommend that you extract the Windows SharePoint Services site collection for PWA into a new content database.

Step4-Back up the databases in SQL Server

After the back up a database in SQL Server

“Run the Share point 2010 products configuration wizard and disconnect from this server farm in modify server farm settings and click on next”

Now again run the share point 2010 products configuration wizard and create a new server farm and click on next

Step5-After run successfully configuration wizard go to services.msc and stop the following services-

1-World wide web publishing service

2-Sharepoint2010 administrator

3-Sharepoint2010 timer

4-Share point 2010 tracing

Note-We stop all these services because when we restore WSS_content database in sql then it not restore because here is the same name of WSS_content in 2007 and 2010 also.

Step6-Now restore all five databases and overwrite the existing database(WITHREPLACE)

Step7-Now again restart all the sharepoint2010 service

Step8-Add the restored content database to the Project Server 2010 farm

  1. Run the following:STSADM.EXE –o addcontentDB –url<WebAppURL>-databaseserver<SQLServerName>-databasename<WSSContentDBName

For example: stsadm.exe –o addcontentdb –url -ds astro2010 –dnWSS_Content

The database name should be the exact name of the content database you restored to SQL Server in the previous procedure. When the command prompt returns, the step has been completed.

This command will create its own content database. After run this commandiisreset/noforce.

Step9-Provision a new Project Server 2010 PWA instance using the restored databases

In Project Server 2010, you can now create a Project Web App instance using the Office Project Server 2007 databases you restored to SQL Server in the previous step. When the instance is created, the restored databases will be upgraded to Project Server 2010.

Create a Project Server 2010 Project Web Access instance using the restored Project Server 2007 databases

  1. On SharePoint Central Administration Web site, in the Application Management section, click Manage service applications , Project server service application and create project web access site.

Note: “Verify that the names of the Project Server databases match the names of the restored Office Project Server 2007 databases that you will use. If they do not, change them so that they match.”

  1. Click OK.