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 ?

I use datasets to move data between the 2 databases Desktop/PDA

"msnews" <msnews@> wrote in message
news:%(E-Mail Removed)...
> 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.
--
Ginny Caughey
..Net Compact Framework MVP

"msnews" <msnews@> wrote in message
news:%(E-Mail Removed)...
> 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 ?
>
>
>

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.

"msnews" <msnews@> wrote in message
news:%(E-Mail Removed)...
> 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 ?
>
>
>

So how do I make a connection from the Desktop to the DB on the PDA ? I
presume I use RAPI ?

"Shaun Wilde" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I use datasets to move data between the 2 databases Desktop/PDA
>
> "msnews" <msnews@> wrote in message
> news:%(E-Mail Removed)...
> > 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 ?
> >
> >
> >
>
>

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

"msnews" <msnews@> wrote in message
news:(E-Mail Removed)...
> 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.
>
> "msnews" <msnews@> wrote in message
> news:%(E-Mail Removed)...
> > 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 ?
> >
> >
> >
>
>