Question about Synchronization

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike Doyle - 04 Jun 2008 22:30 GMT

Hi,

I'm a newby to SQL CE Synchronization with Windows Mobile / SQL Server, I
gather the approaches are RDA over IIS and Web Services over the IP. There
seems to be a lot of examples of RDA but I am struggling to find samples of
Synchronization using Webservices. Can anyone help?

Thanks,

Mike

Reply to this Message

James Woodruff - 05 Jun 2008 13:48 GMT

> Hi,
>
[quoted text clipped - 6 lines]
>
> Mike

Do not forget Merge Replication, although I have personally dropped this
from our system because it takes up to much expensive bandwidth on our PDAs.
Does anyone know whether Web Services is more efficent than RDA?

Reply to this Message

Chris - 11 Jun 2008 01:25 GMT

I am relatively certain RDA/Merge Replication is more efficent than web
services are, simply because standard web services use XML and represent
data textually, replication does not (binary data).

That being said, we moved away from Merge Replication too because we
wanted schema flexibility. We mitigated the performance hit by
implementing compression on the outgoing (and incoming on the client
side) stream. This was done using a SOAP extension class.

Chris

> Do not forget Merge Replication, although I have personally dropped this
> from our system because it takes up to much expensive bandwidth on our PDAs.
> Does anyone know whether Web Services is more efficent than RDA?

Reply to this Message