locked
Which DB should I use for a PocketPC app? RRS feed

  • Question

  • I'm planning a Pocket PC / Windows Mobile application, but I'm a bit confused on which mobile database I should start development with.  I've read about SQL CE, SQL Everywhere, and SQL Mobile.  Should I be using SQL Server CE 3.1 for my Pocket PC application?  The database will be preloaded with data at design time with read-only information, and will be a "private" installation for a single user application.  

    My main concern is that the solution can be installed on PPC 2002, 2003 and Mobile 2005. 

    Am I on the right track?

    Thanks,
    Jordan

     

    Wednesday, January 17, 2007 8:49 PM

Answers

  • SQL Server Everywhere Edition was renamed to be SQL Server Compact Edition, which to the best of my knowledge is the successor to SQL Server Mobile. Regardless, I would use SQL Server Compact Edition for the situation you described. You'll just need to install the .NET Compact Framework and SQL Server Compact Edition on the mobile device.
    Wednesday, January 17, 2007 9:51 PM