Features Supported by the Editions of SQL Server 2008 R2

Use the following tables to determine which features are supported by the different editions of SQL Server 2008 R2.

Note

SQL Server is available in an Evaluation edition for a 180-day trial period. For more information, see the SQL Server Trial Software Web Site.

Note

For features supported by Evaluation and SQL Server Developer, see the SQL Server Datacenter feature set. The features supported by SQL Server Datacenter, SQL Server Developer, and Evaluation are the same.

To navigate to the table for a SQL Server technology, click on its link:

Scalability and Performance

High Availability

Virtualization Support

Replication

Enterprise Security

Single Instance RDBMS Management

Application and Multi-Instance Management

Management Tools

Development Tools

Programmability

Spatial and Location Services

Complex Event Processing (StreamInsight)

Integration Services

Integration Services-Advanced Adapters

Integration Services-Advanced Transforms

Data Warehouse

Analysis Services

Analysis Services-Advanced Analytic Functions

Data Mining

Reporting

Business Intelligence Clients

Master Data Services

Scalability and Performance

Feature Name

Datacenter

Enterprise

Standard

Web

Workgroup

Express with Advanced Services

Express with Tools

Express

Number of CPUs

OS maximum1

8

4

4

2

1

1

1

Maximum memory utilized

OS maximum

2 TB

64 GB

64 GB

4 GB

1 GB

1 GB

1 GB

Maximum database size

524 PB

524 PB

524 PB

524 PB

524 PB

10 GB

10 GB

10 GB

IA64 hardware support

Yes

Yes

Resource governor

Yes

Yes

Table and index partitioning

Yes

Yes

Parallel index operations

Yes

Yes

Parallel consistency checks (DBCC)

Yes

Yes

Enhanced read-ahead scan

Yes

Yes

Scalable shared databases

Yes

Yes

Direct query of index views using NOEXPAND hint

Yes

Yes

Yes

Automatic indexed view maintenance

Yes

Yes

Yes

Automatic use of indexed views by query optimizer

Yes

Yes

Distributed Partitioned Views

Yes

Yes

Partial. Distributed Partitioned Views are not updatable

Partial. Distributed Partitioned Views are not updatable

Partial. Distributed Partitioned Views are not updatable

Partial. Distributed Partitioned Views are not updatable

Partial. Distributed Partitioned Views are not updatable

Partial. Distributed Partitioned Views are not updatable

1 Support for Windows Server 2012 was added in a cumulative update for SQL Server 2008 SP3. Although Windows Server 2012 supports 64 physical processors and 640 logical processors, not all of the SQL Server 2008 or 2008 R2 services were retrofitted to support the additional processing capability of Windows Server 2012. Specifically, Analysis Services does not support more than 64 logical processors in either SQL Server 2008 or SQL Server 2008 R2.

High Availability

Feature Name

Datacenter

Enterprise

Standard

Web

Workgroup

Express with Advanced Services

Express with Tools

Express

Log shipping

Yes

Yes

Yes

Yes

Yes

Database mirroring2

Yes

Yes

Yes (single thread, synchronous only)

Witness only

Witness only

Witness only

Witness only

Witness only

Automatic corruption recovery from mirror

Yes

Yes

Yes

Log stream compression

Yes

Yes

Yes

Number of Failover clustering nodes

Operating system maximum1

Operating system maximum1

2 nodes

Backup compression

Yes

Yes

Yes3

Mirrored backups

Yes

Yes

Database snapshots

Yes

Yes

Fast recovery

Yes

Yes

Online indexing

Yes

Yes

Online page and file restore

Yes

Yes

Online configuration of Peer to Peer nodes

Yes

Yes

Hot add memory and CPU support

Yes

Yes

1 Windows Server 2003 supports a maximum of 8 failover cluster nodes. Windows Server 2008 supports a maximum of 16 failover cluster nodes.

2 Asynchronous database mirroring is supported only by SQL Server 2005 Enterprise Edition SP1 and later versions.

3 Backup compression for Standard edition of SQL Server is supported only in SQL Server 2008 R2 or higher versions.

Virtualization Support

Feature Name

Datacenter

Enterprise

Standard

Web

Workgroup

Express with Advanced Services

Express with Tools

Express

Hypervisor support

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Guest failover clustering support for virtualization

Yes

Yes

Yes

Hyper-V live migration

Yes

Yes

Yes

Application mobility

Yes

Yes

Replication

Feature Name

Datacenter

Enterprise

Standard

Web

Workgroup

Express with Advanced Services

Express with Tools

Express

Snapshot replication

Yes

Yes

Yes

Subscriber only

Yes

Subscriber only

Subscriber only

Subscriber only

Merge replication

