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/

 

Leave a Reply

Your email address will not be published. Required fields are marked *