Sharepoint 2007 to Sharepoint 2010 migration

If you're still using Sharepoint 2007 and want to migrate your sites to Sharepoint 2010 there is only two ways of doing this:

1. In-Place Upgrade - upgrades the whole SP Farm on the same machine,
2. Database Attach Upgrade - upgrade on the new machine detaching content databases from the old machine and attaching then to the new machine.

 Today, I'll demonstrate how to migrate a site to SharePoint 2010 using the database attach upgrade.

Step 1: Create new machine
Install Sharepoint 2010 on a new server and create new Web Application and new Site Collection there.

Step 2: Backup content database
On the old SP 2007 machine go to SQL Server Management Studio. Select your WSS_Content database, right click and select Tasks --> Back Up.

On the next screen, you can leave everything as it is, or you can enter your own Name and Destination where the backup will be saved. Click OK and Backup process will begin. 

Step 3: Copy database to the new machine
When backup process is over, copy that bak from old machines file system to the new machine (let's say to C:\temp).

Step 4: Install custom parts
If you have custom components, like Web Parts, Features, etc, on your old site, you need to deploy them to the new site now.

Step 5: Restore database on the new machine
On the new machine open SQL Server Management Studio. Right-click on Databases and select Restore Database.

Enter the new database name, making sure that you don't overwrite the existing content database. Select the Source and click OK to start.

Step 6: Remove existing content database
Navigate to central administration -->click on manage content databases --> select the web application you created for migration -->click on database --> check in the remove content database --> click OK.

Step 7: Add the restored database in the target site in Management Shell
Go to: Start --> All Programs --> Microsoft Sharepoint 2010 Products --> Sharepoint 2010 Management Shell.

Write command:
Stsadm.exe –o addcontentdb –url “enter your url” –databasename “enter your db name” 

Step 8: Restart IIS
Go to: Start --> All Programs --> Microsoft Sharepoint 2010 Products --> Sharepoint 2010 Management Shell.

Write command:
IISRESET 

Your Sharepoint Site is now migrated!