Post reply

upgrade from 2008 sp1 to 2008 r2?

  • May 5, 2010 at 9:40 am

    #220414

    hi, i just don't get the difference between a sql 2008 sp1 (build 2531) and a new sql 2008 r2 (build 1600).

    1) is the 2008 sp1 better than the 2008 r2? wich one is the most "patched" or "updated".

    2) if i have a sql server 2008 sp1, do i have to "upgrade" it to 2008 r2? When i try it the "upgrade from sql 2000 or sql 2005 to sql 2008" option doesn't display the current 2008 sp1 instance.

    any help is welcome.

    thanks!!!

  • May 5, 2010 at 9:51 am

    #1162579

    (1) The newest version is always going to be the most "Patched/updated". There are a TON of new features in SQL 2008 R2. Just check out this site: What's New

    (2) Yes it would be an upgrade. This is the matrix for the support upgrade paths: Paths. You might also review the information on upgrading here

    Shawn Melton
    Twitter: @wsmelton
    Blog: wsmelton.github.com
    Github: wsmelton

  • May 5, 2010 at 10:02 am

    #1162591

    Do note that R2 is not a patch or service pack. It's a new version of SQL that you will have to purchase licences for if you want to use.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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