Post reply

Upgrade form Sql2008 Standard to Enterprise Edition

  • August 2, 2013 at 4:06 pm

    #280862

    Hello,

    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?

    Thanks,

  • August 2, 2013 at 4:49 pm

    #1638379

    Hi,

    There's a couple of upgrade options on the install wizard. Version upgrade and edition upgrade. These will achieve your goals in terms of upgrade.

    Always backup your databases before doing something like this.

    Check your licensed!!

  • August 3, 2013 at 3:41 pm

    #1638450

    Yes, you can upgrade from Standard to Enterprise by running the Setup wizard. A downgrade on the other hand, requires a reinstall as a recall.

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]

  • August 5, 2013 at 2:41 pm

    #1638742

    Thanks.

    What about for no#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?

  • August 5, 2013 at 2:45 pm

    #1638743

    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.

  • August 5, 2013 at 2:47 pm

    #1638745

    Yes, you can upgrade from Evaluation Editon to Standard Edition.

    Weether you can get your hands on Evaluation Edition for SQL 2008 R2, I don't know.

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]

  • August 16, 2013 at 8:48 pm

    #1642371

    Thanks Erland.

    Actually, I am asking to upgrade from sql 2008R2 evaluation to actual licensed product and want to make sure that it's just simple upgrade no DB restore or down time?

  • August 17, 2013 at 3:34 am

    #1642391

    poratips (8/16/2013)

    Actually, I am asking to upgrade from sql 2008R2 evaluation to actual licensed product and want to make sure that it's just simple upgrade no DB restore or down time?

    Yes, you can upgrade without DB Restore. You will have to accept downtime while the installation is running. But since you have Evaluation, downtime should not be an issue. (Grin.)

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]

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

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