|
|
| |
|
Overview |
| Step 1 |
| Step 2 |
| Step 3 |
| Step 4 |
| Step 5 |
| Step 6 |
| Step 7 |
| Step 8 |
| Step 9 |
|
Step 1: Plan for upgrade and verify prerequisites
When planning for a Database Attach Upgrade to Project Server 2010, you will need to plan for upgrade requirements/prerequisites on both Project Server 2007 and Project Server 2010 installations.
Project Server 2007 prerequisites:
a) Project Server 2007 Service Pack2: Project Server 2007 instance that you are upgrading should be Project Server 2007 SP2.
Please refer the following links related to Service Pack on Project Server 2007:
Please verify the current service pack level on Project Server 2007 instance and take action appropriately.
b) Extended Workspace Templates: If your project server 2007 instance having the custom project workspace templates along with Microsoft Office Project Workspace template. Click here to view the example. In this example Custom Workspace 01 is the extended Project Workspace template.
NOTE: Extended Project Workspace templates will not be migrated to Project Server 2010.
Reason: Templates created in MOSS 2007/WSS 3.0 are not directly usable in ProjectServer 2010. In Project Server 2007 templates are stored as .STP files; In Project Server 2010 site templates are stored as .WSP files. They are different formats and incompatible with each other.
Workaround:
Option 1:
Create the blank site based on custom workspace template (This step need to be perform prior to the upgrade).
Access the previously created blank site in Project Server 2010 instance (This step need to perform after the upgrade)
Save "Site as Template" . This will save site as wsp.
Activate the template.
Option 2:
Access one of the upgraded site which was created earlier using the extended project workspace template (This step need to perform after the upgrade).
Save "Site as Template" . This will save site as wsp.
Activate the template.
c) SQL Server Databases without custom triggers: Before attempting to backup your Project Server 2007 databases, make sure to uninstall any custom triggers that you may have applied to any of the databases (Example: On insert trigger on Project Server Reporting database)
Project Server 2010 prerequisites:
Project Server 2010 Installation:
The Database Attach Upgrade requires you to install Project Server 2010 prior to upgrade Project Server 2007 databases.
Please refer the following links for overview of Project Server 2010 installation
SQL Server database permissions: Make sure to add the Farm Administrator account as DB Owner of any databases you intend to backup and restore.
(or)
You can use SQL Server sa account to backup and restore databases. Once databases restored, add Project Server 2010 Farm Administrator account with db owner permissions on all of the restored databases.
Proceed to Step 2
| |
|
