Bi-directional database synchronization

Anyone can give some advice on C# frameworks/opensource projects for bi-drectional database synchronisation?

I have an application that will be used by multiple users. Normally, the user will interact with the application's local database (MS ACCESS) as we assume the network is not available on-site most of the time. When the user has network connectivity, the local database is to be synchronised with the centralised remote database (MS SQL). In the end, all users are able to read/write/commit each others' data. It very much like a SVN r开发者_运维百科epository, i think.

Has anyone tried http://msdn.microsoft.com/en-us/library/bb629326.aspx? how does it fare? I have not really look into it, i am trying to look for more options first before evaluating each.

Thank you.

Have you looked at the Microsoft Sync Framework?

It was designed with scenarios like yours in mind.

• Introduction to Microsoft Sync Framework

• Sync Framework Samples

• Walkthrough: Creating a Sync service

• Walkthrough: Creating a Sync Service in Windows Azure