Inherited two MOPS 2007 farms

[Zook]

Hello:
I have two MOPS 2007 farms. I want to migrate all the old stuff from
the main MOSS farm into the seperate Project farm. I can find lots of
information on moving from older versions of MOPS 2007, but nothing
for merging these two farms. Both are in use and have lots of active
projects.

Can someone post a link or something to help me get started with
this? Thanks!

 

[Marc Soester [MVP]]

Hi Zook,

From what I understand you have 2 PS Farm instances and would like to
consolidate both into 1.

I dont think there is a tool or documented proceedure.

Now there are many things you will need to consider.
Do both instances have the same custom fields, same resource pool, user
groups etc. Assuming that this is the case, this is how I would do that:
Determine which one of the PS instances is your leading one.
Then export the workspaces ( stsadm command) and Proejct Schedules (mmp file)
--Depending on how many Projects, you may be able to do this manually,
otherwise you will need to write a script--
Import the schedules and workspaces into your leading PS

That could do the trick. Either way, I would make sure to test this on a
test environment first. As I mentioned earlier, many things can go wrong.
Hope this kind of helps

 

[DogLBer]

Been there, Done that.
I manually merged a 50 project instance into a larger one.
You will have to prealign all custom fields, and Resource custom fields,
including Dropdown lists and Calendars. I maually recreated the Views and DA
reports. it was the easier of options. I exported the resource pool to Excel
and moved them first then saved the plans to a laptop and imported them into
the new instance.
Two surprises - all project custom fields entries got wiped out and PMs had
to reconfigure them, and I was set as Status Manager for all tasks because to
the tool I created them and this had to be cleaned by the PMs.
Migrating the Workspaces was straight forward.

 

[Ben Howard [MVP]]

Great info from DogLBer - interested that the Project Custom Fields got
removed, my experience of migrating from 2003 -> 2007 kept them as local
ones, though I chose the default options when saving to an MPP file.

Agree on the Status Manager field though. You could write some VBA so that
this is changed when the PM saves the project to the PM's name...

 

[Mike Mahoney]

Great info from DogLBer - interested that the Project Custom Fields got
removed, my experience of migrating from 2003 -> 2007 kept them as local
ones, though I chose the default options when saving to an MPP file.

Agree on the Status Manager field though.  You could write some VBA so that
this is changed when the PM saves the project to the PM's name...
--
Regards,  Ben.






- Show quoted text -

Zook

Do you simply want to merge environments, so that a single
infrastructure serves both project server customers, or do need the a
single project server environment? The earlier comments address the
second requirement, but if is the first, it is a simple matter to
restore project server databases to the MOPS farm you are retaining
and then create a new project server instance pointing to these
databases.

rgds

Mike