Which DB back end??

Hi
I want to write some apps for Pocket PC, which require a back end DB.

What are the options with regards to choice of DB engine??
Pocket Access??
SQL Mobile??

Anything else??

Thanks

Paul,

Pocket Access is deprecated and not supported on Windows Mobile 5. I'd
recommend SQL Mobile, but there are also 3rd party options.

--
Ginny Caughey
..NET Compact Framework MVP


"Paul Aspinall" <paul@aspy.co.uk> wrote in message
news:Ar0Pf.93888$Q22.35602@fe1.news.blueyonder.co.uk...
> Hi
> I want to write some apps for Pocket PC, which require a back end DB.
>
> What are the options with regards to choice of DB engine??
> Pocket Access??
> SQL Mobile??
>
> Anything else??
>
> Thanks
>
>

Take a look at this thread:
http://groups.google.com/group/micr...83e643390e761a0


--
Sergey Bogdanov [.NET CF MVP, MCSD]
http://www.sergeybogdanov.com


Paul Aspinall wrote:
> Hi
> I want to write some apps for Pocket PC, which require a back end DB.
>
> What are the options with regards to choice of DB engine??
> Pocket Access??
> SQL Mobile??
>
> Anything else??
>
> Thanks
>
>

Also check out:

http://weblogs.asp.net/jgalloway/ar.../08/418474.aspx
http://www.sqlsummit.com/DataProv.htm

I am going to do a write up soon on
http://www.nantz.org/Blog/tabid/57/Default.aspx

Brian


Sergey Bogdanov wrote:
> Take a look at this thread:
> http://groups.google.com/group/micr...83e643390e761a0
>
>
>
> --
> Sergey Bogdanov [.NET CF MVP, MCSD]
> http://www.sergeybogdanov.com
>
>
> Paul Aspinall wrote:
>
>> Hi
>> I want to write some apps for Pocket PC, which require a back end DB.
>>
>> What are the options with regards to choice of DB engine??
>> Pocket Access??
>> SQL Mobile??
>>
>> Anything else??
>>
>> Thanks
>>
>>

Not mentioned yet, but certainly 2 viable options are: Sybase/iAnywhere's
(SQL Anywhere Studio) Adaptive Server Anywhere database or UltraLite, both
work on the Pocket PC. The synchronization is quite granular and robust but
does take some coding. Works with several back end database platforms.
Pricing, last I checked was surprisingly affordable.


"Sergey Bogdanov" <sergey.bogdanov@gmail.com> wrote in message
news:%23VZu6mVQGHA.3672@TK2MSFTNGP14.phx.gbl...
> Take a look at this thread:
> http://groups.google.com/group/micr...83e643390e761a0
>
>
> --
> Sergey Bogdanov [.NET CF MVP, MCSD]
> http://www.sergeybogdanov.com
>
>
> Paul Aspinall wrote:
>> Hi
>> I want to write some apps for Pocket PC, which require a back end DB.
>>
>> What are the options with regards to choice of DB engine??
>> Pocket Access??
>> SQL Mobile??
>>
>> Anything else??
>>
>> Thanks
>>

Thanks to all who replied.

Some very interesting options.

I've implemented a desktop solution already in SQL 2000, but want to find a
light-weight PocketPC DB to sync with.

Are there any which can Sync with SQL 2000 (or MSDE / SQL Express)?? Are
there any code samples??
I may even consider changing my desktop DB engine, but MSDE / SQL express is
doing fine, apart from the heavy footprint. I require Stored procedures.

Any code examples of DB's on desktop and Pocket PC, and sync would be great.
Or Pocket PC DB sync with MSDE.

Thanks


Paul

"Hank" <sorry@no.com> wrote in message
news:Oa9YrsWQGHA.5924@TK2MSFTNGP09.phx.gbl...
> Not mentioned yet, but certainly 2 viable options are: Sybase/iAnywhere's
> (SQL Anywhere Studio) Adaptive Server Anywhere database or UltraLite, both
> work on the Pocket PC. The synchronization is quite granular and robust
> but does take some coding. Works with several back end database platforms.
> Pricing, last I checked was surprisingly affordable.
>
>
> "Sergey Bogdanov" <sergey.bogdanov@gmail.com> wrote in message
> news:%23VZu6mVQGHA.3672@TK2MSFTNGP14.phx.gbl...
>> Take a look at this thread:
>> http://groups.google.com/group/micr...83e643390e761a0
>>
>>
>> --
>> Sergey Bogdanov [.NET CF MVP, MCSD]
>> http://www.sergeybogdanov.com
>>
>>
>> Paul Aspinall wrote:
>>> Hi
>>> I want to write some apps for Pocket PC, which require a back end DB.
>>>
>>> What are the options with regards to choice of DB engine??
>>> Pocket Access??
>>> SQL Mobile??
>>>
>>> Anything else??
>>>
>>> Thanks
>>>
>

