SQL Server Performance Forum – Threads Archive

Upgrading from Standard to Enterprise Edition

hi I would like to know how to upgrade the SQL SERVER 2005 STANDARD EDITION TO SQL SERVER ENTERPRISE EDITION ON 64 BIT, without un-installing the SQL SERVER 2005 STANDARD EDITION. Let me know, as early as possible Thanks
Sandeep Boggavarapu

I have not done this on 64 bit…It is the same as 32 bit… Simply run the setup and it will identify the existing installation, and will run an upgrade check. It will then let you know if the upgrade is possible or not. If the upgrade path is supported, simply go through the setup wizard and it will automatically upgrade the already installed instance of stad. edition http://msdn2.microsoft.com/en-us/library/ms143393.aspx
http://msdn2.microsoft.com/en-us/library/ms143689.aspx
MohammedU.
Moderator
SQL-Server-Performance.com

Hi MohammedU, Thanks for your reply, But actually i already gone through those links, but it doesn’t give me correct information.

quote:Originally posted by MohammedU I have not done this on 64 bit…It is the same as 32 bit… Simply run the setup and it will identify the existing installation, and will run an upgrade check. It will then let you know if the upgrade is possible or not. If the upgrade path is supported, simply go through the setup wizard and it will automatically upgrade the already installed instance of stad. edition http://msdn2.microsoft.com/en-us/library/ms143393.aspx
http://msdn2.microsoft.com/en-us/library/ms143689.aspx
MohammedU.
Moderator
SQL-Server-Performance.com

Thanks
Sandeep Boggavarapu

I did many times on 2000 it was simple upgrade…. If you have a test server… first upgrade test to test the upgrade…
MohammedU.
Moderator
SQL-Server-Performance.com

Actually i am facing the probelm in the Client M/c whr I can’t Test it like that. To test on my local m/c, i am having only edition i.e., Enterprise Edition, only client is having both the editions and he asked us to resolve. I am trying to get the steps to follow to upgrade the edition, I tried to upgrade with some of the options like 1. i continued to install the enterprise edition(with out un-installing the standard edition), but after some time it is specifying a probelm related to the Instance (i.e., Already Instance has been created) 2. I went to Add/Remove programs and click on the CHANGE for the MS SQL 2005, At that time it is specifying the probelm related to the Installaion Media even the DVD has been placed in the Drive. 3. Right now i totally un-installed all the SQL related components by using some other Microsoft Tool, and tried to install, now also i am facing same probelm related to the Instance (i.e., Already Instance has been created) Now I am not able to under stand what I have to do. If you can, Please Help me in this Regard. Specifications are: SQL SERVER 2005 STANDARD EDITION 64 BIT — SQL SERVER 2005 ENTERPRISE EDITION 64 BIT OPERATING SYSTEM — WINDOWS SERVER 2003 WITH SERVICE PACK 1 Thanks
Sandeep Boggavarapu

Using the command prompt run SQL 2005 setup with the following parameter: SKUUPGRADE=1

If you use the SKUUPGRADE parameter, Setup will remove all hotfix and service pack updates from the SQL Server instance being upgraded. Once the edition upgrade is complete, you must reapply all hotfix and service pack updates.
MohammedU.
Moderator
SQL-Server-Performance.com

3. Right now i totally un-installed all the SQL related components by using some other Microsoft Tool, and tried to install, now also i am facing same probelm related to the Instance (i.e., Already Instance has been created)

It seems you have already uninstalled the SQL standard edition then why not install the ENterprise edition afresh, if unable to then what was the error you are getting before performing such changes. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

where do I need to fill this SKUUPGRADE=1 parameter. Please help me

When running setup from command line, refer to the updated books online for more information.

satya,
Could you please give the syntax

Hmm, did you download latest Books online for SQL Server 2005? [:O]
http://msdn2.microsoft.com/en-us/library/ms144259.aspx on the web and to download & upgrade – http://sqlserver-qa.net/blogs/tools…able-for-download-update-your-local-copy.aspx

]]>