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) |
