SQL Server Compact vs. Jet/ACE

Question

I am trying to get a better understanding of what the benefits would be for using a SQL Server Compact database as opposed to a Jet/ACE database for the following situation:

- New WPF application - will be implemented in Visual Studio 2010 or 2012

- Single user - only one user of the application at a time

- Fairly complex datamodel in terms of number of tables and their relationships (100+ tables)

- Reasonable data volumes, a few tables with 100,000+ rows but most with rows in the thousands or less

Given this type of application, what are the benefits with SQL Server Compact Edition in the following areas (and any other that you would say are relevant):

- Performance

- Stability / Integrity

- Long term support (from Microsoft)

Answer 1

No one with any guidance on the above?

Answer 2

ok, let me give it a try:

I think ACE will give OS bitness issues (32 vs 64)

used correctly Sql Server Compact gives excellent perf

It is as stable as you can get it, and backups are easy - File.Copy

Supports easy xcopy deployment (you probably already know)

Support life cycle: http://support.microsoft.com/lifecycle/search/default.aspx?sort=PN&alpha=sql+server+compact&gadate=0&msdate=0&esdate=0&medate=0&spdate=0&Filter=FilterNO&wa=wsignin1.0

---

Please mark as answer, if this was it. Visit my SQL Server Compact blog