Denali – Day 4: Editions & Licensing
Here is a brief edition summary of Editions available for all sql server from 2005 to 2012.
|Sql Server 2005||
Sql Server 2008
Sql Server 2008 R2
Sql Server 2012
|Data Center Edition|
|Enterprise Edition||Enterprise Edition||Enterprise Edition||Enterprise Edition|
|Data Warehouse Edition||Business Intelligence|
|Standard Edition||Standard Edition||Standard Edition||Standard Edition|
|WorkGroup Edition||WorkGroup Edition||WorkGroup Edition|
|Developer Edition||Developer Edition||Developer Edition||Developer Edition|
|Web Edition||Web Edition||Web Edition|
|Compact Edition||Compact Edition||Compact Edition||Compact Edition|
|Express Edition||Express Edition||Express Edition||Express Edition|
As now from Denali, edition of sql server has been modified a bit, like it has three main editions, as Microsoft site has a great detailed information on it.
Enterprise Edition: This is the Major edition, which contains ALL features provided by sql server 2012(Engine, BI) everything. So Datacenter edition is also included in Enterprise edition.
Business Intelligence Edition:- BI Edition contains All the BI related features as well as all Standard Edition Features.
Standard Edition:- Contains Basic Functionality of Engine, BI.
Microsoft has changed the licensing from processor licenses to Core Based licensing.
- Core-based Licensing for Enterprise
- Server + CAL licensing for Business Intelligence
- Choice of core-based licensing or Server + CAL licensing for Standard
Aaron view on this-