Post reply

How to upgrade SQL 2008 Standard to Enterprise?

  • March 17, 2010 at 4:12 am

    #220003

    Hi everyone,

    I have an issue migrating SSRS from SQL 2005 Ent to SQL 2008 Standard.

    How does one upgrade SQL 2008 Standard to Ent edition?

    We are licensed for both

  • March 17, 2010 at 7:30 am

    #1135214

    Have you tried just running the setup program?

    If so, did you encounter problems?

    There really aren't too many details in your question...

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi

  • March 17, 2010 at 8:01 am

    #1135239

    Hi,

    Basically need to upgrade my existing SQL 2008 Standard edition to Enterprise edition.

    I came across the Upgrade the Edition for SQL 2008 and this seems like the right place to do it?

    or...

    Do I start the upgrade from the Enterprise edition CD?

  • March 17, 2010 at 8:22 am

    #1135263

    avanzyl (3/17/2010)

    Basically need to upgrade my existing SQL 2008 Standard edition to Enterprise edition.

    :blink: I thought you were going from 2005 Enterprise to 2008 Standard?

    Probably best to decide on that first...

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi

  • March 17, 2010 at 8:26 am

    #1135270

    1) Initial issue migrating 2005 Reporting services DB's to 2008

    2) Googled the issue - seems I need to upgrade my existing 2008 Standard to Enterprise edition BEFORE moving SSRS to the new box

    3) Hence my question - How does one upgrade 2008 Standard to 2008 Enterprise?

    Good enough place to start?

  • March 17, 2010 at 8:32 am

    #1135276

    You have to reinstall using the command prompt methos with a parm of SKUUPGRADE=1

    ie. setup.exe" INSTANCENAME=instancename SKUUPGRADE=1 /qn

    Note:

    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.

    Tim White

  • March 17, 2010 at 8:34 am

    #1135278

    I recently upgraded from SQL 2005 standard to Enterprise and was as simple as running the setup from the command promp with the SKUUPGRADE=1 flag.

    http://msdn.microsoft.com/en-us/library/ms144259.aspx#Upgrade

    I assume 2008 is similar, remember to backup all your databases first.

  • March 17, 2010 at 8:34 am

    #1135279

    Many thanks Tim & SteveB

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply