Which DB back end??

  • Thread starter Thread starter Paul Aspinall
  • Start date Start date
P

Paul Aspinall

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.
 
Also check out:

http://weblogs.asp.net/jgalloway/archive/2005/07/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 said:
Take a look at this thread:
http://groups.google.com/group/micr...amework.compactframework/msg/583e643390e761a0



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


Paul said:
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
Click to expand...
Click to expand...
 
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 said:
Take a look at this thread:
http://groups.google.com/group/micr...amework.compactframework/msg/583e643390e761a0


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


Paul said:
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
Click to expand...
Click to expand...
 
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 said:
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 said:
Take a look at this thread:
http://groups.google.com/group/micr...amework.compactframework/msg/583e643390e761a0


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


Paul said:
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
Click to expand...
Click to expand...
Click to expand...
 
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 said:
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
Click to expand...

--
-------------------------------------------------------------------
Frank Yacano, Sales.....................mailto://[email protected]
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 said:
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 said:
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 said:
Take a look at this thread:
http://groups.google.com/group/micr...amework.compactframework/msg/583e643390e761a0


--
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
Click to expand...
Click to expand...
Click to expand...
 
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)
 
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.
 
Lonifasiko,

I believe that MSDE can act as a merge replication publisher with SQL CE
although I haven't done it, but SQL Express cannot act as a merge
replication publisher. SQL Express and RDA do work, but I do not know if
that combination is officially supported.

You can also connect to SQL Express or MSDE using SqlClient when you have
the connectivity, but of course then you have to write your own syncing
logic, and as far as I know you miss out on the compression and encryption
that you get for free with RDA and merge replication.

HTH,
 
Keith,

You do not need a publication for RDA, but I don't have any tips unfortunately since I haven't tried it with SQL Express. I assume that it works as it does with SQL Server 2005, so any tutorials for using RDA with SQL Server should work. If it doesn't - well I doubt there is any official support for this.

--
Ginny Caughey
..NET Compact Framework MVP


Hi Ginny,
The MS docs specifically state that Express does not support publication - http://msdn2.microsoft.com/en-us/library/ms165686.aspx. Do you not need a published db to use RDA? Do you have any tips about this? I am looking for two way synchronization, and I didn't think RDA was an option. Thanks,
Keith
 
RDA Seems to work with SQL Express... sort of. There are some problems
when using the 'tracking on' option that makes life difficult--right
now I have to delete my entire mobile database before 'pulling' tables
in because I can't make it work as advertised.

I have read numerous posts in various newsgroups by CF MVP's who swear
up and down that SQL Express does not support RDA, so perhaps this is
the reason.

Conclusion: it works, sort of. If you use the 'tracking off' option,
you shouldn't have any problems. That might not cut it for you though.

-Kevin
 
Hi,

KevinD said:
RDA Seems to work with SQL Express... sort of. There are some problems
when using the 'tracking on' option that makes life difficult--right
now I have to delete my entire mobile database before 'pulling' tables
in because I can't make it work as advertised.
Click to expand...

I am using RDA with SQL 2005 Express and I don't have to erase the entire
database before pulling tables while using "Tracking On" (i.e., it works as
advertised.) However, my combination is SQL Server CE 2.0 w/ SQL Server 2005
Express. Are you using SQL Mobile? I wonder if they work differently.
Indeed, all I have to do is make sure that the table that I am pulling does
not already exist on the device side (which is how RDA should be used) but
under no circumstances do I have to delete the entire database before a
pull.

Marius
 
Back
Top