SQL Server 2005 Compact Edition
There is no substitute for experience when it comes to Windows Mobile development...
Using SQL Server 2005 Compact Edition presents some challenges:
-
No support for Views
- No support for Triggers
- No support for Stored Procedures
- No Procedural T-SQL Select, Case and If
support
- Maximum usage of 1 CPU
- No Full Text Search indexes
- No connection pooling
That being said though it is an robust and reliable small memory
footprint database. It does however require you to understand the
limitations and architect your application accordingly.
How can we help?
Give us a call and we will discuss the
options that will work for your solution - we are always happy to talk tech.