Solved

SBS2008 and Sharepoint Foundation migration from WSS3.0

Posted on 2010-09-07
3
1,023 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
  • 2
3 Comments
 
LVL 57

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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

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 Detach & Attach 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.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

831 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