内容发布更新时间 : 2024/5/21 4:24:51星期一 下面是文章的全部内容请认真阅读。

Sql server 2008版本功能及参数比较

Scalability 可扩展性

功能名称 Enterprise Standard Workgroup Web Express Express Tools Express Advanced Partitioning分区 Yes Data compression数据压缩 Yes Resource governor 资源总揽 Yes Partition table parallelism 分区表并行 Yes

High Availability 高可用性

Express 功能名称 Enterprise Standard Workgroup Web Express Tools Express Advanced Multi-instance support 多实例支持 50 16 16 16 16 16 16 Online system changes 在线系统的变化 Yes Yes Yes Yes Yes Yes Yes Backup log shipping 备份日志传送 Yes Yes Yes Yes Database mirroring2 数据库镜像 Yes (full) Yes (safety full only) Witness only Witness only Witness only Witness only Witness only Failover clustering 故障转移群集 Operating system maximum1 2 nodes Dynamic AWE 动态扩展 Yes Yes Failover without client configuration 容错 Yes Yes Automatic corruption recovery from mirror 失Yes Yes 败自动恢复镜像 Database snapshots 数据库快照 Yes Fast recovery 快速恢复 Yes Online indexing 在线索引 Yes Online restore 在线恢复 Yes Mirrored backups 镜像备份 Yes Hot add memory 热内存添加 Yes Online configuration of P2P nodes 在线点对点配置 Yes Hot add CPU 热添加CPU Yes Backup compression 备份压缩 Yes 1 Windows Server 2003中支持最多8故障转移群集节点。 Windows Server 2008的支持的和最多16故障转移群集节点。

Security安全性

Express 功能名称 Enterprise Standard Workgroup Web Express Tools Express Advanced C2 audit mode C2审计模式 Yes Yes Yes Yes Yes Yes Yes SQL Server auditing SQL Server审计 Yes Transparent database encryption 透明的数据库加密 Yes ISV encryption (off-box key management) 独立软件开发商的加密（非官方密钥管理） Yes

Replication 复制

功能名称 Enterprise Standard Workgroup Web Express Express Tools Express Advanced Merge replication合并复制 Yes Yes Subscriber only1 Subscriber only Subscriber only Subscriber only Subscriber only Transactional replication 交易复制 Yes Yes Subscriber only1 Subscriber only Subscriber only Subscriber only Subscriber only Snapshot replication 快照复制 Yes Yes Subscriber only Subscriber only Subscriber only Subscriber only Subscriber only SQL Server change tracking SQL Server变化跟踪 Yes Yes Yes Yes Yes Yes Yes Heterogeneous subscribers异构用户 Yes Yes Oracle publishing甲骨文Publishing Yes P2P transactional replication P2P网络复制 Yes 1If 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.

Reporting

Express Feature Name Enterprise Standard Workgroup Web Express Tools Express Advanced Report server Yes Yes Yes Yes Yes Report Designer Yes Yes Yes Yes Yes Report Manager Yes Yes Yes Yes (Report Manager) Yes (Report Manager) Role-based security Yes Yes Yes (Fixed roles) Yes (Fixed roles) Yes (Fixed roles) Ad-hoc reporting (Report builder) Yes Yes Yes Word export and enhanced text formatting Yes Yes Yes Yes Yes Enterprise-scale reporting engine Yes Yes Yes Yes Yes IIS-agnostic report deployment Yes Yes Yes Yes Yes Updated management tools Yes Yes Yes Yes Yes Report definition customization extension (RDCE) Yes Yes Yes Yes Yes SharePoint integration Yes Yes Enhanced SSRS gauges and charting Yes Yes Yes Yes Yes Custom authentication Yes Yes Yes Yes Export to Excel, PDF, and images Yes Yes Yes Yes Yes Remote and non-relational data source support Yes Yes E-mail and file share delivery Yes Yes Report history, scheduling, subscriptions, and caching Yes Yes Data source, delivery, and rendering extensibility Yes Yes Scale out (Web farms) Yes Infinite clickthrough Yes Data-driven subscriptions Yes Reporting Services memory limits OS Maximum OS Maximum 4 GB 4 GB 4 GB