SQL Server Performance

Upgrading from Standard to Enterprise Edition

Discussion in 'SQL Server 2005 General Developer Questions' started by deepu832002, Jan 30, 2007.

  1. deepu832002 New Member

    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
  2. MohammedU New Member

    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
  3. deepu832002 New Member

    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
  4. MohammedU New Member

    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
  5. deepu832002 New Member

    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
  6. jackdoug New Member

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

    SKUUPGRADE=1
  7. MohammedU New Member

    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
  8. satya Moderator

    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.
  9. amara Member

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

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

    satya,
    Could you please give the syntax
  12. satya Moderator

Share This Page