Sharepoint 2010 Installation & upgrade from 2007

In this article I will try to high light all the steps required for migrating from Sharepoint 2007 to 2010


1. In Place Migration -(This is only possible if your Sharepoint installation is already on 64bit environment.

2. Migrate Content DataBase

In both the above scenario first step required will be to check if your Sharepoint installation in ready for Upgrade

1. Run Pre-Updagrade Checker before migrating to 2010 to check for any potential issues 

Command for pre upgrade checker 

Stsadm –o preupgradecheckpreupgrade

It will generate report


Make Sure to fix all failed errors in the Report.

2. For Content Database Migration.

Write a batch file to back up all content databases in case you are moving Database Server from 32bit to 64bit environment   


 class=”hiddenSpellError” pre=””>osql -S ag-sql -E -Q ” BACKUP DATABASE ci_content_db1 TO DISK = ‘C:\C:\SharepointDB\ci_content_db1.bak’ ”


Attached is a sample batch file to take content database backup

Command to Restore Database

 class=”hiddenSpellError” pre=””>osql -S ag-sql -E -Q ” Restore From DATABASE ci_content_db1 FROM DISK = ‘C:\C:\SharepointDB\ci_content_db1.bak’ ”

attached is a sample batch file to restore content database.

Once does with restore of content database .

Lets install Sharepoint 2010 and then attach database with new feature to preview before update.

• Windows Server 2008 Service Pack 2
• Application Server Role, Web Server (IIS) Role
• Microsoft SQL Server 2008 Native Client
• Microsoft .NET Framework 3.5 SP1
• Windows PowerShell(TM) V2 (CTP3)
• Microsoft “Geneva” Framework Runtime
• Microsoft Sync Framework Runtime v1.0 (x64)
• Microsoft Chart Controls for Microsoft .NET Framework 3.5
• Microsoft Filter Pack 2.0
• Microsoft SQL Server 2008 Analysis Services ADOMD.NET

For this issue fix is right version of Geneva runtime Framework


I will update soon on how to preview your old sites with new changes