// // Leave a Comment

Step By Step guide to Upgrade from Windows SharePoint Services 3.0 to SharePoint Foundation 2010 & SharePoint 2013


I have upgraded my TFS Server 2010 to TFS server 2013, now I want to upgrade TFS SharePoint service from 3.0 to 2010. I am going to use new machine for SharePoint foundation 2010 (i.e.. I am going to use my TFS 2013 server).

For upgrade process I am going to use Database attach upgrade approach, then this method allows me to attach and upgrade the content databases from Windows SharePoint Services 3.0 to SharePoint Server 2010. This process upgrades the data in the content databases, but does not transfer any farm settings.

Note- For inplace upgrade you can only upgrade to SharePoint 2010 (any edition) if you have installed Windows SharePoint Services 3.0 or SharePoint 2007 Service Pack 2.

So lets get started,

Take backup of content Database of Sharepoint Services 3.0 & restore backed up database on New SQL server. Install Sharepoint 2010 on same machine or new machine. If installed on same machine uninstall WSS 3.0.

To mount backed up WSS 3.0 DB on new Sharepoint server run below command,

PS C:\Users\santosh> Mount-SPContentDatabase -Name tfs_WSS_content -WebApplication http://vmwareandme-tfs-01 -Updateuserexperience

OR

stsadm.exe -o addcontentdb -url http://vmwareandme-tfs-01/vmware-tfs -databasename tfs_WSS_Content -databaseserver vmwareandme-sql-02

stsadm.exe -o addpermissionpolicy -url http://vmwareandme-tfs-01/pune-tfs -userlogin vmwareandme\santosh -permissionlevel "full control"

Try to open Sharepoint URl

http://vmwareandme & check site content...

to view any errors,

PS C:\Users\santosh> Test-SPContentDatabase -name tfs_WSS_content -webapplication http://vmwareandme-tfs-01

I have get many webparts errors as in Sharepoint 2010 so many sharepoint templates were missing. So I have copied below three teamplates from old TFS 2010 server (i.e. C:\Program Files\Microsoft Team Foundation Server 2010\Tools\Templates\) to new TFS server & deploy it.

I have copied templated in my new sharepoint server c:\. To add templates to sharepoint server 2010 run below commands,

Stsadm -o addsolution -filename "C:\Microsoft.TeamFoundation.SharePoint.wsp"
Stsadm -o addsolution -filename "C:\TswaWebPartCollection.wsp"
Stsadm -o addsolution -filename C:\Microsoft.TeamFoundation.SharePoint.Dashboards.wsp.wsp

To deploy templates in sharepoint server 2010 run below commands

Stsadm -o deploysolution -name TswaWebPartCollection.wsp -local -force
Stsadm -o deploysolution -name Microsoft.TeamFoundation.SharePoint.wsp -local -force
Stsadm -o deploysolution -name Microsoft.TeamFoundation.SharePoint.Dashboards.wsp -local -force

Update -> If you are unable to view transferred TFS project sharepoint portal. Then open "Team Foundation Server Administration Console" and uninstall "Extension for Sharepoint Products".
After uninstalling "Extension for Sharepoint Products" restart server & again reinstall "Extension for Sharepoint Products".


Now you will be open TFS project sharepoint portal without any issues.

Upgrade from SharePoint 2010 to 2013
If you are planning to upgrade SharePoint 2010 to 2013 for your TFS server, process is very simple. After upgrading SharePoint from 3.0 to 2010 follow below process
1. take backup of database (i.e. tfs_wss_content). 
2. Uninstall SharePoint 2010
3. Install SharePoint 2013
4. Mount Sharepoint Content database for Sharepoint 2013

stsadm.exe -o addcontentdb -url http://vmwareandme-tfs-01/vmware-tfs -databasename tfs_WSS_Content -databaseserver vmwareandme-sql-02

stsadm.exe -o addpermissionpolicy -url http://vmwareandme-tfs-01/pune-tfs -userlogin vmwareandme\santosh -permissionlevel "full control"

 5. Then open "Team Foundation Server Administration Console" and uninstall "Extension for SharePoint Products".
After uninstalling "Extension for SharePoint Products" restart server & again reinstall "Extension for SharePoint Products".