best practice to create a test environment

[Vit]

hi all,

I'm trying to understand what is the best way to setup a test
environment

I have SQL and WSS in the same machine.

what about create a new PWA istance in the same WSS and use the same
SQL manchine (New Databases)

what can be the best way to import the data and customization from the
production server to the test server???

thanks all

Cheers

Vit

 

[Ben Howard]

Hi Vit,

what about create a new PWA istance in the same WSS and use the same
SQL manchine (New Databases) - YES

what can be the best way to import the data and customization from the
production server to the test server???

this depends on what customisation you have done. If it's configuration
then you can use the playbooks (part of the resource kit) to bring this over.
If it's WSS config then I usually re-do it on the new instance. If it's
code then only you'll know the answer.

Bringing over resources .... Copy the existing resource pool to Excel and
then import from there....,,, or put all the Ent resources onto a plan as and
save as MPP, and then import (Tools | Import resources to Enterprise).

Brining over projects.... Save the plan as MPP, and then import (Tools |
Import projects to Enterprise.

Strangely I have been doing this today at customer site!
--
Thanks, Ben.

Please rate this post if it helped.
http://appleparkltd.spaces.live.com/

 

[Vit]

Hi Vit,


this depends on what customisation you have done.  If it's configuration
then you can use the playbooks (part of the resource kit) to bring this over.
 If it's WSS config then I usually re-do it on the new instance.  If it's
code then only you'll know the answer.

Bringing over resources ....  Copy the existing resource pool to Excel and
then import from there....,,, or put all the Ent resources onto a plan asand
save as MPP, and then import (Tools | Import resources to Enterprise).

Brining over projects....  Save the plan as MPP, and then import (Tools|
Import projects to Enterprise.

Strangely I have been doing this today at customer site!

mmmm it seems to be a long way.....

what about to back up the 4 databases in sql (from production) and
restore them in test environment???

thanks

vit

 

[Gary L. Chefetz]

Vit:

See Brian Smith's Blog. Here's a link to part 2 of his posts on this
subject:

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


--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com

Hi Vit,


this depends on what customisation you have done. If it's configuration
then you can use the playbooks (part of the resource kit) to bring this
over.
If it's WSS config then I usually re-do it on the new instance. If it's
code then only you'll know the answer.

Bringing over resources .... Copy the existing resource pool to Excel and
then import from there....,,, or put all the Ent resources onto a plan as
and
save as MPP, and then import (Tools | Import resources to Enterprise).

Brining over projects.... Save the plan as MPP, and then import (Tools |
Import projects to Enterprise.

Strangely I have been doing this today at customer site!

mmmm it seems to be a long way.....

what about to back up the 4 databases in sql (from production) and
restore them in test environment???

thanks

vit