SQL SERVER – Difference Between SQL Server Compact Edition (CE) and SQL Server Express Edition

I often received question regarding what are difference between SQL Server Compact Edition (CE) and SQL Server Express Edition. In one line – SQL Server CE is for mobile application and embaded systems where as SQL Server Express Edition is limited feature light version of SQL Server Standard.

SQL Server Compact EditionSQL Server Express Edition
ClickOnce DeploymentClickOnce Deployment
Installed centrally with an MSIInstalled centrally with an MSI
XML storageXML storage
Subscriber for merge replicationSubscriber for merge replication
Simple transactionsSimple transactions
Database size support – 4GBDatabase size support – 4GB
Number of concurrent connections – 256Number of concurrent connections – Unlimited
Privately installed, embedded, with the application
Non-admin installation option
Runs on Windows Mobile platform
Runs in-process with application
Data file storage on a network share
Support for different file extensions
Code free, document safe, file format
Remote Data Access (RDA)
ADO.NET Sync Framework
Subscriber for merge replication
Simple transactions
Runs as a service
Procedural T-SQL
Distributed transactions
Native XML, XQuery/QPath
Stored procedures, views, triggers
Role-based security

I am interested to know if my readers have used any of these servers what was the real life application for the same.

Reference : Pinal Dave (https://blog.sqlauthority.com)

Source : https://blog.sqlauthority.com/2009/04/22/sql-server-difference-between-sql-server-compact-edition-ce-and-sql-server-express-edition

Database, SQL Server Express
Previous Post
SQL SERVER – What is Cloud Computing – Introduction to Cloud Computing
Next Post
SQL SERVER – FIX : Error: 18486 Login failed for user ‘sa’ because the account is currently locked out. The system administrator can unlock it. – Unlock SA Login

Related Posts

11 Comments. Leave new

  • We use SQL Server Express for as the database for our distributed logistics software. Since we do our work on a contract basis, you can’t beat it in terms of lowering our overall fee (no licensing) and security.

  • I’ve used SQL Compact for a couple projects so far. I love it for desktop apps (with no server component) because it is so simple to deploy. I’ve also used it in conjunction with Sync for ADO.NET to develop an “occasionally connected” application. It and the sync framework work really well.

    One thing to be aware of is that SQL Compact only supports a subset of SQL Server data types and there is little in the way of programmability – that is, no stored procedures, udfs or triggers.

  • I want to use SQL Server Compact Edition for windows mobile 6.0.

    Can you please tell me it is free of cost like access databsase or i have to purchase licence of it?

  • Can I use SQL Server Compact Edition in Client Server environment?

  • Comprehensive answer
    You have saved my time

  • 4 gb is for a single database? is there any limitation for number of databases?

    • Have you got a decent reply or info about your question somewhere so far? If yes please share with me. I really wonder to learn that like you.

  • >Data file storage on a network share

    Afaik ms sql ce doesn’t support data file storage on a network share.

  • i’m working on windows app which is a paper setter desktop app, which set an exam paper sets
    but i’m thinking about which is good to use 1.sql express 2. sql CE?
    please giude me .
    i have already gone through both procs and cons still not making up my decision please guide.

  • I experienced that SQLCE is very slow. I am using Asp.NET Entity Framework when I was using Sql Express my test cases were passing within 5 mins. I just switched to SQL CE and my same test cases are taking 10 Mins.


Leave a Reply