How to Migrate Sharepoint from MSDE to SQL 2005

I have a SBS server 2003 that has the SBS verision of Sharepoint running, I
guess during the installation it installed MSDE and setup the DB on it. I
have later installed SQL 2005 as I was going to install MSCRM. What I would
like to do is move the Sharepoint DB from MSDE to SQL 2005 as I would like to
turn on Full Text Indexing.

Can someone point me in the right direction to do this? I've looked online
but never really found anything conclusive.

Regards
Habib

On Mon, 11 Feb 2008 06:28:02 -0800, Habib
<Habib@discussions.microsoft.com> wrote:

>I have a SBS server 2003 that has the SBS verision of Sharepoint running, I
>guess during the installation it installed MSDE and setup the DB on it. I
>have later installed SQL 2005 as I was going to install MSCRM. What I would
>like to do is move the Sharepoint DB from MSDE to SQL 2005 as I would like to
>turn on Full Text Indexing.

>Can someone point me in the right direction to do this? I've looked online
>but never really found anything conclusive.

This is version 2
http://technet2.microsoft.com/Window....mspx?mfr=true

On the Premium CD1
SQLINSTALLSTEPS.HTM

Microsoft Windows Small Business Server 2003 R2 Administrator's
Companion (Pro-Administrator's Companion) (Hardcover)
by Charlie Russel (Author), Sharon Crawford (Author)
Chapter 20 Usin SQL Server 2005
http://www.amazon.com/Microsoft-Busi.../dp/0735622809

jas

Jon;

I have installed SQL 2005 off the premium disk without issue's and i have
the MS CRM Db running there. I want to move my Sharepoint DB from MSDE to SQL
2005 in order to use full text indexing.

Habib

"Jon-Alfred Smith" wrote:

> On Mon, 11 Feb 2008 06:28:02 -0800, Habib
> <Habib@discussions.microsoft.com> wrote:
>
> >I have a SBS server 2003 that has the SBS verision of Sharepoint running, I
> >guess during the installation it installed MSDE and setup the DB on it. I
> >have later installed SQL 2005 as I was going to install MSCRM. What I would
> >like to do is move the Sharepoint DB from MSDE to SQL 2005 as I would like to
> >turn on Full Text Indexing.
>
> >Can someone point me in the right direction to do this? I've looked online
> >but never really found anything conclusive.
>
> This is version 2
> http://technet2.microsoft.com/Window....mspx?mfr=true
>
> On the Premium CD1
> SQLINSTALLSTEPS.HTM
>
> Microsoft Windows Small Business Server 2003 R2 Administrator's
> Companion (Pro-Administrator's Companion) (Hardcover)
> by Charlie Russel (Author), Sharon Crawford (Author)
> Chapter 20 Usin SQL Server 2005
> http://www.amazon.com/Microsoft-Busi.../dp/0735622809
>
> jas
>

On Mon, 11 Feb 2008 07:23:02 -0800, Habib
<Habib@discussions.microsoft.com> wrote:


>I have installed SQL 2005 off the premium disk without issue's and i have
>the MS CRM Db running there. I want to move my Sharepoint DB from MSDE to SQL
>2005 in order to use full text indexing.

Sorry. The link turned out be wrong. But the SQLINSTALLSTEPS.HTM
contains the information you need, the book as well.

See Upgrade the SHAREPOINT instance of WMSDE

jas



>"Jon-Alfred Smith" wrote:
>
>> On Mon, 11 Feb 2008 06:28:02 -0800, Habib
>> <Habib@discussions.microsoft.com> wrote:
>>
>> >I have a SBS server 2003 that has the SBS verision of Sharepoint running, I
>> >guess during the installation it installed MSDE and setup the DB on it. I
>> >have later installed SQL 2005 as I was going to install MSCRM. What I would
>> >like to do is move the Sharepoint DB from MSDE to SQL 2005 as I would like to
>> >turn on Full Text Indexing.
>>
>> >Can someone point me in the right direction to do this? I've looked online
>> >but never really found anything conclusive.
>>
>> This is version 2
>> http://technet2.microsoft.com/Window....mspx?mfr=true
>>
>> On the Premium CD1
>> SQLINSTALLSTEPS.HTM
>>
>> Microsoft Windows Small Business Server 2003 R2 Administrator's
>> Companion (Pro-Administrator's Companion) (Hardcover)
>> by Charlie Russel (Author), Sharon Crawford (Author)
>> Chapter 20 Usin SQL Server 2005
>> http://www.amazon.com/Microsoft-Busi.../dp/0735622809
>>
>> jas
>>