Migration from MOSS 2007 to SharePoint 2010

First you have to prepare the new front-end and backend servers with SharePoint 2010 and SQL server 2008R2 to migrate the sites.

After that please follow below steps.

Step 1:

Stop all services of MOSS 2007

Cmd –> (Services.msc)

Step 2:

Copy MDF and LDF files of SQL server 2005 and paste in SQL server 2008 on below Path

C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA

Step 3:

Open SQL server 2008 management studio

Select the Databases –> Attach…

Step 4:

Click on Add… button as shown below screen.

Step 5:

Select MDF and LDF files and Click on OK.

Step 6:

Create one web application in SharePoint 2010 Sever.

Step 7:

Run the below command in command prompt as administrator to restore the Moss 2007 site database to SharePoint 2010 website.

Stsadm -o addcontentdb –url “http://server06:1405” -databasename “7755″

Here http://server06:1405 new SharePoint site URL and 7755 is database name.

Step 8:

Open web application now you will see still UI in 2007 format.

Step 9:

We have to upgrade UI design using Visual Upgrade option to get SharePoint 2010 UI as below.

Select Site Actions –> Click on Visual Upgrade.

Step 10:

From the below screen select 3^rd option Update the user interface and Click OK.

Step 11:

Now after upgrade we will see SharePoint 2010 UI as below.