?
Solved

Move content databases between SHarePoint Farm

Posted on 2011-02-11
3
Medium Priority
?
789 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

How Blockchain Is Impacting Every Industry

Blockchain expert Alex Tapscott talks to Acronis VP Frank Jablonski about this revolutionary technology and how it's making inroads into other industries and facets of everyday life.

Question has a verified solution.

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

The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

765 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