Need help on Data synchronization application

Ok, Now I assume that its a database near about 5 GB and increment on regular basis about 0.09%.

I also assume that its reside on remote that mean two databases cant talk directly.

Few prerequisites :

Each Table you need to synchronize they should have one primary key.

Using WCF

1. Create One Table in another database which we will use as a witness, the table will contain few columns like Role Id,DB Id,DB Name, Role,Table Name, Sync Group name,Type (Push/Pull).
Another table with Mapping, columns are Role Id,Column Name,Alias Name, IsActive
Another Table with synchronized Details Role Id,Counter,Date

2. Create two WCF services One for pulling data and another for pushing data.
3. First service will first pick the max counter from synchronized details then pull incremental data from there server depending on mapping connection string will resides on server with the name Role Id but its should be encrypted and there should be a default connection string which will connect witness server.
4. First service will pull the data from server and serialize it with a key ( which will be generated at run time Unique) and notify the User/WCF (as required)
5. Second service will push the as notify with the key and read from the derive and insert or update or delete data depending data state. That serialize data will have role id and incremental id of depending synchronization table.
6. when sync will complete second service will update synchronized details table with the counter.


If you have any query feel free to ask me,