4

What are the different database options on Windows Mobile available? I have used CEDB and EDB for linear dataset needs.

I have heard of SQL server 2005 Mobile edition. But what are the advantages over others (if there is any)

Brent Ozar
  • 13,174
  • 14
  • 68
  • 91
prakash
  • 58,901
  • 25
  • 93
  • 115

6 Answers6

5

I've found both sqllite and codebase to be easy to implement and install. Easier (and more stable) than the Microsoft options, which seem to be in serious flux.

dkretz
  • 37,399
  • 13
  • 80
  • 138
  • Plus one for questioning the stability of CEDB. I've just been looking at a mobile project using CEDB that is in a world of pain. No concurrent users, no transactions, recommendations not to go above 1000 rows. I genuinely thought Access was the worst DB of all time. Not anymore. – Joe Ratzer Jul 11 '11 at 14:55
5

Also take a look at SQLite for Windows CE. There are also .NET bindings available to use it from the Compact Framework.

Carl Russmann
  • 1,719
  • 12
  • 13
3

I think it's called SQL Server Compact now. The advantages are that it's syntax-compatible with full sql server in that any query you write for it is guaranteed to work on an equivalent SQL Server Express/Standard/Enterprise DB. The reverse isn't necessarily true, though.

Joel Coehoorn
  • 399,467
  • 113
  • 570
  • 794
3

Do you need SQL support? If not, look at a lightweight embeddable DBM-like solution. I've used Tokyo Cabinet for a number of embedded solutions where SQL wasn't necessary and have greatly enjoyed the speed and flexibility it provides. YMMV.

Serafina Brocious
  • 30,433
  • 12
  • 89
  • 114
2

We use Sybase Ultralite. Before that we were using Codebase to connect to foxpro tables. I'm not a mobile developer but I understand we chose it over SQL Server for performance and memory usage. Also we found they had pretty good support when we found any issues.

1800 INFORMATION
  • 131,367
  • 29
  • 160
  • 239
1

I would avoid using CEDB any more as I beleave that WM7 is dropping support for it.

Shane Powell
  • 13,698
  • 2
  • 49
  • 61