Home > SharePoint 2010, SharePoint Administration > Migrating MOSS 2007 Site Collection to SharePoint 2010

Migrating MOSS 2007 Site Collection to SharePoint 2010

I’m in the process of standing up a Pilot SP2010 farm here at work and I was tasked to migrate a Site Collection from our production MOSS 2007 farm to our Pilot SP2010 farm.  Simple right!  Well I did run into a few hurdles. 

Since my Site Collection on MOSS 2007 has its own contentdb I couldn’t simply just export the site collection via stsadm command and import it onto the SP2010 farm and call it a day.  I had to do a few extra steps.

Below are the steps I took to Migrate a MOSS 2007 Site Collection (with attached contentdb) to SharePoint 2010.

1.  First perform a full backup of the Site Collection contentdb on the MOSS 2007 SQL 2008 server.  Make sure you back up both the data and log files.
2.  Copy both the data and log files to the new SP2010 SQL 2008 server.
3.  Do a database restore of the MOSS2007 contentdb on the SP2010 SQL 2008 server. (Microsoft SQL Server Management Studio -> Right click Databases -> Select Restore -> Select the MOSS 2007 contentdb that was copied over).
4.  Next browse to your SP2010 portal site and create a new Site Collection.  (Site Actions -> New Site) choose any site template at this step, it doesn’t matter since it will be overwritten later, give the site a name preferably the same name it was used in MOSS 2007.  Click create.
5.  Remote or log into your SP2010 Central Administration Server and open a command prompt, and change directory to:  c:\program files\common files\microsoft shared\web server extensions\14\bin.  Notice in SP2010 the bin folder is now located in the 14 hive.
6.  At the command prompt run this stsadm command:  stsadm.exe -o addcontentdb -url <http://<portal>/<site collection> -databasename <name of contentdb restored in SP2010 SQL 2008 server>
7.  This will attach the contentdb to the Site Collection that was created in Step 4.  This process might take a little while depending on the size of the Contentdb.  You should see the progress percentage of completion as it progresses.  If everything is successful you should get a 100% completion, if there were errors it will indicate to check out the 14 hive logs for details.
8.  Now browse to your SP2010 portal site and navigate to the Site Collection you created.  If everything was successful you should now see the migrated Site Collection with its data.  But your Site Collection still has the MOSS 2007 look and feel to you, how do you fix this?
9.  Easy on your Site Collection Site, click “Site Actions” -> “Site Settings” -> “Modify All Site Settings” and under “Look and feel” click the “Title, description, and Icon” link.  At the bottom you should see three toggle buttons for Visual Upgrade (Use the previous user interface, Preview the updated user interface, and Update the user interface).
10.  If you click on the “Update the user interface” the MOSS 2007 Site Collection will convert to the look and feel of SP2010.  If you prefer the MOSS 2007 look and feel just toggle the “Use the previous user interface” button to switch back.

That’s it.  There you have it,  of course there might be a few things you have to clean up, but these steps worked for me when migrating a MOSS 2007 Site Collection to SharePoint 2010.

An added bonus.  If you wanted to toggle between the SP2010 and MOSS2007 look and feel from the SP2010 Site Actions menu you will have to download the SharePoint 2010 Toggle User Interface and install it onto your SP2010 farm.  You can get the SharePoint 2010 Toggle User Interface here:  http://sptoggleui.codeplex.com

I did however have some problems installing the SharePoint 2010 Toggle User Interface via the instructions on their site.  The solution deployed successfully but the feature never showed up for me to activate.  If you run across the same problems as me maybe you can follow my steps below, maybe they will help you.

1.  Download the ToggleSharePointUI.zip file and extract it to your SP2010 server.
2.  Next on your SP2010 server open up the SharePoint 2010 Management Shell (Powershell) and change directories to the location where you extracted the ToggleSharePointUI.  I put mine in the c:\ directory.  So cd c:\ToggleSharePointUi
3.  Next  run this command:  Add-SPSolution ToggleUserInterface.wsp
4.  After adding the solution you now want to deploy it and add it to the GAC.  So run this command:  Install-SPSolution -identity ToggleUserInterface.wsp -GACDeployment.  It should return no errors.
5.  Some .wsp solutions reguire you to include the -url when you deploy a solution, but for this case this .wsp contains no resources scoped for a web application and cannot be deployed to a particular web application so keep the -url attribute off.
6.  Now go back to your SP2010 portal site.  Navigate to “Site Actions” -> “Site Settings” -> “Site Actions” -> Click the “Manage site features” and you should now see the “Toggle SharePoint User Interface” feature.  Click the “Activate” button to active this feature.
7.  Now when you click “Site Actions” you should see the option to “Toggle Visual Mode” (it should be the last option).  If you click this your SP2010 site will toggle to look and feel like MOSS 2007.  If you click the option again it will revert back to SP2010.  Pretty neat feature, and can come into handy (especially if you are just getting used to SP2010).

Advertisements
  1. Steve
    April 23, 2013 at 7:27 pm

    When I do the stsadm command, it attaches the migrated content database alongside the original database, but with zero site collections in it. If i browse the site, it goes to the new but empty site. If i remove the original database, I get a string saying I’m connecting to IIS 7.5, but no site. What am I missing?

    • May 8, 2013 at 5:40 pm

      Hi Steve did you ever figure out the issue? If not let me know and I can try to assist.

  2. SPAdam
    July 30, 2013 at 2:42 pm

    Thanks for the wonderful article! SharePoint Migration is a complex process and has multiple stages starting from Planning to Post migratin fixes. In addition to the points discussed here, I used this great guide to Migrate from MOSS 2007 to SharePoint 2010 Step by Step:

    It covers:
    1. Pre-upgradecheck Reports and Fixes
    2. Step by Step instructions with screenshots to Backup Restore SQL Data
    3. Core Migration process – Creation on Web Applications and Attaching Databases
    4. Post migration fixes

    http://www.sharepointdiary.com/2011/09/migrate-from-moss-2007-to-sharepoint-2010.html#ixzz2aXUlFWKW

  3. November 9, 2014 at 7:40 pm

    Hi there, I wish for to subscribe for this blog to take most up-to-date updates, therefore where
    can i do it please help.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: