March 19, 2010 at 8:36 am
We have several SQL05 Enterprise Edition servers that were setup before I started this job.
I have been tasked with moving allot of our DB's from SQL05 Enterprise edition to standard edition, for costs reasons.
How can I determine if my Db's will be okay moving from SQL05 Enterprise edition to SQL08 R2 Standard Edition (when released)?
March 19, 2010 at 8:45 am
The first thing will be to look at the Enterprise vs Standard features comparison on microsoft.com. If you're using any of the features that Enterprise has which Standard does not, you'll either have to work out how to stop using them or how to implement them through third-party software or in-house work.
The next thing to do would be set up a test environment with Standard edition on it, and copy the databases over to that. Then replay traces from the Enterprise servers onto those, and see what breaks, if anything.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 19, 2010 at 8:46 am
You need to idenify the features available in the enterprise edition of SQL 2005 that you make use of that are not available in SQL 2008 standard edition and work from there, these two resources may help you:
http://msdn.microsoft.com/en-us/library/cc645993.aspx --2008 features
http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx --2005 features
Gethyn Elliswww.gethynellis.com
March 19, 2010 at 8:48 am
Stupid question - If you've already paid for Enterprise licenses, and have it installed everywhere, are you really going to get money back by switching to Standard edition?
The Redneck DBA
March 19, 2010 at 8:50 am
Jason Shadonix (3/19/2010)
Stupid question - If you've already paid for Enterprise licenses, and have it installed everywhere, are you really going to get money back by switching to Standard edition?
They've paid for 2005 Enterprise and are moving to 2008 Standard. It'll cost less.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 19, 2010 at 8:52 am
GSquared (3/19/2010)
Jason Shadonix (3/19/2010)
Stupid question - If you've already paid for Enterprise licenses, and have it installed everywhere, are you really going to get money back by switching to Standard edition?They've paid for 2005 Enterprise and are moving to 2008 Standard. It'll cost less.
Doh! I missed the version change in the OP, and thought we were talking 2005 Ent to 2005 Std. Never mind!
The Redneck DBA
March 19, 2010 at 8:55 am
I'm not all that familiar with licensing but if you are moving up a version surely you have to pay for new licenses, you can't just use the 2005 licenses for 2008...hence using standard edition makes the 2008 licenses cheaper, so probably not a stupid question.
Gethyn Elliswww.gethynellis.com
March 19, 2010 at 8:56 am
The idea about playing back traces on a dev box is a good one.
Thanks everyone..
March 19, 2010 at 12:08 pm
GSquared (3/19/2010)
Jason Shadonix (3/19/2010)
Stupid question - If you've already paid for Enterprise licenses, and have it installed everywhere, are you really going to get money back by switching to Standard edition?They've paid for 2005 Enterprise and are moving to 2008 Standard. It'll cost less.
Cost will depend on their purchase agreement. It could be negligible depending on their contract (i.e. they purchased software assurance which I believe applies to 2k8r2).
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
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply