Возможности SharePoint и SQL Server по редакциям
Подробнее
| Функциональность SharePoint Server 2010 | SQL Server 2008 R2 Enterprise | SQL Server 2008 R2 Standard | SQL Server 2008 R2 Express | 
| Remote BLOB storage (RBS) на не локальном диске | 
Да | ||
| RBS налокальном диске. ТребуетсяRBS add-in с SQL Server 2008 R2 Feature Pack | 
Да | 
Да | 
Да | 
| Backup compression | 
Да | 
Да | |
| Data compression для Search Crawl и Property databases | 
Да | ||
| Table partitioning для Reporting базы Web Analytics | 
Да | ||
| Transparent data encryption | 
Да | ||
| Resource governor | 
Да | ||
| Database auditing | 
Да | ||
| Clustered database server | 
Да | 
Да Только 2 nodes | |
| Database mirroring с log-stream compression | 
Да | 
Да | |
| SQL Server snapshot support for site collection backup and content deployment | 
Да | ||
| PowerPivot in SharePoint | 
Да | ||
| Access Services (подключенный) Требуется SQL Server 2008 R2 Reporting Services (SSRS) на report server,и SSRS 2008 R2 add-in на Web server. | 
Report server | 
Report server | 
Data source | 
| Access Services (локальный) ТребуетсяSSRS 2008 R2 add-in наWeb server. | 
Data source | 
Data source | 
Data source | 
| Reporting Services интеграция с Report Server | 
Да | 
Да | |
| Reporting Services интеграция со списками SharePoint | 
Да | 
Да | 
Да |