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

SQL Anywhere 12.0.0 » MobiLink - Server Administration » Using MobiLink server technology » Synchronization techniques » Maintaining unique primary keys » Using global autoincrement


Setting the global database ID

When deploying an application, you must assign a different identification number to each database. You can create and distribute the identification numbers by a variety of means. One method is to place the values in a table and download the correct row to each database based on some other unique property, such as remote ID.

 To set the global database identification number
  • In SQL Anywhere, you set the global ID of a database by setting the value of the public option global_database_id. The identification number must be a non-negative integer. See global_database_id option.

    In UltraLite, you set the global ID of a database by setting the global_id option. See UltraLite global_database_id option.

 How default values are chosen
 See also