MS SQL Express vs. MSDE

on
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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s