What is the difference between SQL Server Compact Edition and SQL Server Express Edition?

Can someone explain what is the main difference between SQL Server Compact Edition and SQL Server Express Edition?

For what purpose should I use this or that?

thank

+5
source share
2 answers

This blog has everything you need, it will even give you a comparison of functions.

If you don't want to read, SQL Server Compact is designed for mobile / embedded applications, and the Express version is just a free SQL Server standard.

Edit It is very important to note that @Rup just stated that Compact is an in-memory database.

+8

sql- (4 2008/2005, 10 2008 R2). , . , SQL Express , SQL Server (, GoDaddy). - sql express app_data .

. , CE , -. ... , .

: . 4 - ASP.Net:

http://weblogs.asp.net/scottgu/archive/2010/06/30/new-embedded-database-support-with-asp-net.aspx

-, System.Data.SQLite - ...

+3

All Articles