all groups > sql server replication > november 2003 >
You're in the

sql server replication

group:

Merge Replication-Deletion of row from SQL CE is not getting replicated


Merge Replication-Deletion of row from SQL CE is not getting replicated Ajit
11/14/2003 12:26:05 AM
sql server replication: We are using Merge replication to synchronize data. It is done between two SQL 2000 servers and SQL CE

The Architecture is as follows
There is one head-office (HEADOFFICE) SQL 2000 server which is a publisher and replicates data with one counter (COUNTER) SQL Server 2000. The COUNTER server has Pull Subscription for HEADOFFICE. The COUNTER server also acts as a re-publisher and publishes same data to handheld devices(SQL CE and anonymous subscribers)

The data should flow from HEADOFFICE to COUNTER and later to handheld device

HEADOFFICE -----> COUNTER --------> Handheld Devic
HEADOFFICE <----- COUNTER <-------- Handheld Devic

We have been able to synchronize INSERTS and UPDATES between all three databases in HEADOFFICE, COUNTER and handheld device.
We are also able to synchronize any DELETES in HEADOFFICE and COUNTER to other databases.

However, in case when we delete any data from handheld device, the deletion is being propagated to COUNTER but it does not get propagated to HEADOFFICE.
The rowguid of the deleted row appears in Msmerge_tombstone table on COUNTER but HEADOFFICE does not delete the data from database

Please let us know in case any further clarification is required
Anyone, who has encounted similar situation may please provide pointers to solution


Merge Replication-Deletion of row from SQL CE is not getting replicated Hilary Cotter
11/14/2003 12:03:01 PM
With republishing you must use merge from end to end, or
transactional from end to end. If you are using merge,
the guid must be the same for each row from end to end.

And you must do an initial sync that sends data from
HeadOffice to counter and then to the handheld devices.

Is this how you set it up? merge\transactional interfaces
can be created but they involve complex hacking.
[quoted text, click to view]
which is a publisher and replicates data with one counter
(COUNTER) SQL Server 2000. The COUNTER server has Pull
Subscription for HEADOFFICE. The COUNTER server also acts
as a re-publisher and publishes same data to handheld
devices(SQL CE and anonymous subscribers).
[quoted text, click to view]
between all three databases in HEADOFFICE, COUNTER and
handheld device.
[quoted text, click to view]
device, the deletion is being propagated to COUNTER but it
does not get propagated to HEADOFFICE.
[quoted text, click to view]
Msmerge_tombstone table on COUNTER but HEADOFFICE does not
delete the data from database.
[quoted text, click to view]
AddThis Social Bookmark Button