I was recently performing a development refresh of a Project Server 2007 environment for a client this week in preparation for training we are to be conducting. In this case I needed the Project Workpaces as well. The simple approach I took is outlined below:
- Log into SharePoint Central Administration in the development environment
- Navigate to the SSP for the development instance of PWA
- Delete the PWA instance
- Backup your 5 project server databases from the production environment and restore them on your development server environment
- Provision a development PWA instance, specifying the four project server databases restored in the previous step.
- Note that in this case I used port 80 (/PWA">http://<serverName>/PWA)
- Validate your PWA instance is functioning correctly
- Navigate to Project Center, Resource Center, etc.
- Create a new Web Application from within SharePoint Central Administration
- In this case I created it on port 91 (:91">http://<serverName>:91)
- Attach the content database you copied from production and restored in a previous step
- You can, if you like, remove the content database created when you created the web application. Since it’s empty it does not matter.
- Download the Project Server 2007 Resource Kit
- Extract it so c:PS2007RK
- Start > Run > CMD
- Browse to c:PS2007RK
- Run the following command
- RelinkAllWSSSites.exe :91">http://<serverName>:91 /PWA">http://<serverName>/PWA
- Browse to PWA and confirm all SharePoint Project Workspaces are available.
-Dan