The following has been reproduced from SQL Server 2008 SP1 Books Online:
Use the following tables to determine which features are supported by the various editions of Microsoft SQL Server 2008.
| Note: |
|---|
| SQL Server Enterprise is available in an Evaluation edition for a 180-day trial period. For more information about how to obtain an evaluation copy of SQL Server 2008, see this Microsoft Web site. |
Scalability
| Feature Name | Enterprise | Standard | Workgroup | Web | Express | Express Advanced |
|---|---|---|---|---|---|---|
| Partitioning | Yes | |||||
| Data compression | Yes | |||||
| Resource governor | Yes | |||||
| Partition table parallelism | Yes |
High Availability
| Feature Name | Enterprise | Standard | Workgroup | Web | Express | Express Advanced |
|---|---|---|---|---|---|---|
| Multi-instance support | 50 | 16 | 16 | 16 | 16 | 16 |
| Online system changes | Yes | Yes | Yes | Yes | Yes | Yes |
| Backup log shipping | Yes | Yes | Yes | Yes | ||
| Database mirroring | Yes (full) | Yes (safety full only) | Witness only | Witness only | Witness only | Witness only |
| Failover clustering | OS maximum1 | 2 nodes | ||||
| Dynamic AWE | Yes | Yes | ||||
| Failover without client configuration | Yes | Yes | ||||
| Automatic corruption recovery from mirror | Yes | Yes | ||||
| Database snapshots | Yes | |||||
| Fast recovery | Yes | |||||
| Online indexing | Yes | |||||
| Online restore | Yes | |||||
| Mirrored backups | Yes | |||||
| Hot add memory | Yes | |||||
| Online configuration of P2P nodes | Yes | |||||
| Hot add CPU | Yes | |||||
| Backup compression | Yes |
1Windows Server 2003 supports a maximum of 8 failover cluster nodes. Windows Server 2008 supports a maximum of 64 failover cluster nodes.
Security
| Feature Name | Enterprise | Standard | Workgroup | Web | Express | Express Advanced |
|---|---|---|---|---|---|---|
| C2 compliant tracing | Yes | Yes | Yes | Yes | Yes | Yes |
| SQL auditing foundation | Yes | Yes | Yes | Yes | Yes | Yes |
| Fine grained auditing | Yes | |||||
| Transparent database encryption | Yes | |||||
| ISV encryption (off-box key management) | Yes |
Replication
| Feature Name | Enterprise | Standard | Workgroup | Web | Express | Express Advanced |
|---|---|---|---|---|---|---|
| Merge replication | Yes | Yes | Subscriber only | Subscriber only | Subscriber only | Subscriber only |
| Transactional replication | Yes | Yes | Subscriber only | Subscriber only | Subscriber only | Subscriber only |
| Snapshot replication | Yes | Yes | Subscriber only | Subscriber only | Subscriber only | Subscriber only |
| SQL Server change tracking | Yes | Yes | Yes | Yes | Yes | Yes |
| Heterogeneous subscribers | Yes | Yes | ||||
| Oracle publishing | Yes | |||||
| P2P transactional replication | Yes |
Manageability
| Feature Name | Enterprise | Standard | Workgroup | Web | Express | Express Advanced |
|---|---|---|---|---|---|---|
| User instances | Yes | Yes | ||||
| Dedicated admin connection | Yes | Yes | Yes | Yes | Yes (Under trace flag) | Yes (Under trace flag) |
| Policy-based configuration | Yes | Yes | Yes | Yes | Yes | Yes |
| Policy-based management | Yes | Yes | Yes | Yes | Yes | Yes |
| Performance data collection and warehouse | Yes | Yes | Yes | Yes | ||
| Standard performance reports | Yes | Yes | ||||
| Plan guides | Yes | Yes | ||||
| Plan freezing for plan guides | Yes | Yes | ||||
| Policy-based best practices | Yes | Yes | ||||
| Multi-server policy-based management | Yes | Yes | ||||
| Distributed partition views | Yes | |||||
| Parallel index operations | Yes | |||||
| Automatic query-to-indexed-view matching | Yes | |||||
| Parallel database backup checksum check | Yes | |||||
| Database mail | Yes | Yes | Yes | Yes | ||
| Database migration tools | Yes | Yes | Yes | Yes | Yes | Yes |
Management Tools
| Feature Name | Enterprise | Standard | Workgroup | Web | Express | Express Advanced |
|---|---|---|---|---|---|---|
| SQL management objects (SMO) | Yes | Yes | Yes | Yes | Yes | Yes |
| SQL Configuration Manager | Yes | Yes | Yes | Yes | Yes | Yes |
| SQL CMD (command prompt tool) | Yes | Yes | Yes | Yes | Yes | Yes |
| SQL Server Management Studio | Yes | Yes | Yes | Yes (Express version) | Yes (Express version) | |
| SQL Profiler | Yes | Yes | Yes | Yes | ||
| SQL Server Agent | Yes | Yes | Yes | Yes | ||
| Database Tuning Advisor | Yes | Yes | Yes | Yes | ||
| Microsoft Operations Manager Pack | Yes | Yes | Yes | Yes |
Development Tools
| Feature Name | Enterprise | Standard | Workgroup | Web | Express | Express Advanced |
|---|---|---|---|---|---|---|
| Microsoft Visual Studio Integration | Yes | Yes | Yes | Yes | Yes | Yes |
| SQL query and edit and design tools | Yes | Yes | Yes | |||
| Intellisense (Transact-SQL and MDX) | Yes | Yes | Yes | |||
| Version control support | Yes | Yes | Yes | |||
| Business Intelligence Development Studio | Yes | Yes | ||||
| MDX edit, debug, and design tools | Yes | Yes |
Programmability
| Feature Name | Enterprise | Standard | Workgroup | Web | Express | Express Advanced |
|---|---|---|---|---|---|---|
| Common language runtime (CLR) integration | Yes | Yes | Yes | Yes | Yes | Yes |
| Native XML support | Yes | Yes | Yes | Yes | Yes | Yes |
| XML indexing | Yes | Yes | Yes | Yes | Yes | Yes |
| MERGE and UPSERT capabilities | Yes | Yes | Yes | Yes | Yes | Yes |
| FILESTREAM support | Yes | Yes | Yes | Yes | Yes | Yes |
| Date and Time data types | Yes | Yes | Yes | Yes | Yes | Yes |
| Internationalization support | Yes | Yes | Yes | Yes | Yes | Yes |
| Full-text search | Yes | Yes | Yes | Yes | Yes | |
| Specification of language in query | Yes | Yes | Yes | Yes | Yes | |
| Service broker (messaging) | Yes | Yes | Yes | Client only | Client only | Client only |
| XML/A support | Yes | Yes | ||||
| Web services (HTTP/SOAP endpoints) | Yes | Yes |
Spatial and Location Services
| Feature Name | Enterprise | Standard | Workgroup | Web | Express | Express Advanced |
|---|---|---|---|---|---|---|
| Spatial indexes | Yes | Yes | Yes | Yes | Yes | Yes |
| Geodetic data type | Yes | Yes | Yes | Yes | Yes | Yes |
| Advanced spatial libraries | Yes | Yes | Yes | Yes | Yes | Yes |
| Standards-based spatial support | Yes | Yes | Yes | Yes | Yes | Yes |
Integration Services
| Feature | Enterprise | Standard | Workgroup | Web | Express | Express Advanced |
|---|---|---|---|---|---|---|
| SQL Server Import and Export Wizard with basic sources and destinations and Execute SQL task | Yes | Yes | Yes | Yes | Yes | Yes |
| Integration Services runtime | Yes | Yes | Yes | Yes | Yes | Yes |
| Integration Services API and object model | Yes | Yes | Yes | Yes | ||
| SSIS Designer including VSTA scripting | Yes | Yes | ||||
| Integration Services service, wizards, and command prompt utilities | Yes | Yes | ||||
| Basic tasks and transformations | Yes | Yes | ||||
| Log providers and logging | Yes | Yes | ||||
| Data profiling tools | Yes | Yes | ||||
| Additional sources and destinations:Raw File source
XML source DataReader destination Raw File destination Recordset destination SQL Server Compact destination SQL Server destination |
Yes | Yes | ||||
| Advanced sources, transformations, and destinations:Data Mining Query transformation
Fuzzy Lookup and Fuzzy Grouping transformations Term Extraction and Term Lookup transformations Data Mining Model Training destination Dimension Processing destination Partition Processing destination |
Yes |
Data Warehouse Creation
| Feature Name | Enterprise | Standard | Workgroup | Web | Express | Express Advanced |
|---|---|---|---|---|---|---|
| Create cubes without a database | Yes | Yes | ||||
| Auto-generate staging and data warehouse schema | Yes | Yes | ||||
| Attribute relationship designer | Yes | Yes | ||||
| Efficient aggregation designers | Yes | Yes |
Data Warehouse Scale and Performance
| Feature Name | Enterprise | Standard | Workgroup | Web | Express | Express Advanced |
|---|---|---|---|---|---|---|
| Change data capture | Yes | |||||
| Star join query optimization | Yes | |||||
| Scalable read-only AS configuration | Yes | |||||
| Proactive caching | Yes | |||||
| Auto parallel partition processing | Yes | |||||
| Partitioned cubes | Yes | |||||
| Distributed partitioned cubes | Yes |
Multi-Dimensional Analytics
| Feature Name | Enterprise | Standard | Workgroup | Web | Express | Express Advanced |
|---|---|---|---|---|---|---|
| SQL Server Analysis Services service | Yes | Yes | ||||
| SQL Server Analysis Services backup | Yes | Yes | ||||
| General performance/scale improvements | Yes | Yes | ||||
| Dimension, attribute relationship, aggregate, and cube design improvements | Yes | Yes | ||||
| Personalization extensions | Yes | Yes | ||||
| Financial aggregations | Yes | |||||
| Partitioned customers | Yes | |||||
| Custom rollups | Yes | |||||
| Semi-additive measures | Yes | |||||
| Writeback dimensions | Yes | |||||
| Linked measures and dimensions | Yes | |||||
| Binary and compressed XML transport | Yes | |||||
| Account intelligence | Yes | |||||
| Perspectives | Yes | |||||
| Analysis Services shared, scalable databases | Yes |
Data Mining
| Feature Name | Enterprise | Standard | Workgroup | Web | Express | Express Advanced |
|---|---|---|---|---|---|---|
| Standard algorithms | Yes | Yes | ||||
| Data mining tools: wizards, editors, query builders | Yes | Yes | ||||
| Cross validation | Yes | |||||
| Models on filtered subsets of mining structure data | Yes | |||||
| Time series: custom blending between ARTXP and ARIMA models | Yes | |||||
| Time series: prediction with new data | Yes | |||||
| Unlimited concurrent datamining queries | Yes | |||||
| Advanced configuration and tuning for algorithms | Yes | |||||
| Algorithm plug-in API | Yes | |||||
| Parallel model processing | Yes | |||||
| Time series: cross-series prediction | Yes | |||||
| Unlimited attributes for association rules | Yes | |||||
| Sequence prediction | Yes | |||||
| Multiple prediction targets for naïve Bayes, neural network, and logistic regression | Yes |
Reporting
| Feature Name | Enterprise | Standard | Workgroup | Web | Express | Express Advanced |
|---|---|---|---|---|---|---|
| Report server | Yes | Yes | Yes | Yes | Yes | |
| Report Designer | Yes | Yes | Yes | Yes | Yes | |
| Report Manager | Yes | Yes | Yes | Yes (Report Manager) | Yes (Report Manager) | |
| Role-based security | Yes | Yes | Yes (Fixed roles) | Yes (Fixed roles) | Yes (Fixed roles) | |
| Ad-hoc reporting (Report builder) | Yes | Yes | Yes | |||
| Word export and enhanced text formatting | Yes | Yes | Yes | Yes | Yes | |
| Enterprise-scale reporting engine | Yes | Yes | Yes | Yes | Yes | |
| IIS-agnostic report deployment | Yes | Yes | Yes | Yes | Yes | |
| Updated management tools | Yes | Yes | Yes | Yes | Yes | |
| Report definition customization extension (RDCE) | Yes | Yes | Yes | Yes | Yes | |
| SharePoint integration | Yes | Yes | ||||
| Enhanced SSRS gauges and charting | Yes | Yes | Yes | Yes | Yes | |
| Custom authentication | Yes | Yes | Yes | Yes | ||
| Export to Excel, PDF, and images | Yes | Yes | Yes | Yes | Yes | |
| Remote and non-relational data source support | Yes | Yes | ||||
| E-mail and file share delivery | Yes | Yes | ||||
| Report history, scheduling, subscriptions, and caching | Yes | Yes | ||||
| Data source, delivery, and rendering extensibility | Yes | Yes | ||||
| Scale out (Web farms) | Yes | |||||
| Infinite click-through | Yes | |||||
| Data-driven subscriptions | Yes | |||||
| Reporting Services memory limits | Unlimited | Unlimited | 4 GB | 4 GB | 4 GB |