I have a situation where I am struggling with data synchronisation. Using the merging functionality of a dataset with DataTables, my app is able to run in offline mode and synch back to the SQL server database using the AcceptChanges and Merge operations. When calling the merge operation, you can PersistChanges. When you do that, what is in the offline datasets overrides the database. When you do not persist changes, what is in the database overrides the local inline changes.
Now, this is fine for a single user but what if the application (a time management console in my case) was installed on multiple servers and the database is updated by multiple instances of the application?
I know Microsoft Synchronisation services used to handle this, but now I am stuck. I could get column changes and populate a temporary table with changes processed by a job or windows service. However, is there an easier way?
FYI, I use a Telerik radGrid to display activity data with numerous other tables that run in memory such as client/project/content data. However, the main data I am trying to sync is the activities.
Has anyone been able to achieve something similar by using datasets and the DataTable merge operation? I would love to hear from you.