How to save primary key during replication?

V

vladshela2017-09-05 16:29:10

Database

vladshela, 2017-09-05 16:29:10

How to save primary key during replication? So that in different replicas they do not coincide and do not break foreign keys.

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

K

Konstantin Tsvetkov, 2017-09-05
@tsklab

How to save primary key during replication?

There are two ways: range (that is, a range of primary keys is allocated for each replica, if this is an integer, when using it - the next one), 3000, for example, in MS SQL; use GUID is a unique binary number, and no two computers in the world will create two identical values ( uniqueidentifier , for example).