none
Upgrade form Sql2008 Standard to sql 2008 Enterprise RRS feed

  • Question

  • ello,
    We have currently build new Server 2008R2 with 8 core CPU with 32 GB Memory and currently working to get license for sql server 2008R2 Enterprise edition.
    We have currently sql 2005 standard and planning to migrate to new server as mentioned above.

    1) If I upgrade 1st using sql standard edition and later upgrade to Enterprise with using 8 core CPU with 32 GB Memory will be ok?

    Can we upgrade form Sql2008 Standard to Enterprise Edition?
    Let say we have sql 2008/sql 2008R2 already running and I would like to upgrade to sql 2008/sql 2008R2 Enterprise Edition.
    Is it just upgrade instance wizard I have to follow?
    Reading from the articles, little confused that is it we need to do another backup/restore too?
    If I install just cd and run the upgrade Instance wizard will be work or any other procedure I have to follow?
    I think I just need to restart the service and server, correct?

    2) I have another question is that if I download from the technet for testing then if I have to upgrade it using production licensed key, can we do and is it the same way?

    option 1) I mean if I start to use TechNet for testing
    and then later upgrading license key to a production will work,
    right?

    option 2) And I start to begin migration using sql 2008 standard
    and at a later date upgrade to Enterprise (it will be 8 core pocessors and 32 GB
    MEM) will work also?

    Thanks,

     

    Monday, August 5, 2013 8:59 PM

Answers

  • Please post your question in the "Setup & Upgrade" forum.

    In answer to your question, all you need to do is run the "Edition Upgrade".

    Please see: http://msdn.microsoft.com/en-us/library/cc707783(v=sql.100).aspx

    Monday, August 5, 2013 9:21 PM
  • Hi poratips,

    According to the Hardware and Software Requirements for Installing SQL Server 2008, we can upgrade from Standard to Enterprise Edition of SQL Server 2008 under 8 core CPU with 32GB Memory. And we can upgrade the SQL Server edition by following the wizard. In order to avoid some wrongs in the worse possible scenario, we’d better take full backups of your databases and restart SQL Server services after upgrading SQL Server edition.

    About the issue of license key, we need to purchase a license key for the new version. Furthermore, you can call 1-800-426-9400, Monday through Friday, 6:00 A.M. to 6:00 P.M. (Pacific Time) to speak directly to a Microsoft licensing specialist, and you can get more detail information from there. Worldwide customers can use the Guide to Worldwide Microsoft Licensing Sites to find contact information in their locations. 

    Microsoft Volume Licensing Worldwide here: 
    http://www.microsoft.com/licensing/worldwide.aspx

    Thanks,
    Katherine Xiong

    Tuesday, August 6, 2013 10:50 AM
    Moderator

All replies

  • Please post your question in the "Setup & Upgrade" forum.

    In answer to your question, all you need to do is run the "Edition Upgrade".

    Please see: http://msdn.microsoft.com/en-us/library/cc707783(v=sql.100).aspx

    Monday, August 5, 2013 9:21 PM
  • Hi poratips,

    According to the Hardware and Software Requirements for Installing SQL Server 2008, we can upgrade from Standard to Enterprise Edition of SQL Server 2008 under 8 core CPU with 32GB Memory. And we can upgrade the SQL Server edition by following the wizard. In order to avoid some wrongs in the worse possible scenario, we’d better take full backups of your databases and restart SQL Server services after upgrading SQL Server edition.

    About the issue of license key, we need to purchase a license key for the new version. Furthermore, you can call 1-800-426-9400, Monday through Friday, 6:00 A.M. to 6:00 P.M. (Pacific Time) to speak directly to a Microsoft licensing specialist, and you can get more detail information from there. Worldwide customers can use the Guide to Worldwide Microsoft Licensing Sites to find contact information in their locations. 

    Microsoft Volume Licensing Worldwide here: 
    http://www.microsoft.com/licensing/worldwide.aspx

    Thanks,
    Katherine Xiong

    Tuesday, August 6, 2013 10:50 AM
    Moderator
  • Thank you Tom.

    Thank you Katherine.

    I will call for more details.

    Tuesday, August 6, 2013 3:15 PM