Converting Instances

C

CQ

I have two instances, and for a myriad of reasons, I simply want to switch
the names of them. I have an instance which we have junked up and I want to
"replace" it with a newer instance. THe exact same schedules are in both,
but all the settings are different.

For example, I have an instance named "ProjectServer" and one called
"ProjectUsers".

If I simply go to SQL, and rename them, will all my settings in Sharepoint
and PWA still work out fine? My goal is for everybody to suddenly see the
new version. Will that work if I just rename ProjectServer to ProjectUsers
and vice-versa?
 
G

Gary L. Chefetz [MVP]

CQ:

I think the appropriate way to handle this is to backup the original
database, then restore a copy of the second instance over the first.
 
L

Lewis M

Hi Gary,

I, too, have two PS instances on a single server. I have one instance for
"production" and another instance for "training/testing." In production, I
have added users to the enterprise resource pool and place them in the right
security group in PWA. I want to add the same users to the training/testing
instance, but I do not want to retype this information or reselect security
groups. So, is there way to share the users' account information betweeen the
two instances? This is important because I need to keep the two instances
synchronized.
 
G

Gary L. Chefetz [MVP]

Lewis:

There's no tool for this, but you can certainly automate it. A not too
onerous method to copy resources between instances is to use an mpp file as
intermediary. In short, create a view of the resources in Project, based on
the Resource sheet, that displays all the data you want to copy. Filter the
view to show only the resources that you've recently added, and save the
project as an mpp. Then use the import resources to enterprise feature to
import them into your other instance.
 
L

Lewis M

Gary, thanks for the tip. I will use it.

Gary L. Chefetz said:
Lewis:

There's no tool for this, but you can certainly automate it. A not too
onerous method to copy resources between instances is to use an mpp file as
intermediary. In short, create a view of the resources in Project, based on
the Resource sheet, that displays all the data you want to copy. Filter the
view to show only the resources that you've recently added, and save the
project as an mpp. Then use the import resources to enterprise feature to
import them into your other instance.
Click to expand...
 
Top