Upgradation/migration steps for SharePoint 2010

Here in this article, I am going to explain steps for migrating contents from MOSS 2007 to SharePoint 2010 with "Database attach" method. You can find more detail information from below reference links.

1. Select any MOSS 2007 site for migration

2. Go to SQL Server Management studio and take backup of MOSS 2007 site database.

3. Move database backup file to SharePoint 2010 server manually.

4. Create blank Database from SQL Server Management studio into SharePoint 2010 server.

5. Restore MOSS 2007 backup file (step # 3) to newly created database into SharePoint 2010 server (make sure to select 'overwrite the existing database' option)

Some time if we are getting below error in SQL Server while restoring database then we need to try to perform same steps again and again for some more time. {Detach database, attach database, restore database}

ERROR:

Restore failed for Server “database server name”. (Microsoft.SqlServer.SmoExtended)

The backup set holds a backup of a database other than the existing 'database” database.

RESTORE DATABASE is terminating abnormally. (Microsoft SQL Server, Error: 3154)

6. Create new web application and site collection into SharePoint 2010 server.

7. Delete content database of newly created web application from going to SQL Server Management studio.

8. Add/Attach step # 5 database to new web application by below command

stsadm -o addcontentdb -url yourWebApplicationUrl -databasename yourDatabasename -databaseserver yourdatabaseServerName

9. After successful upgrade, it will generate upgrade log file which contains missing features, web parts names and other information which failed during upgrade.

10. Check migrated SharePoint 2010 site about data and pages.

11. Open web application settings from central admin to change site collection admin name (if source and destination web application have different user names)

12. If we want to see SharePoint 2010 look and feel in migrated site then we need to change visual upgrade from site settings (update all sites which make interface same like SharePoint 2010) – actually when we migrated site from MOSS 2007 to SharePoint 2010, at that time we have different master page in MOSS. In SharePoint 2010 system is using v4.master page.

Some points about how to verify migrated SharePoint 2010 site

1. Navigation links are coming correctly or not

2. Custom Image are not coming properly or not

3. Documents are migrated with its Meta data or not like uploaded and modified date/time stamp

4. Sub-site data are migrated with as it is navigation option or not (suppose if we have tree structure enable in source MOSS 2007 site then after migration it suppose to come with tree structure navigation only)

Perform pre-upgrade steps for SharePoint 2010: http://technet.microsoft.com/en-us/library/cc303417.aspx

Different Upgrade Methods in SharePoint 2010:

http://sharepoint2010blog.blogspot.com/2010/01/upgrade-methods-in-sharepoint-2010.html

http://sharepoint2010blog.blogspot.com/2010/01/how-to-upgrade-to-sharepoint-2010-using_21.html

MSDN SharePoint 2010 upgrade reference Links: http://technet.microsoft.com/en-us/library/cc263447.aspx

Very good link which describes about migrating to SharePoint 2010: http://mosshowto.blogspot.com/2010/06/migrating-to-sharepoint-2010.html