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] >-----Original Message-----
>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).
[quoted text, click to view] >
>The data should flow from HEADOFFICE to COUNTER and later
to handheld device.
>
>HEADOFFICE -----> COUNTER --------> Handheld Device
>HEADOFFICE <----- COUNTER <-------- Handheld Device
>
>We have been able to synchronize INSERTS and UPDATES
between all three databases in HEADOFFICE, COUNTER and
handheld device.
[quoted text, click to view] >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.
[quoted text, click to view] >The rowguid of the deleted row appears in
Msmerge_tombstone table on COUNTER but HEADOFFICE does not
delete the data from database.
[quoted text, click to view] >
>
>Please let us know in case any further clarification is
required.
>Anyone, who has encounted similar situation may please
provide pointers to solution.
>
>
>
>
>.