Data Syncronization in a client server architecture

See more:

C#

.NET

C#4.0

synchronize

Hi all,

My friends are working on a project where they have a website attached to main database on server and they have individual client application attached with local database for transaction.

Say they are working on hotel domain where they want their client application to have transactions locally when they are offline and finally they want to sync it with database on server.

Initially what I thought is to create a database transaction log which will record everything and then pass all tables data in xml to a wcf service which will update database on server and then server will make call and update all local db.

But after goggling a bit I came to know that there is already Microsoft .net sync framework exists which will do this job for you.

But I read few disadvantages of it as it will have issue when tables have identity column as primary key.

But my client applications already have a database I don’t want to create a cache database. I directly want to sync my local database with a wcf service as intermediate layer.

I found lots of tutorial but none of them give good guide line how to work with sync framework?

Thanks