Merge Replication!

Can someone please advise what would be appropriate method when you want to
implement the merge replication (Kind of a Real time) between different
databases sitting on separate servers.
Is Auto Incremental Field which is PK would be a problem when two users try
to enter records at same time. For example in table#1 user "A" enter some
values at row#3 and got the Id 3,
While at the same time the users "B" in table#2 enter some values at
row#3...would he got Id 3 ? and how it would get replicated.
Do I need to use GUID as PK or some other suggestion?
Shan
Merge replication does not provide real time replication, use automatic
identity range management to avoid the pk conflicts. To do this, drop all
publications where the table you want to bring under automatic identity
range management is publisher. In the publication wizard when you come to
the specify articles dialog box, click on the browse button to the right of
your table name, and select the automatic identity range management tab.
Select a publisher and subscriber range which matches that maximum number of
inserts which might occur between agent syncs, and then make sure your
agents do not run continuously.
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
"Shan" <Shan@.discussions.microsoft.com> wrote in message
news:C97F8918-2523-4064-A6EB-F7C1D7D67BE2@.microsoft.com...
> Can someone please advise what would be appropriate method when you want
to
> implement the merge replication (Kind of a Real time) between different
> databases sitting on separate servers.
> Is Auto Incremental Field which is PK would be a problem when two users
try
> to enter records at same time. For example in table#1 user "A" enter some
> values at row#3 and got the Id 3,
> While at the same time the users "B" in table#2 enter some values at
> row#3...would he got Id 3 ? and how it would get replicated.
> Do I need to use GUID as PK or some other suggestion?
> --
> Shan

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
>