UPGRADE SQL server express SP1 editio to "SSE Advanced Services S

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

db - 25 Mar 2008 16:04 GMT

Hi

We have installed "SQL server express edition SP1" on one of my test box. W
e have created a test databases and many procedures on the box. The
application we are developing require full test search capabilities. Now the
problem is that full text search is not available on this version but
available on "SQL Server Express edition with Advanced Services SP1".

Is there an upgrade available by which we can upgrade "SQL server express
edition SP1" to "SQL Server Express edition with Advanced Services SP1". What
is the best way to do this??

Signature

ontario, canada

Reply to this Message

Aaron Bertrand [SQL Server MVP] - 25 Mar 2008 16:21 GMT

Not that I know of. It shouldn't take an inordinate amount of time to:

(a) backup or detach your database(s),
(b) remove the existing Express instance,
(c) install the edition you need,
(d) and then restore or attach your database(s).

> Hi
>
[quoted text clipped - 10 lines]
> What
> is the best way to do this??

Reply to this Message

db - 25 Mar 2008 16:50 GMT

Thanks Aaron

So there is no upgrade available for "SQL server express edition SP1" to
"SQL Server Express edition with Advanced Services SP1" which I can download
from microsoft site.

Signature

ontario, canada

> Not that I know of. It shouldn't take an inordinate amount of time to:
>
[quoted text clipped - 17 lines]
> > What
> > is the best way to do this??

Reply to this Message

Aaron Bertrand [SQL Server MVP] - 25 Mar 2008 16:54 GMT

> So there is no upgrade available for "SQL server express edition SP1" to
> "SQL Server Express edition with Advanced Services SP1" which I can
> download
> from microsoft site.

My answer hasn't changed... that's the same question you already asked. :-)

Reply to this Message