Paul,

Please consider Visual CE from my company Syware, Inc.. It is very similar to Access in look feel and
capability,runs finewith Windws Mobile 5 and is royalty free. You might say its what Pocket Access should be.

Details at http://www.syware.com/products/visual_ce.php

My Best,
Frank Yacano

Paul Aspinall wrote:

> Hi
> I want to write some apps for Pocket PC, which require a back end DB.
>
> What are the options with regards to choice of DB engine??
> Pocket Access??
> SQL Mobile??
>
> Anything else??
>
> Thanks

--
-------------------------------------------------------------------
Frank Yacano, Sales.....................mailto://frank@syware.com
SYWARE, Inc.................................http://www.syware.com
Tel: +1 617 497-1300.........................Fax: +1 617 497-8729
Mobile database tools for business and personal productivity
-------------------------------------------------------------------

Paul,

You can use RDA to synchronize SQL Mobile with SQL Express. You can also use
merge replication with either SQL Server 2005, SQL 2000, or MSDE. There is
also a 3rd party option for synchronization with SQL Mobile and SQL Server
at www.primeworks.pt that might be useful for you.

--
Ginny Caughey
..NET Compact Framework MVP


"Paul Aspinall" <paul@aspy.co.uk> wrote in message
news:hU2Pf.94060$Q22.37208@fe1.news.blueyonder.co.uk...
> Thanks to all who replied.
>
> Some very interesting options.
>
> I've implemented a desktop solution already in SQL 2000, but want to find
> a light-weight PocketPC DB to sync with.
>
> Are there any which can Sync with SQL 2000 (or MSDE / SQL Express)?? Are
> there any code samples??
> I may even consider changing my desktop DB engine, but MSDE / SQL express
> is doing fine, apart from the heavy footprint. I require Stored
> procedures.
>
> Any code examples of DB's on desktop and Pocket PC, and sync would be
> great. Or Pocket PC DB sync with MSDE.
>
> Thanks
>
>
> Paul
>
> "Hank" <sorry@no.com> wrote in message
> news:Oa9YrsWQGHA.5924@TK2MSFTNGP09.phx.gbl...
>> Not mentioned yet, but certainly 2 viable options are: Sybase/iAnywhere's
>> (SQL Anywhere Studio) Adaptive Server Anywhere database or UltraLite,
>> both work on the Pocket PC. The synchronization is quite granular and
>> robust but does take some coding. Works with several back end database
>> platforms. Pricing, last I checked was surprisingly affordable.
>>
>>
>> "Sergey Bogdanov" <sergey.bogdanov@gmail.com> wrote in message
>> news:%23VZu6mVQGHA.3672@TK2MSFTNGP14.phx.gbl...
>>> Take a look at this thread:
>>> http://groups.google.com/group/micr...83e643390e761a0
>>>
>>>
>>> --
>>> Sergey Bogdanov [.NET CF MVP, MCSD]
>>> http://www.sergeybogdanov.com
>>>
>>>
>>> Paul Aspinall wrote:
>>>> Hi
>>>> I want to write some apps for Pocket PC, which require a back end DB.
>>>>
>>>> What are the options with regards to choice of DB engine??
>>>> Pocket Access??
>>>> SQL Mobile??
>>>>
>>>> Anything else??
>>>>
>>>> Thanks
>>>>
>>
>
>

Paul

It depends on your requirements. If you need a professional, transaction
oriented, very robust solution that scales to thousands of mobile devices, I
can recommend the iAnywhere products (I use it myself). It can sync with MS
SQL Server, Oracle, IBM, Sybase and others.
It also allows you to concurrently use several versions of dabase schemas on
the mobile devices. As it is usually not possible to update your mobile
devices all at once, this is a very important feature.
Furthermore it also runs the database from an SD or CF card and prevents the
database from corruption even if you take out the memory card.

I't quite affordable but it's not freeware.


Markus Hofer
Smart Solutions AG

(I'm not affiliated with Sybase / iAnywhere)


"Paul Aspinall" <paul@aspy.co.uk> wrote in message
news:Ar0Pf.93888$Q22.35602@fe1.news.blueyonder.co.uk...
> Hi
> I want to write some apps for Pocket PC, which require a back end DB.
>
> What are the options with regards to choice of DB engine??
> Pocket Access??
> SQL Mobile??
>
> Anything else??
>
> Thanks
>
>

As fas as I understand, SQL Server Express Edition only can act as
Subscriber when using Merge Replication, can't it? Are you sure MSDE
could act as Publisher also using Merge Replication?

I also didn't know I could use RDA to synchronize SQL Mobile with SQL
Express. I thought SQL Express was really limited when replicating,
both for Merge Replication and RDA.

Regards.