Compare Microsoft SQL 2014 by Editions
Extraordinary can offer you a choice of 5 different editions of Microsoft SQL 2014:
- Enterprise Edition for mission-critical applications and large scale data warehousing
- Business Intelligence Edition for premium corporate and self-service BI
- Standard Edition for basic database, reporting and analytics capabilities
- Web Edition, only available in SPLA program
- Express Edition, a license-free edition with limited features
MS SQL 2014 Editions at a Glance
|
Features |
Enterprise |
BI |
Standard |
Web |
Express |
|
CPUs |
OS maximum |
4 (or 16 cores) |
4 (or 16 cores) |
4 (or 16 cores) |
1 (or 4 cores) |
|
RAM |
OS maximum |
128 GB |
128 GB |
64 GB |
1 GB |
|
32-bit & 64-bit |
Yes |
Yes |
Yes |
Yes |
Yes |
|
DB Size |
524 PB |
524 PB |
524 PB |
524 PB |
10 GB |
|
Log Shipping |
Yes |
Yes |
Yes |
Yes |
No |
|
Backup Compression |
Yes |
Yes |
Yes |
No |
No |
|
Table And Index Partitioning |
Yes |
No |
No |
No |
No |
|
Resource Governor |
Yes |
No |
No |
No |
No |
|
Transparent Data Encryption |
Yes |
No |
No |
No |
No |
|
Replication |
Full |
Standard |
Standard |
Limited |
Limited |
|
SQL Server Agent |
Yes |
Yes |
Yes |
Yes |
No |
|
Centralised Multi-Server Management |
Yes |
Yes |
Yes |
Yes |
No |
|
Policy Based Configuration |
Yes |
Yes |
Yes |
Yes |
No |
|
Service Broker (Messaging) |
Yes |
Yes |
Yes |
No (client only) |
No (client only) |
|
Integration Services |
Full |
Standard |
Standard |
Limited |
Limited |
|
Import/Export Wizard |
Yes |
Yes |
Yes |
Yes |
Yes |
|
Analysis Services |
Full |
Full |
Standard |
No |
No |
|
Reporting Services |
Full |
Full |
Standard |
Limited |
No |
