how to migrate data of sharepoint 2007 site to sharepoint 2010 site through database attach deattach approach (Part1).

                      SharePoint 2007 Migration to SharePoint 2010

Requirements and prerequisites:

·          Destination Server: SharePoint 2010 database server must be 64-bit version and SQL Server 2008 SP1 with cumulative update 2.

·          Source Server: SharePoint 2007 must have SP2 and latest CU (Verify Oct 2009 MOSS/WSS SharePoint CU Installed in SharePoint Server 2007)

Please refer below link for above prerequisite upgrades

http://technet.microsoft.com/en-us/library/cc262485(office.14).aspx

Pre-upgrade check

·          The stsadm.exe command PreUpgradeCheck can be used to analyze the existing SP2007 site collections, looking for situations that could cause grief during an upgrade, such as customized (unghosted) artifacts, changes in database schemas, missing features and other potential issues and relevant information like Alternate Access Mappings(AAM) url’s, site definitions used and large lists. Please refer following link

http://technet.microsoft.com/en-us/library/cc262231(office.14).aspx

Attached WSS Database to SharePoint database using SQL server 2008

Step1: selected existing wss3.0 content database, as shown in below screen

 

Step2: once selected database and click backup option, as shown in below screen

 

Step3: click ok button. This backup file saved in particular folder, as shown in below screens

 

 

Restoring a copy of your SharePoint 2007 content database into SharePoint Foundation 2010

Step4: Right click on Databases and select Restore Database.
Select your source and destination as follows;

Click on Options and ensure you have selected Overwrite the existing database.

Click OK.
We should receive the following confirmation message once the database has been successfully restored.

 

Verifying the Content Database using Power shell Cmdlet:

Step5: The next tool that we will be using is the Test-SPContentDatabase Windows PowerShell cmdlet.  This cmdlet will test and verify that any custom components that are required for this content database has been installed and configured in the SharePoint 2010 environment.

Test-SPContentDatabase –Name <database name> -WebApplication <URL>

Launch the SharePoint 2010 Management Shell and type the above command, ensuring you have entered your Database Name and URL.

Test-SPContentDatabase –Name WSS_Content_4670 -WebApplication http://hiredc987:1200/default.aspx

The Test-SPContentDatabase is a great reporting tool that will list any missing setup files, web parts and provide you with information on how to remedy any errors.  It will also specify whether these missing features will block the upgrade from succeeding.

Removing Existing Content database using central admin web application

Step6: you can remove the existing attached database by clicking on the actual database name and then clicking on the “Remove content database” check box.

You will receive the above warning which is safe to ignore.  In this instance we are not deleting the actual database but disassociating it from the selected Web Application.

 Further steps, I will post in NEXT BLOG...(Part II)