upgrade from 2008 sp1 to 2008 r2?

• Shawn Melton

  SSC-Insane

  Points: 24685

  More actions

  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

• Gail Shaw

  SSC Guru

  Points: 1004514

  More actions

  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