Migration to New Environment

[Charles L. Simpson]

We currently have SQL server on one server and SharePoint/Project Server
applications on another server. We will soon be getting two new servers to
replace these older ones.

I have found the following document on Microsoft that describes how to move
the data to a new SQL server (http://www.kbalertz.com/kb_905386.aspx). I
could not find any documentation on how to move to a totally new environment
for both servers (step-by-step would be nice).

I would suspect that someone has done this before and knows of some
documentation and/or pitfalls and/or advise from their migration.

If you know of where this migration would be documented and/or have advise,
please contact me.

Thanks!
--
---------------------------------------------------------------
Charles L. Simpson
ACT, Inc.
---------------------------------------------------------------
Current Setup:
WSS 2.0 (no service packs)
Project Server 2003 SP1
SQL Server 2000 SP3a
FrontPage 2003 SP2
-----------------------------------------------------------------

 

[Rick Roszko]

Without getting into details, here are the steps:

(a) Create a brand new clean install of your IIS server and SQl server.

Do an image backup of the IIS server so you don't have to rebuild if you
goof! (For SQL, you basically just have to delete the MSPS and WSS
databases)...

I assume the dat is cleans and does not need fixing due to any corruption...

(b) Get "Edit Site" from microsoft.com by typing in "editsite" (no space)
and you will get the utility in one link and instructions in another link.

(c) Basically backup your Project Server database (default name
"ProjectServer") from your current SQL server and restore it to your new SQL
server. Note: If you already used "ProjectServer" and your data is in
"ProjectServer", you need to rename it to a different name.

(d) Use Editsite to connect the restored database. Done. MS Project Server
is now connected and use whatevernmae you used in the editsite tool to get to
the new site, e.g. http://servername/newname

(e) Now, just follow kb_905386 to move the SharePoint site

That's it...

Of course, practice first. Any mis-step and it won't work! Just restore
the IIS image and blow away the MSPS and WSS database and re-try...

 

[Russ]

1. Restore Project Server database to the new database server.

2. Install WSS and Project Server on the new application server (using the
'connect to an existing Project Server database' option. For WSS, install
normally and create 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.
For each project listed,
select the project (by clicking in the margin next to it) and press the
'synchronize' button, on the top menu.

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

Russ