Upgrading from standard to Enterprise edition of sql svr20..

Good morning,

I just want to know if I can just run setup for sql server 2000 Enterprise
to upgrade a standard edition install? Or would I have to uninstall SE and
then load the enterprise version? I have replication running on a couple of
DB's.

I hope this upgrade can be performed painlessly (like not having to
undo/redo replication -- uninstall SE). If there is pain, I think I will
just live with the SE version.

Thanks,
Rich

Rich wrote:
> Good morning,
>
> I just want to know if I can just run setup for sql server 2000 Enterprise
> to upgrade a standard edition install? Or would I have to uninstall SE and
> then load the enterprise version? I have replication running on a couple of
> DB's.
>
> I hope this upgrade can be performed painlessly (like not having to
> undo/redo replication -- uninstall SE). If there is pain, I think I will
> just live with the SE version.
>
> Thanks,
> Rich
>
>

You should be able to do an in-place upgrade, but I would suggest doing
this on a test server before doing it on a production box.


--
Tracy McKibben
MCDBA
http://www.realsqlguy.com