Solved

SBS2008 and Sharepoint Foundation migration from WSS3.0

Posted on 2010-09-07
3
1,026 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 58

Accepted Solution

by:
Cliff Galiher earned 500 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 Admins - 7 Day Trial

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

Suggested Solutions

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
A quick step-by-step overview of installing and configuring Carbonite Server Backup.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

734 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