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
No comments:
Post a Comment
This blog has been moved to www.martinhatch.com
Note: only a member of this blog may post a comment.