Problems with merge replication
Posted
by
jess
on Server Fault
See other posts from Server Fault
or by jess
Published on 2010-10-20T20:40:31Z
Indexed on
2011/01/01
17:56 UTC
Read the original article
Hit count: 293
sql-server-2008
|merge-replication
Hi,
We are developing a multi-user desktop application with users located in different countries. The platform is - .net 3.5, SQL Server 2008, WinForms. Now, my client has used the help of a DBA who has implemented merge replication. To facilitate replication, we made all our primary keys as GUID. Now, we are facing these issues with replication -
subscribers expiration sometimes stops replication and we have found no clean way to re-add every change to db schema requires to poll the whole data all over again! This seems to be strange, what could be the problem here? Also, sometimes we have duplicate keys, and that too stops replication I am sure these issues can be resolved. Maybe, we have not gone the right way to implement. Can you suggest how to go about implementing. Or, is the above information enough to diagnose the problem?
© Server Fault or respective owner