all groups > sql server msde > january 2005 >
You're in the

sql server msde

group:

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


Re: SQL CE sync with MSDE (ie. running on XP Home, with no IIS) Ginny Caughey [MVP]
1/14/2005 10:02:37 AM
sql server msde:
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#.
--
Ginny Caughey
..Net Compact Framework MVP
[quoted text, click to view]

Re: SQL CE sync with MSDE (ie. running on XP Home, with no IIS) Ginny Caughey [MVP]
1/14/2005 10:17:15 AM
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.
--
Ginny Caughey
..Net Compact Framework MVP
[quoted text, click to view]

SQL CE sync with MSDE (ie. running on XP Home, with no IIS) Paul Aspinall
1/14/2005 12:08:44 PM
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

Re: SQL CE sync with MSDE (ie. running on XP Home, with no IIS) Paul Aspinall
1/14/2005 3:08:30 PM
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]" <ginny.caughey.online@wasteworks.com> wrote in
message news:OKDbXok%23EHA.208@TK2MSFTNGP12.phx.gbl...
[quoted text, click to view]

AddThis Social Bookmark Button