Thursday, April 2, 2009

Feature Comparison of MSDE and SQL Server 2005 Express

Feature Comparison of MSDE and SQL Server 2005 Express

While the core database capabilities of MSDE and SQL Server 2005 Express are similar, the set of features and database capabilities of MSDE and SQL Server 2005 Express are different. The following table provides a feature comparison between MSDE and SQL Server 2005 Express.

Feature

MSDE

SQL Server 2005 Express Edition

Maximum number of instances

16

16

Maximum # of processors

2

1

Maximum RAM

2 GB

1 GB

Maximum database size

2 GB

4 GB

Workload governor

Yes

No

Graphical management tool

No

Yes

User instances

No

Yes

SQL Agent

Yes

No

DTS runtime

Yes

Yes (Web download)

Replication

Merge only

Merge subscription
Snapshot subscription
Transactional subscription

BI features (Analysis Services, Integration Services)

No

No

Report Server

No

Yes (Installed with SQL Server 2005 Express with Advanced Services)

Service Broker

No

Client only

Full-text search

No

Yes (Installed with SQL Server 2005 Express with Advanced Services)

Windows 9x support

Yes

No

MDAC Required

Yes

No

Business Intelligence Development Studio (BIDS)

No

Yes (Installed with SQL Server 2005 Express Toolkit)


-------------------
Thanks,
http://sccm07.blogspot.com/

No comments:

Post a Comment