Friday, March 9, 2012

Merge replication ignores some records

Pls advise,
i use merge replication as pull, in replication data including some image
data.
Few records are just ignored and they do not appear in subscriber database,
what i can do to make the databases fully synchronized?
Mndr
How are you inserting the image data? If you are using the WRITETEXT and
UPDATETEXT, you will have to create a trigger that will update the row for
merge replication to pick up these changes/updates.
Also are you doing any form of filtering? Sometimes you filters will not
resolve correctly.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Malgorzata Ndreu" <mndreu@.maritweb.com> wrote in message
news:uj%23CXFhLFHA.3512@.TK2MSFTNGP15.phx.gbl...
> Pls advise,
> i use merge replication as pull, in replication data including some image
> data.
> Few records are just ignored and they do not appear in subscriber
database,
> what i can do to make the databases fully synchronized?
> Mndr
>
|||We have this same issue but belive it is related to snapshot creation every
night. If a user downloads a new snapshot and fails to syncronize before a
new snapshot is created, the changes to the database between snapshots will
not replicate to the to the user. What causes this?
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OVLbUsiLFHA.2648@.TK2MSFTNGP14.phx.gbl...
> How are you inserting the image data? If you are using the WRITETEXT and
> UPDATETEXT, you will have to create a trigger that will update the row for
> merge replication to pick up these changes/updates.
> Also are you doing any form of filtering? Sometimes you filters will not
> resolve correctly.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Malgorzata Ndreu" <mndreu@.maritweb.com> wrote in message
> news:uj%23CXFhLFHA.3512@.TK2MSFTNGP15.phx.gbl...
> database,
>
|||The snapshot might be created each night, but it will only be sent to
subscribers who are new or who require an reinitialization. It is unlikely
that this is your problem.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Fast Eddie" <e@.bellsouth.net> wrote in message
news:52o0e.74802$%Y4.50101@.bignews6.bellsouth.net. ..
> We have this same issue but belive it is related to snapshot creation
every
> night. If a user downloads a new snapshot and fails to syncronize before
a
> new snapshot is created, the changes to the database between snapshots
will[vbcol=seagreen]
> not replicate to the to the user. What causes this?
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:OVLbUsiLFHA.2648@.TK2MSFTNGP14.phx.gbl...
for[vbcol=seagreen]
image
>

No comments:

Post a Comment