April 08, 2012

Move A Site From Moss 2007 To Sharepoint 2010

1) Find the content Database; These are listed under Central Admin->Application Management->Site Collection List
2) Backup the content database. Just doing a backup in SQL Server Management studio.
3) Restore content database to the new server, I mean the DB server for your SP2010
Copy the BAK file to new server. Create an empty DB in Management Studio, restore from backup, you may need to change an option in the "options" tab of the restore dialog to get it to work. (Overwrite db).
4) Create a new Web App on SharePoint 2010
5) Remove Content Database from the new web app.

Goto Central Admin->Application Management->Dataases->Manage Content Database ->Click on the database name -> Choose Remove content database and Click OK.
Now use STSADM to add restored DB to this web app
c:\program files\common files\microsoft shared\web server extentions\14\bin on new server is where you can find the STSADM.
run this command from there. Which will upgrade the content db to 2010?
stsadm -o addcontentdb -url http://yourwebapp:port -databasename yourcontentdb

6)The site has been Migrated,now the site should upgrade to 2010 from 2007.
Goto Siteaction ->Site settings->Site Administrator ->Visual Upgrade ->Update all sites .Now the site has been successfully migrated.
7) Run IISRESET  from command prompt

No comments:

Post a Comment