Suggested reading : Larry Roof and "The definitive guide to the .NET Compact
Framework", by Apress. It's a complicated topic that you best learn out of a
book. Setting up Replication or RDA is a pig, it involves IIS on the server,
and the SSCESA20.DLL (I kid you not).
I have remote access to SQL server database working, using RDA. RDA Pull
gets the data via stored procedures. It creates the tables locally without a
fuss, it's cool. Just add your indexes afterwards.
I use the rda.submitsql to upload data, rather than the push method. The
reason I like this is that I can work out what needs to be uploaded on the
device, and then call stored procedures with parameters using this command.
One performance tip though, build a string with multiple calls, and execute
that.
eg
' Slower
rda.submitsql("exec myinsert 1", cn)
rda.submitsql("exec myinsert 2", cn)
....
'Faster
rda.submitsql("exec myinsert 1 ; exec myinsert 2 ; ...", cn)
Obviously there is some sort of string length limit here to watch out for (I
don't know what that is). At least, this is what I have found! Others may
disagree, but I hope what I have said helps.
Regards,
Saul