Data Synchronizing with Active Sync

[Antoo]

Hi,
I'm new embedded development and synchronization.
Is it possible to synchronize the databases between the
device and desktop by using Active Sync. I use SQL CE 2.0
and SQL 2K. When the device is cardled I want to sync the
data between the two databases automatically. Moreover I
want to filter the data to pull from desktop to device.

Thank.

 

[Girish NS]

Hi,

You have to write a custom activesync provider to accomplish ur task. Custom
providers can be written only evc++.

Check out the following link for detailed description into programming
activesync providers
http://www.msdn.microsoft.com/libra...y/en-us/dnce21/html/ActiveSync.asp?frame=true

u can also use features provided by sql server ce like Remote Data Access
(RDA) and Merge Replication or web services for synchronizing data

Girish.

 

[Joe Audette]

There are also ways of synchronizing without ActiveSync.
If the device has a network connection you could use a
web service to send and retrieve data from a SQL database.
I think there is also a way to do it with merge
replication.

Good examples in the articles at
http://smartdevices.microsoftdev.com/default.aspx

Best Regards,

Joe Audette