SQL CE sync with MSDE (ie. running on XP Home, with no IIS)

[Paul Aspinall]

Hi,

I am trying to write an app that will run on XP Home (ie. no IIS), using
MSDE, but which will sync to SQL CE.

Can anyone offer some pointers or code samples (prefer C#), on how to do
this. All the articles I can find seem to suggest using replication, or RDA,
but both appear to use IIS, and SQL 2000.

Any help appreciated.

Thanks



Paul

 

[Ginny Caughey [MVP]]

Paul,

All the canned syncing strategies do require IIS for the plumbing. Have you
considered writing a device app that exports the data from SqlCe to XML or
CSV format, then copying that file to the device where a desktop app could
to the syncing? You could write both apps in C#.

 

[Paul Aspinall]

Thanks for the reply.

I was 'sort of' coming round to your suggestion, as I was concluding that it
seemed IIS was necessary for everything else.

As you suggest I could spool data down to XML, and manually determine
merges. However, how could this work practically?? ie. I want the user
simply to connect the PDA to the PC, and everything happen. How would the
file get transferred for update. Is there a routine which I can hook into in
order to fire the file accross, and perform merges?

Thanks

 

[Ginny Caughey [MVP]]

Paul,

Look at the Rapi class on www.opennetcf.org. Rapi apps can be written to
wait until there is a connection if you use CeRapiInit rather than
CeRapiInitEx. Typically you'd write such a Rapi app to run as a service,
similar to what ActiveSync does.