I have SharePoint 2007 website with 2 TB database. I need to migrate this in SP 2013 without using any tool.
Please share your experience.
Hi,
1.Go to SqlServer and take backup of the content database and restore it into your sqlserver.
2.Create new web application and site collection in SP2013.
3.Now remove the content database from this webapplication.
a.Go to central Administrator
b.Click on Application Management and then
c.click on content database => Manage Content database
4.Then select the newly created webapplication URL
5.Click on the database which is on the left side.
6.Then go to remove content database part and check the checkbox then it will prompt you popup there click on then again ok button.
Now test the whether the webapplication still having relation with the content database by using the following command.
Test-SPContentDatabase-Name “name of content database”-webapplication “URL of webapplication”.
7.Now go to sql server and delete the database manually.
8.Now restore the content data base manually.
9.Now we need to attach the resstored content database by using following command.
Mount-SpContentDatabase-Name “Database name”-webapplication “URL of webapplication”.
Now we can get following error like”Upgrade completed with following errors”.
Finally Migration has been completed successfully.