SQL Server Performance Forum – Threads Archive
Any Plans to Downgrade versions with 2005?
With all the features and capabilities once reserved for Enterprise Edition now available in Standard, I am interested in your plans to downgrade EE to SE. Are you considering it? What are your concerns? Etc? Thanks in advance! TerryI’ve moved to relevant forum. Luis Martin
Moderator
SQL-Server-Performance.com Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
Leonardo Da Vinci Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte
All postings are provided “AS IS†with no warranties for accuracy.
Still there are few features lacking in SQL 2005 SE, such as Partitioning, Parallel index operations, indexed views, online indexing & restoring etc. So if you compare the scale from SQL 2000 SE to 2005 SE then there is a major difference. If not I wouldn’t think companies would go in downgrade path. Again this is dependant on envrionment to environment and not a standard trend in industry. I would like to know your concerns in going thru downgrading process, let us know your thoughts (requirement) too. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Be sure to find out if it’s possible to do that – I have heard (though it’s only second-hand, and might not be accurate) that MS will not allow moving an existing DB from 2000 EE to 2005 SE, either because the 2000 EE database might have incompatible features, or — the more paranoid rumor — because they don’t want to lose the money <img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ />.<br /><br />If a company is on EE just for the RAM, and no other reason, then 2005 SE seems mighty attractive from a cost point of view…<br /><br />OTOH, there ARE other features of both Enterprise Editions that are unique. 2005 SE does not actually have <i>all </i>the features.
If the Company has a stipulated agreement with Microsoft then there wouldn’t be much difference in the licensing costs (which is the only one as compared to SE & EE). I haven’t tried the same on SQL 2005 but I believe there is a consistent difference between SE & EE and on a large scale and longer term support EE has always upper hand on SE. That is why there is a difference grafted between these 2 editions, comparably I have seen much performance gain in EE than SE (at my end). Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
MS doesn’t have any plans to prohibit people from moving to STD from EE. You would just have to pay yet another license cost. While I haven’t recommended downgrading, there are some clients I have told to stay on standard vs. EE with 2005. It’s a good deal for them, since they didn’t use any of the advanced features except higher memory capacity. The STD pricing is higher in 2005. There’s a good reason for it. I would almost say Workgroup is more equivalent to the old 2000 standard edition in many ways. It’s very nice to have more options though. I think MS has done a good job going this direction. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.
Fair enough to accept when the company do not want to use the higher edition features. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>