Syncing with remote db

[John]

Hi

We have an access db running on a windows 2003 server. The server is
connected to the internet via ADSL. I would like a windows mobile 2003 based
vb.net app to sync data from the server, ideally via gprs, from time to
time, the pda and the server have the same info. What is a good way to go
about doing the data sync between the pda and the server? Do we have to
upsize the server access db to sql server before it can sync with pda sql
server ce, or can we keep the access app as it is?

Thanks

Regards

 

[Alex Feinman [MVP]]

You can keep it in Access if you implement manual synchronization using a
web service

 

[Jon Brunson]

You can keep it in Access if you implement manual synchronization using a
web service

Care to elaborate on that a bit? We're doing the same thing, and have
found it really difficult to find a good, fast, reliable way of syncronizing

 

[Alex Feinman [MVP]]

What I meant is writing a web service that would accept data from your app
in your own format and decide internally how to merge it with the database.
Pretty much what merge replication does but probably simpler since you don't
require that much versatility

 

[Rick Winscot]

Jon,

Have you ever thought of using storage classes and serializing the data? If
you use this method - you can just copy the file from the PPC to the Desktop
and since you are using the same object definition... there is no other
layer / translation involved. I guess it would be important to decide
exactly how you would like to synchronize the data... 802.11x, ActiveSync
(wired), etc. After you decide how the job gets done - we could go into
greater detail of what options might give you the best bang for your buck.
By the way - how many records are we talking about?

Rick Winscot
www.zyche.com