Post reply

Upgrade from SQL 2005 Standard to 2008 R2 or Enterprise

  • November 26, 2013 at 9:03 am

    #100542

    Hello,

    I am running SQL 2005 Standard SP2 and would like to upgrade to SQL 2008 R2. The articles that I have read are giving mixed information. One article says that I can only upgrade to SQL 2008 Standard, but another article says that I can upgrade to 2008 Enterprise. Can someone verify which versions I can upgrade to?

    Thanks

  • November 26, 2013 at 11:37 am

    #1669230

    You could upgrade to either one (including 2008 R2 Standard or 2008 R2 Enterprise).

    However, you might consider that Mainstream Support for 2008 R2 will end 2014/07/08 which is just slightly over half a year from now...

    SQL2012 might be an alternative.

    The biggest question behind that would be: do you run any of your databases on your 2K5 system under 2000 compatiblity mode (80)?

    If so, an upgrade to 2012 could involve quite some work since comp mode 80 is no longer supported in SQL 2012...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • November 26, 2013 at 11:52 am

    #1669233

    Thanks very much for your response!

Viewing 3 posts - 1 through 2 (of 2 total)

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