Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 (Français) » SQL Remote » SQL Remote Replication Design » SQL Remote replication design and set up » Duplicate primary key errors

 

Global autoincrement columns

Use the GLOBAL AUTOINCREMENT default to assign each remote database a unique global database identification number.

When you specify the GLOBAL AUTOINCREMENT default for a column, the domain of values for that column is partitioned. Each partition contains the same number of values. For example, if you set the partition size for an integer column in a database to 1000, one partition extends from 1001 to 2000, the next from 2001 to 3000, and so on.

SQL Anywhere supplies default values in a database only from the partition uniquely identified by that database's number. For example, if you assigned a remote database the identity number 10, the default values in that database would be chosen in the range 10001-11000. Another remote database, assigned the identification number 11, would supply default value for the same column in the range 11001-12000.

See also

Declaring DEFAULT GLOBAL AUTOINCREMENT