Yes

Yes

Yes

Subscriber only

Restricted¹

Subscriber only

Subscriber only

Subscriber only

Transactional replication

Yes

Yes

Yes

Subscriber only

Restricted1

Subscriber only

Subscriber only

Subscriber only

SQL Server change tracking

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Publishing data from SQL Server to non SQL Server subscribers

Yes

Yes

Yes

Publishing data from Oracle to SQL Server

Yes

Yes

Peer to Peer replication

Yes

Yes

1 If an instance of Workgroup is used as a Publisher, it supports a maximum of 25 subscriptions to all merge publications, and five subscriptions to all transactional publications. It supports an unlimited number of subscriptions to snapshot publications.

Enterprise Security

Feature Name

Datacenter

Enterprise

Standard

Web

Workgroup

Express with Advanced Services

Express with Tools

Express

Windows Integrated Authentication (including Kerberos)

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Integration with Microsoft baseline security analyzer

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

C2 compliant audit mode1

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Common criteria compliance

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Data encryption and key management

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Module signing

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Transport Layer Security channel encryption

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Windows password policy support

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

User-schema separation

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Login triggers and connection endpoints

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Secure configuration through policy-based management

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

SQL Server audit (fine-grained auditing)

Yes

Yes

Transparent database encryption

Yes

Yes

Extensible key management

Yes

Yes

1 For a description of this feature see, c2 audit mode Option.

Single Instance RDBMS Management

Feature Name

Datacenter

Enterprise

Standard

Web

Workgroup

Express with Advanced Services

Express with Tools

Express

Policy-Based Management

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

PowerShell support

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

SQL Server Management Object (SMO)

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

SysPrep support1

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

SQL Server connection director

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Dedicated admin connection

Yes

Yes

Yes

Yes

Yes

Yes (Under trace flag)

Yes (Under trace flag)

Yes (Under trace flag)

Policy automation (check on schedule and change)

Yes

Yes

Yes

Yes

Yes

Maintenance plans

Yes

Yes

Yes

Yes

Yes

Database mail

Yes

Yes

Yes

Yes

Yes

Performance data collector

Yes

Yes

Yes

Yes

Yes

System Center Operations Manager Management Pack

Yes

Yes

Yes

Yes

Yes

Plan guides

Yes

Yes

Yes

Yes

.

User instances

Yes

Yes

Yes

1 SysPrep is supported for stand-alone instances of Database Engine and Reporting Services. For more information, see Considerations for Installing SQL Server Using SysPrep.

Application and Multi-Instance Management

Feature Name

Datacenter

Enterprise

Standard

Web

Workgroup

Express with Advanced Services

Express with Tools

Express

Support for data-tier application (DAC) operations - extract, deploy, upgrade

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Able to enroll for multi-instance management.

Yes1

Yes2

Yes

Yes

Yes

Multi-instance dashboard views and drilldowns

Yes

Yes2

Policy-based resource utilization evaluation

Yes

Yes2

1 Supports a SQL Server utility control point with a maximum of 200 managed instances of SQL Server. For more information, see Overview of SQL Server Utility.

2 Supports a SQL Server utility control point with a maximum of 25 managed instances of SQL Server. For more information, see Overview of SQL Server Utility.

Management Tools

Feature Name

Datacenter

Enterprise

Standard

Web

Workgroup

Express with Advanced Services

Express with Tools

Express

SQL Server Configuration Manager

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

SQL CMD (command prompt tool)

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

SQL Server Migration Assistant1

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

SQL Server Management Studio2

Yes

Yes

Yes

Yes

Yes

Yes

Yes

SQL Server Agent

Yes

Yes

Yes

Yes

Yes

Database Engine Tuning Advisor

Yes

Yes

Yes

Yes

Yes

SQL Server Profiler

Yes

Yes

Yes

Yes

Yes

No3

No3

No3

Analysis Services, PowerPivot IT operation dashboard

Yes

Yes

1 For more information about SQL Server Migration Assistant, see Migrate to SQL Server on the SQL Server web site.

2 For more information about SQL Server Management Studio Express see, SQL Server Management Studio Express.

3 SQL Server Workgroup, SQL Server Web, SQL Server Express, SQL Server Express Tools,and SQL Server Express Advanced can be profiled using SQL Server Standard and SQL Server Enterprise editions

Development Tools

Feature Name

Datacenter

Enterprise

Standard

Web

Workgroup

Express with Advanced Services

Express with Tools

Express

Microsoft Visual Studio Integration

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

IntelliSense (Transact-SQL and MDX)

Yes

Yes

Yes

Yes

Yes

Yes

No

(SSMS is not installed with this edition)

Business Intelligence Development Studio

Yes

