Solved

SBS2008 and Sharepoint Foundation migration from WSS3.0

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

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

New My Cloud Pro Series - organize everything!

With space to keep virtually everything, the My Cloud Pro Series offers your team the network storage to edit, save and share production files from anywhere with an internet connection. Compatible with both Mac and PC, you're able to protect your content regardless of OS.

Question has a verified solution.

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

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In this article I will describe the Copy Database Wizard 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.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

911 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now