Move a Project Server app instance to a new server? Signed Despera

[John Carter]

How can I move a project server 2003 and windows sharepoint services
application in its entirety including the related databases from one server
to another server which has a different name. The current server instance is
running SQL server 2000. I am not looking for how to simply port the
databases, I need to replace the current server in its entirety while
preserving my data. I recieved a response in a prior post that pointed me to
knowledge base article 905386, which is related to a process for
incorporating a new server for the purpose of using a new SQL Server
instance. This is not what I require. I am looking for a complete replacement
for the existing server, while preserving my data. Based upon my casual
inspection of various Project Server Database tables, and Windows Sharepoint
Services it would seem to me that nothing short of a utility that would
import that WSS sites and edit the URLs to point them to the new hosting
server, is needed.

 

[Russ]

You can successfully move Project Server, WSS and the associated SQL
databases by following the steps shown below.

1. Restore the Project Server database to the new database server (fix
MSProjectServerUser and MSProjectUser accounts using sp_change_users_login
'Auto_Fix' in query analyser).

2. Install WSS and Project Server on the new application server (choose the
'connect to an existing Project Server database' option and connect to the
project server database that you created in the previous step. Install WSS
normally, creating new config and content databases).

3. Create WSS project workspaces on the new deployment via the Project
Server admin interface.

4. Backup project workspace data from the original WSS deployment using the
WSSMigr.exe.

5. Overwrite project workspaces on the new deployment with the data backed
up in the previous step using the WSSMigr.exe.

6. Select 'Manage Windows SharePoint Services --> Manage SharePoint sites'
from the left navigation pane on the 'Admin' page of Project Web Access (on
the new application server). For each project listed, select the project (by
clicking in the margin next to it) and press the 'synchronize' button, on the
top menu (If you don't run the synchronize, WSS will try to access your old
project server environment when you attempt to view/add/update an issue).

I have performed the steps shown above, and everything seems to work fine. I
will be putting it through rigorous user testing before implementing in
production, and will let you know if I discover any problems.

Russ