Upgrade from 2005 to ???
-
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
-
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
-
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 recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
Thanks for your feedback!
-
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 -
Thanks again for your input.
DK
-
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.
-
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 $$.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com -
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 recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
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.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com -
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply