Migrating Project Server 2007 data

[FrankC]

We have been running two independent pilots based on Project Server 2007 and
SharePoint running on seperate VMWare instances but with the databases in a
farm. We are up to-date on all service packs and rollups. We are now
looking to go into full production in all of our business units within the
division and will be making a clean install on physical platforms; one for
PWA and MOSS and one for Project Server. The databases will continue to
reside in the farm.

The challenge and question: we are trying to resolve how best to migrate
our existing projects from the two vm installs to the single physical
install. Has anyone had any experience with migrating 2007 data? What was
the workflow, where are the pitfalls, and did you lose anything along the way?

Thanks for the help.

 

[Ben Howard]

Hi Frank,

I would look at this in the following way... make sure the enterprise data
(resources, CFs, calendars etc are all the same.

I would then save the existing plan as an MPP and then import it to the new
project server instance, one project at a time. If the enterprise data is
correct then this should take too long.

However, docuements and other WSS data will not be brought across....

 

[GHMontgomery]

I am working with Frank on this migration and can provide a little more
specificity to the issue.

My main concern is how to get the project workspaces to migrate. I can use
Playbook to replicate the server configuration and I know how to manually
migrate my enterprise data; however, I want to ensure that the new farm loads
both WSS_Content databases for use in serving workspace pages.

The last time I tried to migrate a single project server instance from one
WSS farm to another I lost the project workspace associations, thus I lost
the ability to access the workspaces stored in the original WSS_Content
database. All project workspaces which had been created prior to the
migration had to be recreated (luckily, there were only two or three with
active document/risk/issue links built into the workspace). During our
upcoming migration we will deal with a good number of complex project
workspaces which cannot be lost or corrupted as a side effect of the
migration process.

Any and all guidance you can provide is much appreciated; I am testing
different approaches this week with a goal of performing the initial
migration next Monday (Oct 13).

 

[Paul Conroy]

Checkout Brians blog

http://blogs.msdn.com/brismith/arch...ving-a-copy-of-production-to-test-part-1.aspx

http://blogs.msdn.com/brismith/arch...ving-a-copy-of-production-to-test-part-2.aspx

 

[GHMontgomery]

Thanks, Paul. The instructions provided address how to migrate one instance
of PWA over to another; I will post my results of combining two instances of
PWA into one using the methodology presented in part 2 of Brian's blog.

- Gina Montgomery