[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Move content databases between SHarePoint Farm

Posted on 2011-02-11
3
Medium Priority
?
793 Views
Last Modified: 2012-05-11
We have SharePoint 2007 production and stage farm. I would like to refresh stage farm with the data from production farm. I did restore content and Mysites databases (we have one for each) on stage. Everything went well I can access sites and mysites on stage portal but with one issue.
We have customized mysites with lot of employee data displayed on the page which are obviuosly stored in SSP database. With the restore profile properties are not updated.
For ex: If open my mysite on stage, data which are being displayed on mysite is not the same as in production mysite. I think restoring mysites db doesn't really updates the SSP db.

Do I need to restore prod. SSP db on stage separately??, if I did would it break the link to profiles?? or is there any other way through sql script to update SSP properties??

Thanks in advance.
0
Comment
Question by:BoozTech
  • 2
3 Comments
 
LVL 38

Assisted Solution

by:Justin Smith
Justin Smith earned 2000 total points
ID: 34873979
I've never had much luck moving SSP databases between servers. Always followed this:

http://technet.microsoft.com/en-us/library/cc896556(office.12).aspx

I actually think this is the only supported way, seems like I've heard that somewhere :)
0
 
LVL 38

Accepted Solution

by:
Justin Smith earned 2000 total points
ID: 34873987
0
 

Author Comment

by:BoozTech
ID: 34890226
I did use the SP Profile migrator and it worked. Thanks for yout comments.
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question