upgrade SQL Express to SQL STD question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sg - 10 Jul 2008 13:53 GMT

Hi,

Last night I did upgrade SQL express to SQL std using command
setup.exe SKUUPGRADE=1. Then I applied SP1 and SP2. However I only did
database service upgrade and forgot the workstation components. Can I do this
after upgrading the database service and applied the sps.

Thanks in advance,
sg

Reply to this Message

Tom Moreau - 10 Jul 2008 14:01 GMT

You can apply a service pack to the tools separately.

Signature

Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau

Hi,

Last night I did upgrade SQL express to SQL std using command
setup.exe SKUUPGRADE=1. Then I applied SP1 and SP2. However I only did
database service upgrade and forgot the workstation components. Can I do
this
after upgrading the database service and applied the sps.

Thanks in advance,
sg

Reply to this Message

sg - 10 Jul 2008 14:21 GMT

Hi Tom,

Thanks for quick response.
What you meant is that I can upgrade SMO seperately without affecting
database engine. Because the database is standard edition, however, the SMO
is still express edition.
Then after upgrading tools, when applying service packs, it shouldn't affect
database engine, right?
This server is production, I'm a little worried.

Thanks,
Sarah

> You can apply a service pack to the tools separately.
>
[quoted text clipped - 8 lines]
> Thanks in advance,
> sg

Reply to this Message

Tom Moreau - 10 Jul 2008 14:53 GMT

When you did your SKU upgrade, you just upgraded the RDBMS, right? Not the
tools? If so, I believe you'll have to do the SKU upgrade on the tools,
then apply the SP.

Signature

Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau

> You can apply a service pack to the tools separately.
>
[quoted text clipped - 8 lines]
> Thanks in advance,
> sg

Reply to this Message

sg - 10 Jul 2008 15:12 GMT

Yes, you are right. I just want to make sure it shouldn't affect RDBMS.

Thanks so much,
Sarah

> When you did your SKU upgrade, you just upgraded the RDBMS, right? Not the
> tools? If so, I believe you'll have to do the SKU upgrade on the tools,
[quoted text clipped - 27 lines]
> > Thanks in advance,
> > sg

Reply to this Message