We help IT Professionals succeed at work.

WSS 3.0 upgrade to Windows SharePoint 2010 Enterprise

Hi expert,

does anyone know what is the proper procedure for upgrading the WSS 3.0 Sharepoint to the SharePoint 2010 Enterprise?

Here's my situation:
1) (currently) WSS 3.0 WFE is on VMware Server; SQL Database is located on a physical Server 2008 Windows/SQL
migrating WSS 3.0 to Enterprise Sharepoint 2010 to...

2) Installing Windows 2008R2 Server for SharePoint 2010 WFE on a VMware Server
3) SQL 2008 database for SharePoint 2010 will be on a physical box with Windows 2008R2
4) Moving WSS3.0 DB to SQL 2008 box (new)

I read about detaching the DB and reattaching but cannot do that as the WSS 3.0 is in production. Is it possible to do a back up and restore to new SQL? what are other recommendation>

Please advise.

Thank you.
Collin
Comment
Watch Question

Commented:
Backup the old sharepoint DB and restore on the new environment .  Double-check then do it for real and change the hostnames/DNS pointer to the new environment.
CollinMendozaIT Director

Author

Commented:
What DB you are referring to?
CollinMendozaIT Director

Author

Commented:
this only shows the general idea.
Ted BouskillSenior Software Developer
CERTIFIED EXPERT
Top Expert 2009
Commented:
It's not supported, however, you can try the following.

1) Backup the non-administration content databases
2) Restore a copy of them on the new database server
3) After installing SharePoint 2010 create a new web application with a temp content database name like Tmp_Content
4) Using SharePoint 2010 Central Admin, attach a restored content database from step #2
5) Remove the Tmp_Content using SharePoint 2010 Central
NOTE: If you are an advanced user you might have added multiple content databases on one web application so add them as well using step #4

Repeat steps #3 to #5 for each web application on the old server

Once again, this will not work for administration web applications
Ted BouskillSenior Software Developer
CERTIFIED EXPERT
Top Expert 2009
Commented:
Another important point is that SharePoint 2010 is radically different and the migrated web applications will never support all the newest features of SharePoint 2010 because it has to keep them backward compatible.
CollinMendozaIT Director

Author

Commented:
This sound like a complicated process. Old residue might get transffered. All I want is to back up the site content and restore it to the new content DB.
Ted BouskillSenior Software Developer
CERTIFIED EXPERT
Top Expert 2009
Commented:
You can't execute a typical SQL restore. It would destroy the web application because the database schema and configuration is different between versions of SharePoint.

It may sound complicated, however, that is the way it works.  You are welcome to contact Microsoft Support to confirm.
CollinMendozaIT Director

Author

Commented:
Thats what my concern is the structure of the SQL schema.
Ted BouskillSenior Software Developer
CERTIFIED EXPERT
Top Expert 2009
Commented:
Well if you do it the way I suggested then the schema is updated as best as possible to the new version.
CollinMendozaIT Director

Author

Commented:
I might go with another route. Thank you.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.