Move Project Server 2007 from One Environment to Another (Including Workspace)

Assumptions:

1.       Installed Project Server on New Machine to a point where you have SharePoint Central Administration, Web Application on Port 80, Web Application for SSP and Project Application Service is started.

2.      Same project server service pack and patches installed on new server.

3.      Backed and restored project server database to new server.

4.      Backed and restore Content Database for Port 80 (Assuming your project server work space was on port 80)

Steps:

1. Start » All Programs » Administrative Tools » SharePoint 3.0 Central Administration
2. Operations > Topology and Services > Services on Server > Project Application
3. Make Sure Project Application Service is started.
4. Under Shared Service Administration Click on SharedServices1 (Name could be different)
5. Click on Project Web Access Sites
6. Click on Create Project Web Access
7. Make Sure you select the same "Project Web Access Path" if you want to RESTORE AND RELINK SharePoint workspace. My Scenario was PWA.
8. Enter the account info for Administrator Account and Primary Database Server
9. Enter the name of Published Database, Draft Database, Archive database and Reporting Database (restored databases)
10. Click on refresh status after few minutes, the Site should be provisioned
11. Click on the site just to make sure project web access is working
12. Click on Workspace "The PAGE not found" (EXPECTED)
13. Now Create a new web application
14. Navigate back to central administration > application management > Under SharePoint Web Application Management Click on Create or Extend Web Application
15. Create New Web-Application on Port 81 *Can be any port except 80
16. Once the Web application is created on port 81 > Navigate back to central administration > application management > Under SharePoint Web Application Management Click on Content databases
17. Change the Web-Application to http://servername:81/
18. Remove the content database of port 81 (Make Sure you are removing the content database of correct web application)
19. Click on Database name and then click on Remove Content Database > Click Ok
20. Add Content Database of Port 80 from Previous Server (I did restored the database as "OLD") to this web application on Port 81
21. Download Project Server Resource kit for project server 2007 from Microsoft.com
22. Extract it to C:\ResourceKit
23. Start > Run > Cmd
24. Browse to C:\ResourceKit
25. Type ReLinkAllWSSSites.exe http://servername:81 http://servername/pwa
26. Type Browse to PWA (http://serverName/PWA) you should see all Projects and their SharePoint sites.
    
    

Check this blog from Brian Smith
http://blogs.msdn.com/brismith/archive/2008/10/01/stsadm-export-and-import-correction-for-moving-project-workspaces.aspx