Search for Sharepoint Examples and Tutorials:   
Banner

Sharepoint Forum

Home » Forum » SharepointRSS Feeds

Import/export or backup/restore to refresh dev environment?

  
  Asked By: Jamie Baker         Date: Aug 07, 2007      Category: Sharepoint      Views: 44

We have a dev environment and a prod environment. We want to
periodically refresh the database in the dev environment with a copy of
the prod environment, so that we're testing stuff on relatively recent
data (including configuration). What's the best method for doing that?
What are the merits/pitfalls to using the stsadm import/export command?
What are the merits/pitfalls to using a backup/restore (copy over)
method?


 

4 Answers Found

 
Answer #1       Answered By: Deven Gajjar          Answered On: Aug 07, 2007       

If you want to refresh your databases do just that. Make backups of your
content DBs in production. Detach your content databases in your dev
environment. Restore your DBs to dev. Reattach them.

If for whatever reason you don't want to do that then backup and restore is your
next best option. It's a lot more work though. The database option is much
better.

 
Answer #2       Answered By: Latisha Schneider          Answered On: Aug 07, 2007       

Will that get both content and configuration databases?

 
Answer #3       Answered By: Nora Maxwell          Answered On: Aug 07, 2007       

It'll do whatever databases you back up and restore. I haven't done this much
with v3, but I don't think you want to bring the Config database over, just the
Content DBs. In v2 the Config DB had hard coded server names that could really
cause you problems in Dev. The Content DBs have all of your content, so you'll
be fine just bringing them over.

 
Answer #4       Answered By: Corina Duran          Answered On: Aug 07, 2007       

Just the content databases.

If you need the SSP databases, that is a whole different world.

 


Your Answer
  • Answer should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].
 

 
Hall of Fame|Facebook|Twitter|LinkedIn|Terms of Use|Privacy Policy|Contact us
RSS Feeds: Articles |  Forum |  New Users |  Activity Log |  Interview FAQ |  Poll |  Hotlinks
Copyright © 2005-2011