Problem migrating to Project Server 2007

[MJI]

How to migrate Project Server 2007 databases from single server to another
server with small farm architeture (application server looking for database
server), with all customization and sites created.

I did the migration using the four databases Archive, Draft, Published and
Reporting, creating a new Project Web Access site looking for them.

But when I access the PWA site, the sites created by me are gone. How can I
fix this problem?

Regards

Marcos

 

[Andrew Jacks]

G’Day Marcos
Project Server Migrations are the bane of my life. It is very disappointing
that Microsoft have not produced a tool that allows this to be done
automatically.
Your problem stems from the fact that the four Project Server databases do
not hold any workspace information, that is looked after by SharePoint and
held in the content database. Unfortunately you cannot backup and restore
this database as you need to provision a new instance of PWA against your
existing Project Server databases, which creates a new content database.
The good news is that you should be able to extract the original workspace
information using the STSADM command (found in the 12 hive directory) via
stsadm -o export -url originalWorkspaceURL -filename
C:\Backups\PWASites\workspaceName.bak -includeusersecurity -versions 4 >>
C:\Backups\PWASites\Export.log
Then re-import to the new site using: -
stsadm -o import -url newWorkSpaceURL -filename
C:\Backups\PWASites\workspaceName.bak -includeusersecurity -updateversions 2Once imported you will need to re-link the Projects to the workspaces
(Server Settings/Project Workspaces)
And also re-apply any customisations.
There are some great blogs out there for this process. Have a look at
http://blogs.msdn.com/brismith/arch...ving-a-copy-of-production-to-test-part-1.aspx
For an alternate approach.

Let me know if this helps

 

[MJI]

Andrew good job!!!
Thanks for your attention, you are right is very disappointing, because dont
find many articles and faqs about this.

I will try to do this. I saw this site too
"http://proj2007.blogspot.com/2008/10/steps-to-move-project-server-2007-from.html"
but I cant find ReLinkAllWSSSites.exe, I just have installed "Project Server
2007 Project Resource Kit tools" but I didnt find. What do you think about
this solution in that link? Is it work?

Regards

Marcos

 

[MJI]

Andrew,

I did the export and import process, but when I access the pwa site, it
doesnt open showing an error like this "the attribute enablesessionstate is
denied on this page.". Then I couldn't re-link the project to the workspaces.

Regards

Marcos.

 

[Andrew Jacks]

G'Day,

You will find the relink program at
http://www.microsoft.com/downloads/...3C-6424-48E4-B87E-0861D1977BB7&displaylang=en

as it is part of the Project 2007 Project Resource Kit

 

[Andrew Jacks]

G'Day Marcos,

Welcome to Project Server 2007 Migration Fun.

I have not had an error like the one described. Are you able to provide the
error in more detail?