Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SBS2008 and Sharepoint Foundation migration from WSS3.0

Posted on 2010-09-07
3
Medium Priority
?
1,032 Views
Last Modified: 2012-06-21
I found this guide Step-by-Step Guide to Migrating from Windows SharePoint Services 3.0 to Microsoft SharePoint Foundation 2010 on a server running Windows Small Business Server 2008
http://technet.microsoft.com/en-us/library/ff959273(WS.10).aspx#BKMK_Step2
I read it through to the end on the comment from Susan Bradley
http://supportweb.ciaops.net.au/blog/archive/2010/09/03/sharepoint-2010-migration-on-sbs-2008-released-from-microsoft.aspx
She mentions that point 10 in the guide is incorrect.
The major one is around section 10 whose heading is - Step 10: Connect the ShareWebDb database to SQL Server 2008 you’ll find that the contents are actually identical (word for word) with Step 12: Connect the ShareWebDb content database which appears to be a simple editing over sight.
Step 10 should in fact detail how to attach ShareWebDb to SQL 2008 which isn’t that hard but unless that is done first you are not going to be able to complete step 12 of actually connecting the database to SharePoint Foundation 2010.

I was going to test this process on a cloned machine, but not being a SQL genius, what is the correct process and commands for section 10.



0
Comment
Question by:davidfrank
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 59

Accepted Solution

by:
Cliff Galiher earned 1500 total points
ID: 33622524
The easiest way to do this is to open the SQL Management Studio (Express) and connect to the 2008 instance installed earlier in the documentation. From there, you can right click on instance in the left pane and choose "attach"
At that point, you'll be asked for the file location of the database to attach and finish the wizard. Errors are pretty well documented, but there shouldn't be any with a default SBS WSSv3 install, so it is all pretty painless.
With all of that said, I generally don't recommend upgrading unless there is a business requirement for it. Using it just becuase it is new and shiny usually causes more growing pains than it is worth. The navigation, edition and formatting differences are enough to cause training issues, and the new feature list of Foundation are fairly minimal. When comparing the larger server products, it is definitely a worthwhile upgrade, but not as much (there are edge cases) in the free versions.
-Cliff
 
0
 
LVL 1

Author Comment

by:davidfrank
ID: 33625083
Hi

Found my "idiots guide" to performing the task, thanks for pointing me in the right direction cliff.

Using a bit of background research I now understand the attach detach type function in sql a bit more.

Below has a step 10 guide.

http://supportweb.ciaops.net.au/blog/default.aspx

0
 
LVL 1

Author Closing Comment

by:davidfrank
ID: 33625092
Thanks
0

Featured Post

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question