Yes

Yes

Yes

Yes

Yes

SQL query, edit and design tools

Yes

Yes

Yes

Yes

Version control support

Yes

Yes

Yes

Yes

MDX edit, debug, and design tools

Yes

Yes

Yes

Programmability

Feature Name

Datacenter

Enterprise

Standard

Web

Workgroup

Express with Advanced Services

Express with Tools

Express

Entity Framework support

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Common language runtime (CLR) integration

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Native XML support

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

XML indexing

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

MERGE and UPSERT capabilities

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

FILESTREAM support

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Date and Time data types

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Internationalization support

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Full-text search

Yes

Yes

Yes

Yes

Yes

Yes

Specification of language in query

Yes

Yes

Yes

Yes

Yes

Yes

Service Broker (messaging)

Yes

Yes

Yes

Client only

Yes

Client only

Client only

Client only

XML/A support

Yes

Yes

Yes

Web services (HTTP/SOAP endpoints)

Yes

Yes

Yes

T-SQL endpoints

Yes

Yes

Yes

Spatial and Location Services

Feature Name

Datacenter

Enterprise

Standard

Web

Workgroup

Express with Advanced Services

Express with Tools

Express

Planar and geodetic data types

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Spatial indexes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Advanced spatial libraries

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Import/export of industry-standard spatial data formats

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Spatial results tab within SQL Server Management Studio

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Complex Event Processing (StreamInsight

Feature

Datacenter

Enterprise

Standard

Web

Workgroup

Express with Advanced Services

Express Tools

Express

Premium edition

Yes

Standard edition

Yes

Yes

For more information about the editions of StreamInsight, see Choosing a StreamInsight Edition.

Integration Services

Feature

Datacenter

Enterprise

Standard

Web

Workgroup

Express with Advanced Services

Express Tools

Express

SQL Server Import and Export Wizard

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Built-in data source connectors

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Integration Services designer and runtime

Yes

Yes

Yes

Basic tasks and transformations in addition to those used by the Import and Export Wizard

Yes

Yes

Yes

Log providers and logging

Yes

Yes

Yes

Basic data profiling tools

Yes

Yes

Yes

Programmable object model for extensibility

Yes

Yes

Yes

Integration Services - Advanced Adapters

Feature Name

Datacenter

Enterprise

Standard

Web

Workgroup

Express with Advanced Services

Express with Tools

Express

High performance Oracle destination

Yes

Yes

High performance Teradata destination

Yes

Yes

SAP BW source and destination

Yes

Yes

Data mining model training destination adapter

Yes

Yes

Dimension processing destination adapter

Yes

Yes

Partition processing destination adapter

Yes

Yes

Integration Services - Advanced Transforms

Feature Name

Datacenter

Enterprise

Standard

Web

Workgroup

Express with Advanced Services

Express with Tools

Express

Persistence (high performance) lookups

Yes

Yes

Data mining query transformation

Yes

Yes

Fuzzy grouping and lookup transformations

Yes

Yes

Term extractions and lookup transformations

Yes

Yes

Data Warehouse

Feature Name

Datacenter

Enterprise

Standard

Web

Workgroup

Express with Advanced Services

Express with Tools

Express

Auto-generate staging and data warehouse schema

Yes

Yes

Yes

Change data capture

Yes

Yes

Data compression

Yes

Yes

Star join query optimization

Yes

Yes

Automatic use of indexed views by query optimizer

Yes

Yes

Scalable read-only AS configuration

Yes

Yes

Proactive caching

Yes

Yes

Parallel query processing on partitioned tables and indices

Yes

Yes

Partitioned cubes

Yes

Yes

Distributed partitioned cubes

Yes

Yes

Analysis Services

Feature Name

Datacenter

Enterprise

Standard

Web

Workgroup

Express with Tools

Express with Advanced Services

Express

SQL Server Analysis Services backup

Yes

Yes

Yes

Dimension, attribute relationship, aggregate, and cube design

Yes

Yes

Yes

Translations

Yes

Yes

Yes

Personalization extensions

Yes

Yes

Yes

SQL Server PowerPivot for SharePoint

Yes

Yes

Analysis Services - Advanced Analytic Functions

Feature Name

Datacenter

Enterprise

Standard

Web

Workgroup

Express with Tools

Express with Advanced Services

Express

Financial aggregations

Yes

Yes

Partitioned cubes and distributed partitioned cubes

Yes

Yes

Custom rollups

Yes

Yes

Semi-additive measures

Yes

Yes

No1

Writeback dimensions

Yes

Yes

Linked measures and dimensions

Yes

Yes

Binary and compressed XML transport

Yes

Yes

Yes

Account intelligence

Yes

Yes

Perspectives

Yes

Yes

Scalable shared databases

Yes

Yes

1 The LastChild semi-additive measure is supported in Standard edition, but other semi-additive measures, such as None, FirstChild, FirstNonEmpty, LastNonEmpty, AverageOfChildren, and ByAccount, are not. Additive measures, such as Sum, Count, Min, Max, and non-additive measures (DistinctCount) are supported on all editions.

Data Mining

Feature Name

Datacenter

Enterprise

Standard

Web

Workgroup

Express with Tools

Express with Advanced Services

Express

Comprehensive set of data mining algorithms

Yes

Yes

Yes

Integrated data mining tools: wizards, editors, model viewers, query builder

Yes

Yes

Yes

Cross validation

Yes

Yes

Advanced configuration and tuning options for data mining algorithms

Yes

Yes

Support for pipeline data mining and text mining with Integration Services

Yes

Yes

Support for plug-in algorithms

Yes

Yes

Parallel model processing

Yes

Yes

Sequence prediction

Yes

Yes

Reporting

Feature Name

Datacenter

Enterprise

Standard

Web

Workgroup

Express with Advanced Services

Express with Tools

Express

Reporting Services memory limits

OS Maximum

OS Maximum

OS Maximum

4 GB

4 GB (x64) OS Maximum (x32)

4 GB

Allowed catalog DB SQL Server edition

SQL Server Standard, SQL Server Enterprise and SQL Server DataCenter

SQL Server Standard, SQL Server Enterprise and SQL Server DataCenter

SQL Server Standard, SQL Server Enterprise and SQL Server DataCenter

SQL Server Web

SQL Server Workgroup

SQL Server Express

Allowed data source SQL Server edition

All

All

All

SQL Server Web

SQL Server Workgroup

SQL Server Express

Report server

Yes

Yes

Yes

Yes

Yes

Yes

Report Designer

Yes

Yes

Yes

Yes

Yes

Yes

Report Manager

Yes

Yes

Yes

Yes

Yes

Yes

Reports as data feeds

Yes

Yes

Yes

Yes

Yes

Yes

Enhanced gauges and charting

Yes

Yes

Yes

Yes

Yes

Yes

Maps and map layers

Yes

Yes

Yes

Yes

Yes

Yes

Custom authentication

Yes

Yes

Yes

Yes

Yes

Yes

Export to Excel, Word, PDF, and images

Yes

Yes

Yes

Yes

Yes

Yes

Role Based Security

Yes

Yes

Yes

Yes

Yes

Yes

Create Custom Roles

Yes

Yes

Yes

No (Fixed roles only)

No (Fixed roles only)

No (Fixed roles only)

Model support

Yes

Yes

Yes

Yes

Yes

Model Item Security

Yes

Yes

Yes

Infinite click-through

Yes

Yes

Yes

E-mail and file share subscriptions and scheduling

Yes

Yes

Yes

Report history, executing snapshots, and caching

Yes

Yes

Yes

SharePoint integration

Yes

Yes

Yes

Shared component library

Yes

Yes

Yes

Remote and non-relational data source support

Yes

Yes

Yes

Data source, delivery, and rendering extensibility

Yes

Yes

Yes

Report definition customization extension (RDCE)

Yes

Yes

Yes

Data-driven report subscriptions

Yes

Yes

Scale out deployment (Web farms)

Yes

Yes

Business Intelligence Clients

The following software client applications are available on the Microsoft Downloads center and are provided to assist you with creating business intelligence documents that run on a SQL Server instance. When you host these documents in a server environment, use an edition of SQL Server that is supported for that document type. The following table identifies which SQL Server edition contains the server features required to host the documents created in these client applications.

Feature Name

Datacenter

Enterprise

Standard

Web

Workgroup

Express with Advanced Services

Express with Tools

Express

Report Builder 3.0

Yes

Yes

Yes

Yes

Excel 2007 and Visio 2007 Add-in support

Yes

Yes

Yes

PowerPivot for Excel

Yes

Yes

Master Data Services

Feature Name

Datacenter

Enterprise

Standard

Web

Workgroup

Express with Advanced Services

Express with Tools

Express

Master Data Services database

Yes

Yes

Master Data Manager Web application

Yes

Yes

Master Data Services Web service

Yes

Yes

Note

Master Data Services is available on only the 64-bit editions of SQL Server 2008 R2 Datacenter and SQL Server 2008 R2 Enterprise.

 Stay Up to Date with SQL Server Install, and Upgrade information

For the latest downloads, articles, videos and troubleshooting information from Microsoft, as well as selected solutions from the community, visit the SQL Server Setup page

For automatic notification of these updates, subscribe to the RSS feeds available on the page.