SQL Server Feature Comparison (2005 – 2008)
SQL 2005 Feature Comparison
|
Express |
Workgroup |
Standard |
Enterprise |
Number of CPUs |
1 |
2 |
4 |
No Limit |
Max. RAM |
1 GB |
3GB |
OS Limit |
OS Limit |
64-bit support? |
|
|
X |
X |
Max. Database Size |
4GB |
No Limit |
No Limit |
No Limit |
Clustering / Mirroring |
|
|
X |
X |
Online Restore / Recovery |
|
|
|
X |
Management Studio |
|
X |
X |
X |
Job Scheduling (through Agent) |
|
X |
X |
X |
Import / Export |
|
X |
X |
X |
Web Services |
|
|
X |
X |
Much more also available at Microsoft SQL Server 2005 Features Comparison.
SQL 2008 Feature Comparison
|
Compact |
Express |
Standard |
Enterprise |
Number of CPUs |
1 |
1 (per server) |
4 |
No Limit |
Max. RAM |
OS Limit |
1GB |
OS Limit |
OS Limit |
64-bit support? |
|
|
X |
X |
Max. Database Size |
4GB |
4GB |
No Limit |
No Limit |
Clustering / Mirroring |
|
|
X |
X |
Online Restore / Recovery |
|
|
|
X |
Management Studio |
|
(tool) |
X |
X |
Job Scheduling (through Agent) |
|
|
X |
X |
Import / Export |
(tool) |
|
X |
X |
Web Services |
|
|
X |
X |
Detailed comparisons can be found between Compact and Express … and Standard and Enterprise