Compare Editions–Compact and Express

Build standalone and occasionally connected applications for mobile devices, desktops, and web clients on all Microsoft Windows platforms.

Ideal for learning and building desktop and small server applications and for re-distribution by ISVs.

KEY:

= Full

= Partial/Limited

= Not Available

	SQL Server 2008 Compact Edition	SQL Server 2008 Express Edition
Details	Single Workstation Connectivity Current: 4 GB Database DB size	Max 1 CPU/Server 1 GB RAM usage 4 GB DB size
Manageability
Security
Programmability
Integration & Interoperability
Reporting
Deployment Options