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.
|
See Also