Wednesday, May 30, 2012

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
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
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.