Post reply

Upgrade from 2005 to ???

  • December 19, 2011 at 9:12 am

    #253675

    Considering a move from 2005 to a newer version. Conventional wisdom would seem to point toward upgrading to 2008 r2, but should I consider waiting for the 2012 release? Has Microsoft demonstrated an ability to have their product ready at release, and not dependent on the first service pack?

    We use transactional replication for reporting, and an asynchronous mirroring for DR, but otherwise nothing out of the ordinary.

    Thanks,

    dk

  • December 19, 2011 at 11:11 am

    #1423227

    Whether the SQL 2012 is bug free or not, if I were you, I would still wait for their first Service pack before I use it in production. You might be interested in the SQL 2012 versions HADRON feature though.

    -Roy

  • December 19, 2011 at 12:23 pm

    #1423269

    I would wait for 2012. SQL 2008 was solid at release, some bugs but nothing earth-shattering, SQL 2008 R2 the same.

    Do note the licensing changes though...

    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

  • December 19, 2011 at 2:50 pm

    #1423314

    Thanks for your feedback!

  • December 19, 2011 at 3:34 pm

    #1423323

    Same opinion. I would wait for 2012 and go with that.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • December 20, 2011 at 12:12 pm

    #1423872

    Thanks again for your input.

    DK

  • December 20, 2011 at 1:22 pm

    #1423906

    I would wait too...I haven't had a chance to play around with Denali too much but it sounds like it has some cool new features.

    Which brings the next question, when is 2012 going to be released? Last I saw there was no confirmed date.

  • December 20, 2011 at 5:41 pm

    #1423965

    SQL 2012 is said to be first half of 2012. That's likely to be solid, but I don't know an exact date. I expect that it will be fairly solid for existing features. I might be careful of the newer AlwaysOn and other v1.0 items, but the existing engine and things in SQL 2008 R2 should be solid.

    However, licensing changes are big. I would highly consider purchasing a SQL 2008 R2 license, whether you upgrade or not now, and then use that as a conversion to 2012 since it could dramatically save you on the core licensing changes. You'd still have a second charge, but you might end up not paying as much since your socket license from SQL 2008 R2 will convert over to the existing cores in your machine, potentially saving you $$.

  • December 21, 2011 at 12:49 am

    #1424058

    Steve Jones - SSC Editor (12/20/2011)

    However, licensing changes are big. I would highly consider purchasing a SQL 2008 R2 license, whether you upgrade or not now, and then use that as a conversion to 2012 since it could dramatically save you on the core licensing changes. You'd still have a second charge, but you might end up not paying as much since your socket license from SQL 2008 R2 will convert over to the existing cores in your machine, potentially saving you $$.

    If I'm not mistaken, it's a 1 socket = 4 cores conversion unless you have software assurance and can negotiate with an account manager to convert at a higher ratio.

    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

  • December 21, 2011 at 10:36 am

    #1424364

    GilaMonster (12/21/2011)

    Steve Jones - SSC Editor (12/20/2011)

    However, licensing changes are big. I would highly consider purchasing a SQL 2008 R2 license, whether you upgrade or not now, and then use that as a conversion to 2012 since it could dramatically save you on the core licensing changes. You'd still have a second charge, but you might end up not paying as much since your socket license from SQL 2008 R2 will convert over to the existing cores in your machine, potentially saving you $$.

    If I'm not mistaken, it's a 1 socket = 4 cores conversion unless you have software assurance and can negotiate with an account manager to convert at a higher ratio.

    The datasheet is here: http://download.microsoft.com/download/5/9/5/59527629-ABD3-4C12-8117-DFABB86E2CFA/SQL2012_Licensing_Datasheet_USA_Dec2011.pdf

    It's a strange wording. A minimum of 4 core/socket license is the exchange, but it says "or cores in use". If you have a 6 or 8 core machine, or are planning on one, I'd look more closely at this and call MS. It doesn't say SQL 2008 R2, so I am assuming if you have SQL 2005 licenses, they will upgrade, but you'll have to ask MS.

  • December 21, 2011 at 2:12 pm

    #1424464

    You can take a look at this[/url] article by Brent Ozar.



    My blog

Viewing 11 posts - 1 through 10 (of 10 total)

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