Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
scootermcfly
Yak Posting Veteran
66 Posts |
 Posted - 2002-03-18 : 07:45:49
|
| I would like to upgrade a couple of my servers from Standard Edition to the Enterprise edition.If I buy the Enterprise Edition, is there an 'upgrade' that I can apply to the current SQL Server, or should I uninstall SQL completely and reinstall the Enterprise Edition?I am figuring on unloading my data, scripting everything, uninstall current version, install new verion, load data back to SQL.Reason for the upgrade; I have between 4 and 8 GB of memory in some of these machines and would like to use as much as I can. With the current SQL Standard Edition, I can only use up to 2GB, and they are deicated SQL boxes.Thanks,Scooter McFly |
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2002-03-18 : 11:49:07
|
| I don't know of any upgrade paths. Looks like you are figuring correctly. You can either detach and attach your user databases or restore them from a backup. The detach/attach method is much faster.Jeff BanschbachConsultant, MCDBA |
 |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-03-18 : 12:44:14
|
| Actually,I think you can just run setup (Probably under advanced options) and upgrade the instance. I'm not sure about that, but I know you could in 7.0 I haven't tried it in 2000 but I can't imagine that that would be removed from the product.-Chad |
|
|
|
scootermcfly
Yak Posting Veteran
66 Posts |
Posted - 2002-03-18 : 13:29:14
|
| Chad,I just found the documnetation in BOL for upgrading the instance after reading your post.Thanks,Scooter McFly |
|
|
|
|
|
|
|
|
Standard to Enterprise Edition