Unusual Data Synchronization between Server and PPC

[Javawzl]

I want to sync data residing on a remote Windows server in
a database (could be MySQL, Access, SQL Server, etc.) with
data on a PPC 2002 (and above). Ideally, synchronization
will take place *only* when the PPC is docked and
ActiveSync is started -- in a nutshell, I would like to do
something similar to what Avantgo does. At this point I am
uncertain how to store the information on the PPC - but
lets assume I use SQL CE. I envision a conduit on the
desktop which will pull the database information (whole or
partial) through a *script* (ASP, ASP.Net, etc. - maybe
even a web service) in XML format and somehow sync this
with the data residing in SQL CE on the PPC - all of this
being triggered when the user docks their PPC and
ActiveSync starts - possibly use ActiveSync pass through?
I know there are some posts similar to this .. but the big
difference in my case is that the server data is only
accessible through a script.

Anybody got some good (simple) ideas how to do this?
Examples, books, white papers, etc.?

 

[rdebault]

I currently use the pass through function to achieve
sychronization with multiple data base types. This allows
the user to either use a wireless internect connection or
the pass through in activesync. I have sqlce database on
the pda and the main application program makes calls to a
web service which in turn updates the data on the pda.
The average database size on the PDA is 40 MEG. This is a
broad overview but if your interested I can send you a
flow diagram.......