Choosing Between SQL Server 2005 Compact Edition and SQL Server 2005 Express Edition

Feature	SQL Server Compact Edition	SQL Server Express Edition
Deployment/Installation Features
Installation size	1.7mb download size 1.8mb expanded on disk	53.8mb download size ~197mb expanded on disk
ClickOnce deployment	+	+
Privately installed, embedded, with the application	+	-
Non-admin installation option	+	-
Runs on Windows Mobile platform	+	-
Installed centrally with an MSI	+	+
Runs in-process with application	+	-
64-bit support	- Version 3.1           + Native 64 in next version	+ Windows on Windows (WOW)
Runs as a service	+ In process with the application	+ N + 1
Data file features
File format	Single file	Multiple files
Data file storage on a network share	+	-
Support for different file extensions	+	-
Database size support	4GB	4GB
XML storage	+ stored as nText	+
Code free, document safe, file format	+	-
Programmability
Transact-SQL Common Query Features	+	+
Procedural T-SQL Select Case, If, features	-	+
Remote Data Access (RDA)	+	-
ADO.NET Sync Framework	+ Enabled with Visual Studio Orcas	- Planed support with a future version
Subscriber for merge replication	+	+
Simple transactions	+	+
Distributed transactions	-	+
Native XML, XQuery/QPath	-	+
Stored procedures, views, triggers	-	+
Role-based security	-	+
Number of concurrent connections	256	Unlimited