SQL CE/XML/ or any other better option fo a disconnected application

[Atul Malaviya]

Hi All,

we are developing an application for PocketPC which is supposed to work in a
disconnected environment and it will synchronize with a desktop
application(db) on frequent basis.

we want to avoid RDA/Merge Replication features of Sql CE for synchronizing
data with the desktop b'cos of the complications involved with setting up
merge replication and the IIS on the desktop (customer may not have IIS or
SQL).

we thought about using XML files for storing and transfering data between
desktop and Pocket PC application (using activesync). But the XML file size
increases considerably with the amount of data we want to store, also we are
not sure of the sorting filtering performance.

we are using CF.Net, we are not too interested in ADOCE wrappers for using
Pocket Access database (cdb files), Since its/will be discontinued.

Is there any better way of doing the same.

[1] Any alternative to XML Files, like binary files?

[2] Any free db's which have the ActiveSync file conversion option?

[3] Any brighter ideas?



Thanks in advance

 

[Alberto Silva]

Hi,
You can use SSCE on the device completelly disconected on the device side,
and use your own synchronisation logic. I use XML over TCP/IP for the
synchronisation of SSCE tables on the device to whatever is on server
(SQLserver, Interbase, Access, text files, xml files, mixed, ...)
Since I can't provide you my 'engine' for free (completelly customisable of
tables to be copied from and to the device, synchronisation of changes on
server side, restore of broken connections, etc.), if you're interested
please email me at (e-mail address removed) . I'll charge at least
500USD/EUR...

Regards,
Alberto Silva

 

[boomerang]

Hi,

Try PocketSYNC

http://www.efeyazilim.com/pocketsync