SQL Server Express 2005 MSDE 2000
User Instance support Feature not present
DTS in separate download DTS runtime present
Easy deployment because of no MDAC MDAC is part of install
MSI only, good servicing story MSI and MSM, servicing of MSM hard
Subscriber Replication for Transactional, Merge, and snapshot Merge/snapshot publication supported in addition to replication subscription
Robust setup UI Basic setup UI
No agent Agent present
Supports Windows 2000 SP4, Windows XP SP1, and Windows 2003 Supports Windows 98, Windows Me, Windows 2000, Windows XP, Windows NT4, and Windows 2003
CLR support No CLR support
GUI tools available No GUI tools
Database size limit: 4 GB Database size limit: 2 GB
1 CPU, 1 GB RAM 2 CPU, 2 GB RAM
No throttle Workload throttle enforced for 5 concurrent workloads
Deep integration with Visual Studio Basic integration with Visual Studio
 
Advertisements