Upgrade Standard Edition to Enterprise

[krudisar]

Hi,
right now I'm using SQL2000 Std Edition. Our new application requires an OLAP Svcs to be installed. As I found in SQLBooksOnline HTTP access to OLAP cubes is available only in OLAPSvsc Enterprise Edition. Do I have to upgrade SQL Std Edition as well or it is possible to run OLAP Enterprise on top of SQL2000 Standard? Does anyone of you know about step-by-step guide how to move SQL2K Std to SQL Ent?

Thanks in advance for help

Regards
Karel

[skhanal]

You have to run SQL Enterprise setup to upgrade from Standard to Enterprise. See How To section of BOL for detail

[krudisar]

I know that this is possible, but I'm little bit scared about upgrading SQL2k Std SP3 with Enterprise version with no SP. As far as I know it is not possible to apply SP3 to a sql distribution point, is'n it?

Thanks for reply
Karel

[skhanal]

What do you mean by distribution point?

[krudisar]

Well, problem is that can not upgrade my SQL2K instalation files to SP3 before instalation. I mean integrate SP3 to SQL2K instalation files on CD.
Karel

[MAK]

why cant you upgrade and then install SP3 on it?

Do you think your box would be vulnerable so fast?

You can change the default port in the regostry and install sql server and SP.

[krudisar]

I don't think that my box will be vulnerable. I'm not sure whether master and msdb databases have the same format (or stucture) in SP3 and SP0. Did you already tried this scenario?
Karel

[MAK]

Hello my friend.

If there is any change in master or msdb how it is going to affect your application?

What is your concern?

[krudisar]

In fact, I don't know. I've discussed this problem with a MS SQL specialist and he did not recommend me this scenario. So I'm trying to find if this is really so dangerous or whether anyone (you?) has already did it this way.
Karel

[sdives]

I may not understand all of the issues involved so forgive me if I over simplify but when I did an upgrade to Ent. edition I performed the following steps.

1)Backup databases
2)Detach User Databases
3)Uninstall Standard
4)Install Enterprise Edition
5)Apply sevice packs to same level as Std. (very important)
5)Restore Master and msdb
6)Reattach the User Databases
7)Then apply sp3 (I didn't do this step because sp3 was not out yet).

Be sure to follow the instructions in BOL for restoring the master db.

Sidney Ives

[krudisar]

Hi, it seems exactly what I was looking for. Thank you, I'l try it asap.

Do you have any experience on running OLAP Svc Enterprise on top of the SQL 2000 Standard?

Thanks
karel

[sdives]

Sorry, no experience running OLAP Svc Enterprise.

Sidney Ives
Database Administrator
Sentara Healthcare