changing the sequence number of replicated data [message #75076] |
Wed, 25 July 2001 19:49 |
buntie
Messages: 1 Registered: July 2001
|
Junior Member |
|
|
I am getting deferred trxs on replication to master site because the value exist in the master table, how can I change the sequence number of the data going into the master table
----------------------------------------------------------------------
|
|
|
Re: changing the sequence number of replicated data [message #75077 is a reply to message #75076] |
Thu, 26 July 2001 20:01 |
andrew again
Messages: 2577 Registered: March 2000
|
Senior Member |
|
|
Probably the best way is to "partition" your existing sequence number generator e.g. so that Server A users 0-500000 and Server B uses 500001-999999. Alternately you could set the seq gererators to have an increment of 2 and use even numbers on one server and odd on the other.
----------------------------------------------------------------------
|
|
|