Create Synchronization Model Wizard: Primary Key Requirements page

In a synchronization system, the primary key is the only way to identify the same row in different databases (remote and consolidated) and the only way to detect conflicts. Therefore, MobiLink applications must adhere to the following rules:

  • Every remote table that is to be synchronized must have a primary key.

  • Never update the values of primary keys.

  • Primary keys must be unique across all synchronized databases.

The Primary Key Requirements page of the Create Synchronization Model Wizard reminds you that your applications and databases need to meet the primary key requirements for MobiLink synchronization. You cannot continue to the next page of the Create Synchronization Model Wizard unless the three primary key conditions are selected. See Unique primary keys.

This page has the following components:

  • All my tables have primary keys   Select this condition to confirm that all of your remote tables have primary keys.

  • My applications do not update primary keys   Select this condition to confirm that your applications do not update primary keys.

  • I have ensured that new rows have unique primary keys   Select this condition to confirm that you ensured that new rows have unique primary keys.

  • Do not show this Primary Key Requirements page again   Select this option if you do not want this Primary Key Requirements page to appear again. This option can also be changed from the Plug-in Preferences page of the MobiLink plug-in for Sybase Central.

 See also