Choosing the right DBC for PocketPC

  • Thread starter Thread starter info
  • Start date Start date
I

info

Hi

I'm developing an software which should run on a pocketPc.

the software is synchronizing with an desktop which has data in an
specific file format.
The synchronisation process itself is implemented via RAPI.

so know theres the question on using which database?

I know theres the MS SQL Mobile5 but when I want to change somewhen to
get the data from an SQL Server I would have to pay for it right ?

What alternatives are there? I heard there is some of oracle right ?
Which one is the right? how are there licensing costs?


And somewhen I heard theres an free database which schould also be fast
?

I would be really thankfull if someone could give me some hints


Thanks in advance!
 
Hi,
if you you MS SQL Mobile standalone, it's free of charge. If you use
the replication with "big" SQL Server, you have to buy a client license
for each user or buy a processor license.

There's also the Oracle Light (we use at one customer implementation) -
it can synchronize the data between the mobile devices and the Oracle
Database on the server. It can also handle synchronization of device
applications and support some specific commands for device management
(MSSQL does not support this). Unfortunatelly Oracle changed licensing
of this product in the summer so as it's not efficient to use it in
environment with less than some 30-40 clients (in comparison with MSSQL
or OneBridge).

One other solution we're going to implement at one of our customers in
few weeks is Extended Systems OneBridge. It can handle synchronization
of Lotus Notes or Exchange, it can also handle device management and
application distribution very comprehensively and it can be configured
to synchronize also the data between some PDA database engines and
desktop database. It supports quite a lot of engines and even can be
configured with custom database drivers afaik. Our customer has an
oracle server and we're going to synchronize the data with MS SQL
Mobile on the PDAs...

To your free-database note - there's the MSSQL Mobile which is free
when used without MSSQL replication. There's also a port of SQLite for
CF2. But in both cases, you have to solve the synchronization somehow
and I don't know about any free sync-system :(



(e-mail address removed) napsal:
 
You can move the SDF file to the desktop PC (and back) , and use oledb to
handle the sync your own way.
You have got to provide a user inteface for handling conflicts anyway and
you would not want a fully normalized database but use some redundancy (for
performance reasons ) on your PPC

hth,

Erik
 
Back
Top