Link to home
Start Free TrialLog in
Avatar of BoozTech
BoozTechFlag for United States of America

asked on

Move content databases between SHarePoint Farm

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.
SOLUTION
Avatar of Justin Smith
Justin Smith
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of BoozTech

ASKER

I did use the SP Profile migrator and it worked. Thanks for yout comments.