Der Vollständigkeit halber ein Vergleich der verschiedenen Versionen des SQL Server 2012.
| Feature Name | Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Max Cap. Single Instance (SQL Server Database Engine) | OS maximum | Max of 4 Sockets or 16 cores | Max of 4 Sockets or 16 cores | Max of 4 Sockets or 16 cores | Max of 1 Socket or 4 cores | Max of 1 Socket or 4 cores | Max of 1 Socket or 4 cores |
| Max Cap. Single Instance (Analysis Services, Reporting Services) | OS maximum | OS maximum | Max of 4 Sockets or 16 cores | Max of 4 Sockets or 16 cores | Max of 1 Socket or 4 cores | Max of 1 Socket or 4 cores | Max of 1 Socket or 4 cores |
| Max Mem (SQL Server Database Engine) | OS maximum | 64 GB | 64 GB | 64 GB | 1 GB | 1 GB | 1 GB |
| Max Mem (Analysis Services) | OS maximum | OS maximum | 64 GB | N/A | N/A | N/A | N/A |
| Max Mem (Reporting Services) | OS maximum | OS maximum | 64 GB | 64 GB | 4 GB | N/A | N/A |
| Maximum relational Database size | 524 PB | 524 PB | 524 PB | 524 PB | 10 GB | 10 GB | 10 GB |
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Server Core support1 | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Log Shipping | Yes | Yes | Yes | Yes | |||
| Database mirroring | Yes | Yes (Safety Full Only) | Yes (Safety Full Only) | Witness only | Witness only | Witness only | Witness only |
| Failover Clustering | Yes Nodes OS maximum | Yes (Node support: 2) | Yes (Node support: 2) | ||||
| Backup compression | Yes | Yes | Yes | ||||
| Database snapshot | Yes | ||||||
| AlwaysOn Availability Groups | Yes | ||||||
| SQL Server Multi-Subnet Clustering | Yes | ||||||
| Connection Director | Yes | ||||||
| Online page and file restore | Yes | ||||||
| Online indexing | Yes | ||||||
| Online schema change | Yes | ||||||
| Fast recovery | Yes | ||||||
| Mirrored backups | Yes | ||||||
| Hot Add Memory and CPU2 | Yes | ||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Multi-instance support | 50 | 50 | 50 | 50 | 50 | 50 | 50 |
| Table and index partitioning | Yes | ||||||
| Data compression | Yes | ||||||
| Resource Governor | Yes | ||||||
| Partition Table Parallelism | Yes | ||||||
| Multiple Filestream containers | Yes | ||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Basic Auditing | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Fine Grained Auditing | Yes | ||||||
| Transparent database encryption | Yes | ||||||
| Extensible Key Management | Yes | ||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| SQL Server change tracking | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Merge replication | Yes | Yes | Yes | Yes (Subscriber only) | Yes (Subscriber only) | Yes (Subscriber only) | Yes (Subscriber only) |
| Transactional replication | Yes | Yes | Yes | Yes (Subscriber only) | Yes (Subscriber only) | Yes (Subscriber only) | Yes (Subscriber only) |
| Snapshot replication | Yes | Yes | Yes | Yes (Subscriber only | Yes (Subscriber only) | Yes (Subscriber only) | Yes (Subscriber only) |
| Heterogeneous subscribers | Yes | Yes | Yes | ||||
| Oracle publishing | Yes | ||||||
| Peer to Peer transactional replication | Yes | ||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| SQL Management Objects (SMO) | Yes | Yes | Yes1 | Yes | Yes | Yes | Yes |
| SQL Configuration Manager | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| SQL CMD (Command Prompt tool) | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| SQL Server Management Studio | Yes | Yes | Yes | Yes | Yes | Yes | |
| Distributed Replay – Admin Tool | Yes | Yes | Yes | Yes | Yes | Yes | |
| Distributed Replay – Client | Yes | Yes | Yes | Yes | |||
| Distributed Replay – Controller | Yes (Ent up to 16 clients, Dev only 1 client) | Yes (1 client support only) | Yes (1 client support only) | Yes (1 client support only) | |||
| SQL Profiler | Yes | Yes | Yes | No2 | No2 | No2 | No2 |
| SQL Server Agent | Yes | Yes | Yes | Yes | |||
| MSCOM Management Pack | Yes | Yes | Yes | Yes | |||
| Database Tuning Advisor (DTA) | Yes | Yes | Yes3 | Yes3 | |||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| User Instances | Yes | Yes | Yes | ||||
| Dedicated admin connection | Yes | Yes | Yes | Yes | Yes (under trace flag) | Yes (under trace flag) | Yes (under trace flag) |
| PowerShell scripting support | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| SysPrep support1 | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Support for Data-tier application component operations – extract, deploy, upgrade, delete | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Policy automation (check on schedule and change) | Yes | Yes | Yes | Yes | |||
| Performance data collector | Yes | Yes | Yes | Yes | |||
| Able to enroll as a managed instance in a multi-instance management | Yes | Yes | Yes | Yes | |||
| Standard performance reports | Yes | Yes | Yes | Yes | |||
| Plan guides and plan freezing for plan guides | Yes | Yes | Yes | Yes | |||
| Direct query of indexed views (using NOEXPAND hint) | Yes | Yes | Yes | Yes | |||
| Automatic indexed view maintenance | Yes | Yes | Yes | Yes | |||
| Distributed partitioned views | Yes | Dist. part. View No UP | Dist. part. View No UP | Dist. part. View No UP | Dist. part. View No UP | Dist. part. View No UP | Dist. part. View No UP |
| Parallel indexed operations | Yes | ||||||
| Automatic use of indexed view by query optimizer | Yes | ||||||
| Parallel consistency check | Yes | ||||||
| SQL Server utility control point | Yes | ||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Microsoft Visual Studio Integration | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| SQL Server Developer Studio | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Intellisense (Transact-SQL and MDX) 1 | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| SQL Server Data Tools (SSDT) | Yes | Yes | Yes | Yes | Yes | ||
| SQL query edit and design tools1 | Yes | Yes | Yes | ||||
| Version control support1 | Yes | Yes | Yes | ||||
| MDX edit, debug, and design tools1 | Yes | Yes | Yes | ||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Common Language Runtime (CLR) Integration | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Native XML support | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| XML indexing | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| MERGE & UPSERT Capabilities | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| FILESTREAM support | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| FileTable | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Date and Time datatypes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Internationalization support | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Full-text and semantic search | Yes | Yes | Yes | Yes | Yes | ||
| Specification of language in query | Yes | Yes | Yes | Yes | Yes | ||
| Service Broker (messaging) | Yes | Yes | Yes | No (Client only) | No (Client only) | No (Client only) | No (Client only) |
| Web services (HTTP/SOAP endpoints) | Yes | Yes | Yes | Yes | |||
| T-SQL endpoints | Yes | Yes | Yes | Yes | |||
|
Feature
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| SQL Server Import and Export Wizard | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Built-in data source connectors | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| SSIS designer and runtime | Yes | Yes | Yes | ||||
| Basic Transforms | Yes | Yes | Yes | ||||
| Basic data profiling tools | Yes | Yes | Yes | ||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| High performance Oracle destination | Yes | ||||||
| High performance Teradata destination | Yes | ||||||
| SAP BW source and destination | Yes | ||||||
| Data mining model training destination adapter | Yes | ||||||
| Dimension processing destination adapter | Yes | ||||||
| Partition processing destination adapter | Yes | ||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Persistent (high performance) lookups | Yes | ||||||
| Data mining query transformation | Yes | ||||||
| Fuzzy grouping and lookup transformations | Yes | ||||||
| Term extractions and lookup transformations | Yes | ||||||
|
Feature
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Master Data Services database | Yes | Yes | |||||
| Master Data Manager web application | Yes | Yes | |||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Create cubes without a database | Yes | Yes | Yes | ||||
| Auto-generate staging and data warehouse schema | Yes | Yes | Yes | ||||
| Change data capture | Yes | ||||||
| Star join query optimizations | Yes | ||||||
| Scalable read-only Analysis Services configuration | Yes | ||||||
| Proactive caching | Yes | ||||||
| Parallel query processing on partitioned tables and indices | Yes | ||||||
| Columnstore Indexes | Yes | ||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Scalable Shared Databases (Attach/Detach, Read only databases) | Yes | Yes | |||||
| High Availability | Yes | Yes | Yes | ||||
| Programmability (AMO, ADOMD.Net, OLEDB, XML/A, ASSL) | Yes | Yes | Yes | ||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Semi-additive Measures | Yes | Yes | |||||
| Hierarchies | Yes | Yes | Yes | ||||
| KPIs | Yes | Yes | Yes | ||||
| Perspectives | Yes | Yes | |||||
| Actions | Yes | Yes | Yes | ||||
| Account intelligence | Yes | Yes | Yes | ||||
| Time Intelligence | Yes | Yes | Yes | ||||
| Custom rollups | Yes | Yes | Yes | ||||
| Writeback cube | Yes | Yes | Yes | ||||
| Writeback dimensions | Yes | Yes | |||||
| Writeback cells | Yes | Yes | Yes | ||||
| Drillthrough | Yes | Yes | Yes | ||||
| Advanced hierarchy types (Parent-Child, Ragged Hiearchies) | Yes | Yes | Yes | ||||
| Advanced dimensions (Reference dimensions, many-to-many dimensions | Yes | Yes | Yes | ||||
| Linked measures and dimensions | Yes | Yes | |||||
| Translations | Yes | Yes | |||||
| Aggregations | Yes | Yes | Yes | ||||
| Multiple Partitions | Yes | Yes | Yes, up to 3 | ||||
| Proactive caching | Yes | Yes | |||||
| Custom Assemblies (stored procs) | Yes | Yes | Yes | ||||
| MDX queries and scripts | Yes | Yes | Yes | ||||
| Role-based security model | Yes | Yes | Yes | ||||
| Dimension and Cell-level Security | Yes | Yes | Yes | ||||
| Scalable string storage | Yes | Yes | Yes | ||||
| MOLAP, ROLAP, HOLAP storage modes | Yes | Yes | Yes | ||||
| Binary and compressed XML transport | Yes | Yes | Yes | ||||
| Push-mode processing | Yes | Yes | |||||
| Direct Writeback | Yes | Yes | |||||
| Measure Expressions | Yes | Yes | |||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Hierarchies | Yes | Yes | |||||
| KPIs | Yes | Yes | |||||
| Semi-additive Measures | Yes | Yes | |||||
| Perspectives | Yes | Yes | |||||
| Translations | Yes | Yes | |||||
| DAX calculations, DAX queries, MDX queries | Yes | Yes | |||||
| Row-level Security | Yes | Yes | |||||
| Partitions | Yes | Yes | |||||
| VertiPaq and DirectQuery storage modes (Tabular only) | Yes | Yes | |||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| SharePoint farm integration based on shared service architecture | Yes | Yes | |||||
| Usage reporting | Yes | Yes | |||||
| Health monitoring rules | Yes | Yes | |||||
| PowerPivot Gallery | Yes | Yes | |||||
| PowerPivot Data Refresh | Yes | Yes | |||||
| PowerPivot Data Feeds | Yes | Yes | |||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Standard Algorithms | Yes | Yes | Yes | ||||
| Data Mining Tools (Wizards, Editors Query Builders) | Yes | Yes | Yes | ||||
| Cross Validation | Yes | Yes | |||||
| Models on Filtered Subsets of Mining Structure Data | Yes | Yes | |||||
| Time Series: Custom Blending Between ARTXP and ARIMA Methods | Yes | Yes | |||||
| Time Series: Prediction with New Data | Yes | Yes | |||||
| Unlimited Concurrent DM Queries | Yes | Yes | |||||
| Advanced Configuration & Tuning Options for Data Mining Algorithms | Yes | Yes | |||||
| Support for plug-in algorithms | Yes | Yes | |||||
| Parallel Model Processing | Yes | Yes | |||||
| Time Series: Cross-Series Prediction | Yes | Yes | |||||
| Unlimited attributes for Association Rules | Yes | Yes | |||||
| Sequence Prediction | Yes | Yes | |||||
| Mult. Predict. Targets for Naïve Bayes, Neural Network and Log. Regr. | Yes | Yes | |||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Supported catalog DB SQL Server edition | Standard or higher | Standard or higher | Standard or higher | Web | Express | ||
| Supported data source SQL Server edition | All SQL Server editions | All SQL Server editions | All SQL Server editions | Web | Express | ||
| Report Server | Yes | Yes | Yes | Yes | Yes | ||
| Report Designer | Yes | Yes | Yes | Yes | Yes | ||
| Report Manager | Yes | Yes | Yes | Yes | Yes | ||
| Role based security | Yes | Yes | Yes | Yes | Yes | ||
| Word Export and Rich Text Support | Yes | Yes | Yes | Yes | Yes | ||
| Enhanced gauges and charting | Yes | Yes | Yes | Yes | Yes | ||
| Export to Excel, PDF, and Images | Yes | Yes | Yes | Yes | Yes | ||
| Custom authentication | Yes | Yes | Yes | Yes | Yes | ||
| Report as data feeds | Yes | Yes | Yes | Yes | Yes | ||
| Model support | Yes | Yes | Yes | Yes | |||
| Create custom roles for role-based security | Yes | Yes | Yes | ||||
| Model Item security | Yes | Yes | Yes | ||||
| Infinite click through | Yes | Yes | Yes | ||||
| Shared component library | Yes | Yes | Yes | ||||
| Email and file share subscriptions and scheduling | Yes | Yes | Yes | ||||
| Report history, execution snapshots and caching | Yes | Yes | Yes | ||||
| SharePoint Integration | Yes | Yes | Yes | ||||
| Remote and non-SQL data source support1 | Yes | Yes | Yes | ||||
| Data source, delivery and rendering, RDCE extensibility | Yes | Yes | Yes | ||||
| Data driven report subscription | Yes | Yes | |||||
| Scale out deployment (Web farms) | Yes | Yes | |||||
| Alerting2 | Yes | Yes | |||||
| Power View2 | Yes | Yes | |||||
|
For this edition of SQL Server Reporting Services
|
Use the DB Eng to host the database | ||||||
| Enterprise | Std, BI Ent Edit. | ||||||
| Business Intelligence | Std, BI Ent Edit. | ||||||
| Standard | Std, Ent editions (local or remote) | ||||||
| Web | Web edition (local only) | ||||||
| Express with Advanced Services | Ex Advanced Services (local only). | ||||||
| Evaluation | Evaluation | ||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Report Builder | Yes | Yes | Yes | ||||
| Data Mining Addins for Excel and Visio 2010 | Yes | Yes | Yes | ||||
| PowerPivot for Excel 2010 | Yes | Yes | |||||
| Master Data Services Add-in for Excel | Yes | Yes | |||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Spatial indexes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Planar and Geodetic datatypes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Advanced spatial libraries | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Import/export of industry-standard spatial data formats | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| SQL Server Migration Assistant | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Database mail1 | Yes | Yes | Yes | Yes | |||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Data Quality Services | Yes | Yes | |||||
| StreamInsight | StreamInsight Premium Edition | StreamInsight Standard Edition | StreamInsight Standard Edition | StreamInsight Standard Edition | |||
| StreamInsight HA | StreamInsight Premium Edition |
