Confused by database choices

[slopey]

Hi All,

I need to do some windows mobile 2005 development which uses a database
on the device - I've not done anything database wise since back in the
good olde days of pocket access. I'm up to speed on ADO.net but the
choice of database is a little confusing.

From the MS site, there's SQL Server CE, SQL Server 2005 Mobile and SQL

Server Everywhere Edition.

Which should I be using with VB.net 2005 and how do I go about
installing on the PPC and on the emulator under vb.net 2005?

Any help gratefully received, I've been all over the net, installed
SDKs/CTPs/ various SQL Server mobile/CE/etc editions off the MS site
and I'm now thoroughly confused.

Or am I better ditching the MS route and going for a 3rd party database
for the handheld end?

Cheers,
Slopey

 

[Guest]

Hi slopey,

The three items that you have listed are, generically, the same thing. The
current revision of the product is called SQL Server Mobile Edition 2005 (SQL
Mobile for short). When you add a reference to your project to
System.Data.SqlServerCe, Visual Studio will deploy the correct .cab files for
you.

Microsoft is working on a version that works on Win32 as well and has given
it the pre-release name of SQL Server Everywhere Edition (SQL/Ev) - this
product, when released, will be known as SQL Server Compact Edition. You can
see the history of this naming decision here:
http://blogs.msdn.com/stevelasker/a...-server-everywhere-gets-yet-another-name.aspx

Oh, and the current OS is Windows Mobile 5.0, not 2005.