Inserting new records from multiple mobile users

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Polaris431 - 25 Feb 2007 09:56 GMT

When using merge replication and all subscribers use the same
subscription and when two or more subscribers insert new records, does
replication on the server automatically modify the unique ID field for
that record. In other words, if mobile user A inserts a record and the
ID field automatically gets set to 5 and then mobile user B also
inserts a record into the same table and the ID also gets set to 5,
will replication at the server automatically reassign the ID so that
no conflicts take place. After replication is completed, the record
that gets sent to mobile user A might be 10 and the one sent to mobile
user B might be 11. Is this how replication works when inserting data
using merge replication?

Thanks for you help
Polaris

Reply to this Message

Hilary Cotter - 25 Feb 2007 12:59 GMT

No, unless you use automatic identity range management or some form of
partition all subscribers will enter the same value and you will have
primary key collisions which will result in conflicts.

Signature

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

> When using merge replication and all subscribers use the same
> subscription and when two or more subscribers insert new records, does
[quoted text clipped - 10 lines]
> Thanks for you help
> Polaris

Reply to this Message

Polaris431 - 25 Feb 2007 15:15 GMT

>From what I read on "automatic identy range management", you define a

range of IDs for each subscriber. Of course, what happens once your
run out of IDs on the client side?

> No, unless you use automatic identity range management or some form of
> partition all subscribers will enter the same value and you will have
[quoted text clipped - 23 lines]
>
> - Show quoted text -

Reply to this Message

Hilary Cotter - 26 Feb 2007 00:25 GMT

On SQL 2000 all inserts after exceeding the allotted range would be rolled
back. In SQL 2005 there is a 100% buffer before the inserts get rolled back.

Keep in mind that each time you run a sync the range is incremented, so if
you sync before you exhaust your range and you are over the threshold your
range should be incremented.

Signature

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

> >From what I read on "automatic identy range management", you define a
> range of IDs for each subscriber. Of course, what happens once your
[quoted text clipped - 29 lines]
>>
>> - Show quoted text -

Reply to this Message