SQL Server Setup Help | |
Features Supported by the Editions of SQL Server 2008 | |
See Also |
Overview of SQL Server Installation > |
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 |
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 |