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

SQL Anywhere 10.0.1 » UltraLite - Database Management and Reference » Creating and Configuring UltraLite Databases » Configuring database options in UltraLite

UltraLite remote ID considerations Next Page

UltraLite global database ID considerations

The global ID sets a starting value for GLOBAL AUTOINCREMENT columns in order to maintain primary key uniqueness when synchronizing with the MobiLink server. If a row is added to a table and does not have a value set already, UltraLite generates a value for the column by combining the global_database_id value and the partition size. See Using global autoincrement.

To set/reset a global database ID in Sybase Central
  1. In the Folders view, right-click the UltraLite database you have connected to, and choose Options from the popup menu.

    The Database Options dialog appears.

  2. Select the global_database_id table entry.

  3. In the Value field, type the new value for the ID.

  4. Click Set Now to save your changes.

  5. Click Close.

See also