jump to navigation

SQL SERVER 2012 Enterprise vs Business Intelligence vs Standard vs Web vs Express with Advanced Services vs Express with Tools vs Express December 10, 2012

Posted by juanpablo1manrique in SharePoint.
trackback

Y en este mundo de las comparaciones …

Connection DirectorYes      Online page and file restoreYes      Online indexingYes      Online schema changeYes      Fast recoveryYes

SQL SERVER 2012 Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
Cross-Box Scale Limits
Feature Name
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
Maximum Compute Capacity Used by a Single Instance (SQL Server Database Engine)1 Operating System maximum Limited to lesser of 4 Sockets or 16 cores Limited to lesser of 4 Sockets or 16 cores Limited to lesser of 4 Sockets or 16 cores Limited to lesser of 1 Socket or 4 cores Limited to lesser of 1 Socket or 4 cores Limited to lesser of 1 Socket or 4 cores
Maximum Compute Capacity Used by a Single Instance (Analysis Services, Reporting
Services) 1
Operating system maximum Operating system maximum Limited to lesser of 4 Sockets or 16 cores Limited to lesser of 4 Sockets or 16 cores Limited to lesser of 1 Socket or 4 cores Limited to lesser of 1 Socket or 4 cores Limited to lesser of 1 Socket or 4 cores
Maximum memory utilized (SQL Server Database Engine) Operating system maximum 64 GB 64 GB 64 GB 1 GB 1 GB 1 GB
Maximum memory utilized (Analysis Services) Operating system maximum Operating system maximum 64 GB N/A N/A N/A N/A
Maximum memory utilized (Reporting Services) Operating system maximum Operating system 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
High Availability (AlwaysOn)
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 (Node support: Operating system 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
Mirrored backups Yes
Hot Add Memory and CPU2 Yes
Database Recovery Advisor Yes Yes Yes Yes Yes Yes Yes
Scalability and Performance
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
Security
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
User-Defined Roles Yes Yes Yes Yes Yes Yes Yes
Contained Databases Yes Yes Yes Yes Yes Yes Yes
Replication
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
Management Tools
Feature Name
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
SQL Management Objects (SMO) Yes Yes Yes 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 (Enterprise supports up to 16 clients, Developer supports 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
Microsoft System Center Operations Manager Management Pack Yes Yes Yes Yes
Database Tuning Advisor (DTA) Yes Yes Yes3 Yes3
RDBMS Manageability
Feature Name
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
User Instances Yes Yes Yes
LocalDB 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 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
Parallel indexed operations Yes
Automatic use of indexed view by query optimizer Yes
Parallel consistency check Yes
SQL Server Utility control point Yes
Contained Databases Yes Yes Yes Yes Yes Yes Yes
Development Tools
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
Programmability
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
TSQL endpoints Yes Yes Yes Yes
Integration Services
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
Change Data Capture Service for Oracle by Attunity Yes
Change Data Capture Designer for Oracle by Attunity Yes
Integration Services – Advanced Adapters
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
Change Data Capture components by Attunity Yes
Connector for Open Database Connectivity (ODBC) by Attunity Yes
Integration Services – Advanced Transforms
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
Master Data Services
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
Data Warehouse
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
Parallel query processing on partitioned tables and indices Yes
xVelocity memory optimized columnstore indexes Yes
Analysis Services
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
BI Semantic Model (Multidimensional)
Feature Name
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
Semi-additive Measures Yes Yes No1
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 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
BI Semantic Model (Tabular)
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
In-Memory and DirectQuery storage modes (Tabular only) Yes Yes
PowerPivot for SharePoint
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
Data Mining
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
Multiple Prediction Targets for Naïve Bayes, Neural Network and Logistic Regression Yes Yes
Reporting Services Features
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
Reporting Services : Report Server Database Server Edition Requirements
Feature Name
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
Use this edition of the Database Engine instance to host the database Standard, Business Intelligence Enterprise, editions (local or remote) Standard, Business Intelligence Enterprise, editions (local or remote) Standard, Enterprise editions (local or remote) Web edition (local only) Express with Advanced Services (local only).
Business Intelligence Clients
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
Spatial and Location Services
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
Additional Database Services
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 mail Yes Yes Yes Yes
Other Components
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

Tomado de http://msdn.microsoft.com/en-us/library/cc645993.aspx

Advertisements

Comments»

1. psoriasis - February 22, 2013

Hey I am so grateful I found your blog, I really found you by mistake, while I was looking on
Google for something else, Anyways I am here
now and would just like to say many thanks for a remarkable post and
a all round interesting blog (I also love the theme/design), I don’t have time to go through it all at the minute but I have bookmarked it and also
added in your RSS feeds, so when I have time I will be back to read much more, Please do keep up the
awesome jo.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: