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

SQL Anywhere 11.0.1 » 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