Wednesday, May 30, 2012

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

For previous steps follow my last blog(Part I)

Adding SharePoint 2007 database using Stsadm/power shell
Step7: We can now proceed and attach our restored SharePoint 2007 database via the following stsadm command line;
stsadm -o addcontentdb -url <URL> -databasename <database name>
In my instance, the command looked as follows;
stsadm -o addcontentdb -url http://hiredc987:1200 -databasename WSS_Content_4670
This will initiate the upgrade process as per the below screen capture.

Step8: You will eventually receive a message similar to the below advising that the upgrade was completed albeit with errors in my case.  You should review the upgrade log file which is quite extensive and lengthy, and sure enough the errors were all related to missing features etc.
 
Step9: We can now verify that the upgrade was completed successfully by first navigating back to Central Administration / Application Management / Manage content databases, which now displays the upgraded database under my designated Web Application.



Here is some PowerShell script that you may be need to enable visual upgrade option in your site collection. So for that we need to run this .bat file.

Batch file content :  



PowerShell -file (path)\EnableVisualUpgardeOptions.ps1
pause


Powershell file content :

Add-PsSnapin Microsoft.SharePoint.PowerShell

$Site=Get-SPWeb http://mydemoserver:prtno/sites/Development
$Site.UIversionConfigurationEnabled=$true;$Site.update();


Remove-PsSnapin Microsoft.SharePoint.PowerShell


Step10: We can verify WSS Content Database Upgrade Web application as shown below

Step11: Once changed the Visual Upgrade in this Web application, ribbon is displayed on top of the application as shown below screen.













Step12: Inherited WSS site permissions into SharePoint Foundation migration web application as shown below screen. If you want adding custom permission levels, click the permission levels manually. 





















Step13: Inherited WSS document library into SharePoint Foundation migration web application as shown below screen. If you want adding new documents in existing wss document library, click add document. 














Step14: Inherited WSS lists into SharePoint Foundation migration web application as shown below screen. If you want adding new items in existing wss lists, click adds new item. 












Step15: SharePoint foundation Site settings are displayed as shown below screen.