United States   Change   |   All Microsoft Sites

Home

Compare Editions–Compact and Express

Compact

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

Express

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

Limited
Available

Security

Limited
Available

Programmability

Limited
Available

Integration & Interoperability

Available
Available

Reporting

Limited
Available

Deployment Options

Available
Limited