Upgrading from 2005 to 2008

• Rem70Rem

  SSCertifiable

  Points: 6166

  More actions

  February 17, 2011 at 8:22 am

  #245674

  Hi,

  We are starting to talk about migrating from 2005 to 2008. The latest version available id 2008R2, right? Do we know what are the plans of Microsoft about getting a new version on the market?

  What is Denali?

  Thanks,

• parthi-1705

  SSCrazy Eights

  Points: 9277

  More actions

  February 17, 2011 at 8:36 am

  #1288273

  Rem70Rem (2/17/2011)

  ---

  Hi,

  We are starting to talk about migrating from 2005 to 2008. The latest version available id 2008R2, right? Do we know what are the plans of Microsoft about getting a new version on the market?

  What is Denali?

  Thanks,

  Hi,

  SQL Server 2008 R2 is the latest version released in the market with licence.You can just go the MS Site where you can see the cost and other details of the product.

  Denali is SQL Server 2011 version which was released last November 2010.MS has advice not to use Denali for Production,but we can use it in local development.

  Thanks
  Parthi

• WayneS

  SSC Guru

  Points: 95460

  More actions

  February 17, 2011 at 9:23 am

  #1288319

  parthi-1705 (2/17/2011)

  ---

  Rem70Rem (2/17/2011)

  ---

  Hi,

  We are starting to talk about migrating from 2005 to 2008. The latest version available id 2008R2, right? Do we know what are the plans of Microsoft about getting a new version on the market?

  What is Denali?

  Thanks,

  Hi,

  SQL Server 2008 R2 is the latest version released in the market with licence.You can just go the MS Site where you can see the cost and other details of the product.

  Denali is SQL Server 2011 version which was released last November 2010.MS has advice not to use Denali for Production,but we can use it in local development.

  Actually, "Denali" is the code name for the next version of SQL Server. It is in Microsoft's "Community Technology Preview" state - think of it as an alpha product. It has not been "Released to Manufacturing" (RTM) yet.

  Wayne
  Microsoft Certified Master: SQL Server 2008
  Author - SQL Server T-SQL Recipes

  ---

  If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

  ---

  Links:
  For better assistance in answering your questions
  Performance Problems
  Common date/time routines
  Understanding and Using APPLY Part 1 & Part 2

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  February 17, 2011 at 10:42 am

  #1288388

  parthi-1705 (2/17/2011)

  ---

  Denali is SQL Server 2011 version which was released last November 2010.MS has advice not to use Denali for Production,but we can use it in local development.

  Denali (aka SQL 11) is the next major version of SQL. It was announced in November last year, only one CTP has been announced and there is no official name yet (it is NOT currently called SQL Server 2011) and no release date has been announced.

  CTPs are licensed for non-production use only unless you are a TAP customer. Since lot of things are broken or half-working, you wouldn't want to put it into production anyway.

  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