Posted by Plamen Ratchev on 05/07/07 12:25

The two main methods for synchronizing data between SQL Server Compact
Edition and other editions are RDA and merge replication. However, I believe
both require IIS in order to work.

Two alternatives:

- Using the ADO.NET Sync Framework (still in CTP). Here are a few links with
info on that:
http://oakleafblog.blogspot.com/2006/11/adonet-sync-framework-for-occasionally.html
http://blogs.msdn.com/stevelasker/archive/2007/01/23/sync-services-for-ado-net-ocs-ctp-now-available.aspx
http://www.microsoft.com/downloads/details.aspx?familyid=75FEF59F-1B5E-49BC-A21A-9EF4F34DE6FC&displaylang=en

- Develop your own synchronization process. Depending on your requirements
it could be an easy or difficult task. For example, I had a system where
mobile users could change data in only two tables (plus data had some level
of segmentation between users). It was a pretty straight forward process to
compare and synchronize data.

You may get more help and ideas posting in microsoft.public.sqlserver.ce.

HTH,

Plamen Ratchev
http://www.SQLStudio.com

[Back to original message]