How to copy Global Data from one Project Server 2007 instance to another

G

GG

As you rememebr 2003 had Enterprise Global Template and lot of the
configuation data was in this file which was very easily transferable
to another instances.

Now in 2007 the global data mostly resides on the server itself, how
can we move this data to other instances ? Is this restoring all the
databases to this new instance ?

Any pointers

GG
 
B

Brian Smith \(MSFT\)

Hi GG,

A couple of ways depending where you want the other instance. A full
SharePoint farm backup and then restore to another machine (using the New
configuration option) will maintain everything, including any WSS content
and customization.

If you just want the project data then don't restore the databases to
another instance (which will break that instance) but instead restore the
databases to new names and then create a new instance against those
databases.

There may be a resource kit tool at some point in the future that will allow
easier moving of global data - or you could use the PSI to pull data from
one instance and push to another, for some of the enterprise stuff.

Best regards,

Brian.
 
N

Nico Oosthuysen

I vote for the resource kit tool...

;-)
Brian Smith (MSFT) said:
Hi GG,

A couple of ways depending where you want the other instance. A full
SharePoint farm backup and then restore to another machine (using the New
configuration option) will maintain everything, including any WSS content
and customization.

If you just want the project data then don't restore the databases to
another instance (which will break that instance) but instead restore the
databases to new names and then create a new instance against those
databases.

There may be a resource kit tool at some point in the future that will
allow easier moving of global data - or you could use the PSI to pull data
from one instance and push to another, for some of the enterprise stuff.

Best regards,

Brian.
Click to expand...
 
G

Gagan Goel

Brian:

I will need more clarification on this. Can you elaborate the steps for both
the options.

I tried creating 4 new databases (project server -4) and then restored the
data from a populated instance to these database, then I tried to create a
new project server instance utilizing these resored database and got the
following error
----------------------------------------------------------------------------------------

Provisioning 'PWA2': One or more of the databases already contains schema.
When editing or creating a Project Server instance, you may specify:
* Four databases that do not exist
* Four existing, blank databases
* Four existing Project Server databases of the same version from the same
installation.
Combinations of blank, new, and existing databases are not allowed.

For more information, see Help and Support Center at
 
Top