Solved

SBS2008 and Sharepoint Foundation migration from WSS3.0

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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

These days socially coordinated efforts have turned into a critical requirement for enterprises.
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...
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…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

713 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