Migrating SharePoint 2007 (Moss) site to SharePoint 2010 - Part-1

Hi Guys,

Here I am going to explain how to upgrade an existing MOSS site (SharePoint 2007) to SharePoint 2010.

Before going to do this we need to have some basic idea on the types of upgradation. Basically there are three types of approaches to upgrade in to Sharepoint 2010

1. In-place Upgrade

2. Database attach Upgrade

3. Hybrid Upgrade

Based on the environment and the other factors we will determine which approach is suitable for us. You can find more information regarding this in TechNet here).

Here I am explaining Database attach approach.These are the steps involved in this

1. Run the preupgradecheck in your MOSS environment

2. Backup the moss content database

3. Create a Site in Sharepoint 2010 server and remove its content database

4. Run Test-SPContentDatabase on 2010 server to analyze the mosscontentdb readiness to Upgradation

5. Add the moss contentdb to 2010 site

6. Visual upgrade to 2010 look and feel  (If you need)

7. Analyze If any errors related to customization ,missing files etc.

This is my MOSS site before upgradation.(Here Title: DemoSite07. Content Database :Wss_Content_5485)

The Prerequisites to Upgrade:

MOSS Server should have service pack2 Installed on it, without sp2 the preupgradecheck will not run.

Step 1:

The preupgradecheck command will give us the information about the Sharepoint 2007 Farm and the actions that need to be taken before we upgrade to sharepoint 2010. This is a nice tool provided by Microsoft, which will analyse and gives us the report in html too.

Here are the steps to use this.Open command prompt and go to the bin directory (here mine in C)

C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN>   stsadm –o preupgradecheck

  

 

More on Preupgradecheck rules find  here .If you get success message you can continue for the upgradation.

 

Step 2:

Take the Backup of your moss site's content database(WSS_Content_5485). 

Go to SQL server-->Select your contentdb(Wss_Content_5485)-->Tasks-->Backup.

 

  Select a location to keep your backup.

Now Copy this Backup and place in Sharepoint 2010 server.

Step 3:

Create a site in 2010 .(Here Title : Demo10, Content Db :Wss_Content_4311)

 

 

And remove the content database (Wss_Content_4311) attached to it.(through Sql or Central admin)

Central Administration-->Application Management-->Select your Web application-->Remove the content database

Click OK on above.And now restore your moss content database in to 2010.

Now go to sqlserver and restore your Moss Content Database (Wss_Content_5485) to the 2010 database Wss_Content_4311. (or you can restore to new database/any other existing , since anyhow we will attach this database tio our 2010 site through addcontentdb command in future.)

Go to sql -->Right Click on Database-->RestoreTo Database : select Wss_Content_4311.

Select from device and locate the path where your moss content database present and click Ok

Step 4

Now run the Test-SPContentDatabase PowerShell cmdlet to test your database( the above  restored moss contentdb) is ready to upgrade or not . It will tell you what are the missing files ,features, assemblies etc.

In 2010 server Go to Start Button -->All programs-->Microsoft SharePoint 2010 Products-->SharePoint 2010 Management Shell --> Run as Administrator(it is must otherwise gives u access denied error).

Run the below command in Powershell :

Test-SPContentDatabase  –Name    -WebApplication  

In Our case : Test-SpContentDatabase   -Name  Wss_Content_4311  -WebApplication  http://trainingsp2:4311.

It will give you all the information of missed files and assemblies etc..

Continuation to this is on my next post Migrate Moss site  to SharePoint 2010 site part-2

Migrating SharePoint 2007 (Moss) site to SharePoint 2010 - Part-2

Continuation to my previous post Migrate Moss site  to SharePoint 2010 site part-1

Here is the report of the Test-SPContentDatabase command

Here in my case I have created a event handler for the tasks using features in my Moss site but  I have not copied them to 2010 server so these are the errors/messages i got above

1. Missing Feature
2. MissingAssembly.
 

So I copied that feature and assembly from moss server to SharePoint 2010  server and then i got no errors.

Step 5:

Add the Moss content database(i.e earlier restored) to our 2010 site(Demo10).

Open command prompt and run this command

C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN>  stsadm -o addcontentdb -url -databasename 

Ours :stsadm –o addcontentdb  -url  http://trainingsp2:4311 –databasename Wss_Content_4311.

Above if you get 100% without any errors means the content database added to the site completely. If you get any errors check the log file at 14 hive and do the needful things (If u miss any customizations, files etc….).

With this my MOSS site is upgraded to 2010.  i.e My SharePoint 2010 site is ready with the Moss content database. 

Check it here

 Step 6 :

But the UI looks same as the Moss site . So if you want to change in to 2010 look and feel do the following settings

Then

Select the Update the user interface (before this you can preview the new UI by selecting second option above)

Then your MOSS site appears exactly  as the SharePoint 2010 site

With this you can say  your MOSS site is upgraded to SharePoint 2010.
 

Step 7:

If you want to see and analyze the upgrade status go for this location  

Central Admin-->Upgrade and Migration-->Check Upgrade Status.There you will find all the trails/attempts made for upgradation with the status error information.

Here if your Status is Failed . Go to the Log File specified over there and find the causes for it. If the Status : Succeeded, you can say your Upgradation is success without any errors.

Enjoy reading...!