Desktop sync to PDA

  • Thread starter Thread starter msnews
  • Start date Start date
M

msnews

We're writing an app and we need a method of dumping data (customers,
pricelists, inventory) from the desktop accounts system into an Access or
SQL CE database programaticaly

Also need to (from the Desktop) import orders created on the PDA back into
the accounts system

Whats the best method for doing this ?
 
If the data on the desktop is in a SQLServer database, you can use either
merge/replication or RDA to move data between SQLServer and SQLCe on the
device.
 
The data is in a 3rd party accounts app which I have read only ODBC access
:-( so what i was looking to do was pull htat data into a DataSet then make
a connection to the PDA and dump it in to SQL CE

As far as I know the client doesnt have SQL Server on the accounts PC so
that not an option.
 
So how do I make a connection from the Desktop to the DB on the PDA ? I
presume I use RAPI ?
 
You cannot access SQL CE from the desktop.

What I did was dumped the data from the desktop to XML files, then
transferred the XML files to the PDA using RAPI. Then in the PDA application
read the XML files into SQL CE. Did the reverse for transferring data from
PDA to desktop.
 
Hi,

I'm doing something similiar with dbf files on the desktop, I process the
dbf files in the way I want, convert them to txt files, rapi them to the pda
and then read the txt files back into a SqlCe database. Do the opposite
going the other way. Then the desktop program reads the changed records back
into the dbfs. I keep track of the last sync datetime to minimise what gets
moved. The whole process only takes about 30 secs.

I would avoid XML, if the data you want to move back and forth is large.

Graham
 
Back
Top