The SQL Server compact development team has just released a white paper comparing express and compact versions. In fact, this White Paper does not focus on the comparison between the two versions, but reviews the local data storage needs. As a data service, express is applicable to one or more users. With the release of compact, compact is positioned as the default local data storage database, and is an embedded database engine.
Since then, comapct will gradually occupy the market for some local data storage of express edition. In the future, we will see that more smart client solutions use the compact version of SQL Server to store offline data, while SQL Server Express is used in small data services, or as an endpoint of a distributed database.
White Paper:
Http://download.microsoft.com/download/A/4/7/A47B7B0E-976D-4F49-B15D-F02ADE638EBE/Compact_Express_Comparison.doc
Some of my friends are interested in the features of SQL Server compact. Next I will introduce the use of SQL Server compact in my spare time.
Information Source:
Comparing SQL Server express and compact editions whitepaper