StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>For a standalone desktop product it is certainly a lightweight option to consider over SQL Express.</p> <p>However there are differences between the two to be aware of other than just connection strings. For example SQL CE does not support stored procedures, user-defined functions, or triggers. Additionally it does not support the full range of datatypes that Express supports. On a technical level it also runs in process with your application.</p> <p>Another consideration is that while SSMS will work with SQL CE databases, it's not as fully featured as it is with SQL Express. There are however a whole raft of good tools out there for filling these gaps. Take a look at Erik Jensen's blog for a good overview.</p> <p><a href="http://erikej.blogspot.com/2009/04/sql-compact-3rd-party-tools.html" rel="nofollow noreferrer">Everything SQL Server Compact</a></p> <p>Also check out his tool for migrating SQL Express databases to SQL Compact:</p> <p><a href="http://erikej.blogspot.com/2010/02/how-to-use-exportsqlce-to-migrate-from.html" rel="nofollow noreferrer">How to Migrate/Downsize a SQL Server database to SQL Server Compact 4.0 (and 3.5)</a></p> <p>Finally take a look at this SO question for more background between the two products:</p> <p><a href="https://stackoverflow.com/questions/407521/what-are-the-limitations-to-sql-server-compact-or-how-does-one-choose-a-datab">What are the limitations to SQL Server Compact? (Or - how does one choose a database to use on MS platforms?)</a></p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload