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

sql-server-express relational-database database-engine
pencilCake picture pencilCake · Jul 30, 2010 · Viewed 11.1k times · Source

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

For what purpose I should use this or that one?

Thanks

Answer

Nix picture Nix · Jul 30, 2010

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

If you don't feel like reading, SQL Server Compact is for Mobile/Embeded Apps, and Express edition is just a free scaled down SQL Server standard.

Edit A very important thing to point out as @Rup just stated is that Compact is an in memory database.

Related questions

How can I determine installed SQL Server instances and their versions?

I'm trying to determine what instances of sql server/sql express I have installed (either manually or programmatically) but all of the examples are telling me to run a SQL query to determine this which assumes I'm already connected to …

Read More
SQL Server® 2016, 2017 and 2019 Express full download

All previous version of SQL Server Express were available in both web and full downloads. But I cannot find full download of SQL Server® 2016 Express. Does it exist? Asked the same question on MSDN forums, not much luck: https://social.…

Read More
ASP.NET 4.5 has not been registered on the Web server

In my Win 7 development machine, and in order to use SQL Express instance instead of the localDB installed by default. I unchecked "Use IIS Express" in my MVC 4 project properties page (Web tab), then I got the following error: ASP.…

Read More