Risks of Updating to another edition

• Lou

  SSCrazy

  Points: 2929

  More actions

  November 1, 2016 at 2:13 pm

  #400972

  Hi Friends,

  According this documentation,

  https://msdn.microsoft.com/es-es/library/ms143393(v=sql.105).aspx

  Upgrade path from SQL Server 2005 Enterprise to SQL Server 2008 R2 Standard, is not a

  valid path, I have to update to SQL Server 2008 R2 Enterprise.

  But what if I do not go exactly to that way, what are I am lossing??

  I have validated and I am happy, apps are happy, CEO is happy.

  Thanks for your ideas

• ScottPletcher

  SSC Guru

  Points: 101091

  More actions

  November 1, 2016 at 2:38 pm

  #1910003

  You would at least have to remove anything that used a feature available in Enterprise Edition that's not also available in Standard Edition. No compressed tables, etc..

  But once that's done, I don't see why it wouldn't work.

  SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

• Jeff Moden

  SSC Guru

  Points: 1004312

  More actions

  November 1, 2016 at 3:58 pm

  #1910018

  luismarinaray (11/1/2016)

  ---

  Hi Friends,

  According this documentation,

  https://msdn.microsoft.com/es-es/library/ms143393(v=sql.105).aspx

  Upgrade path from SQL Server 2005 Enterprise to SQL Server 2008 R2 Standard, is not a

  valid path, I have to update to SQL Server 2008 R2 Enterprise.

  But what if I do not go exactly to that way, what are I am lossing??

  I have validated and I am happy, apps are happy, CEO is happy.

  Thanks for your ideas

  There is no way that I'd spend even a moment considering an update from any edition of 2005 to any edition of 2008R2. It's a total waste of time, IMHO.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)