Modifying table and column mappings

Table mappings indicate which tables should be synchronized, how tables should be synchronized, and how the synchronized data should be mapped between the consolidated and remote databases.

Upload-only, download-only, and non-synchronized tables or columns

By default, MobiLink does a complete, bi-directional synchronization. You can change each table to be upload-only or download-only. You can also choose to not synchronize a table, which removes its table mapping.

In a synchronization model, you can only specify tables as download-only; you cannot create download-only publications.

Change the table mapping direction

In the Folders view of Sybase Central, expand MobiLink 12, your MobiLink project name, Synchronization Models, and then select your synchronization model name.
Open the Mappings tab in the right pane.
In the Table Mappings pane, select a consolidated table.
In the Mapping Direction dropdown list, select one of the following:
- Not synchronized. Choosing this option is the same as deleting the table mapping.
- Bi-directional
- Download to Remote Only
- Upload to Consolidated Only

Remove a table mapping

In the Folders view of Sybase Central, expand MobiLink 12, your MobiLink project name, Synchronization Models, and then select your synchronization model name.
Open the Mappings tab in the right pane.
In the Table Mappings pane, select a table mapping.
In the Mapping Direction dropdown list, click Not Synchronized. The mapping is deleted the next time you save the synchronization the model.

Changing table and column mappings

If your model is based on an existing remote database, the table and column mappings represent a best guess. You should check them and customize them as required.

Change table mappings

In the Folders view of Sybase Central, expand MobiLink 12, your MobiLink project name, Synchronization Models, and then select your synchronization model name.
Open the Mappings tab in the right pane.
In the Table Mappings pane, select a table mapping.
To change the remote table that is mapped, from the Remote Table context menu, select a different table from the list of unsynchronized remote tables.
- You can only choose remote tables that are not already mapped to consolidated tables.
- If you want to add tables to your remote schema, see Updating schemas.
To add a table mapping for an unmapped consolidated table, use File » New » Table Mappings to open the Create New Table Mappings window where you choose the tables. To avoid any changes to the remote schema, disable the option to also add corresponding tables to the remote schema if they do not already exist. If you want to add the tables but not all columns to the remote schema, enable the option to let you choose the columns.

By default consolidated database tables with names like synchronization model shadow table names are not shown, since such shadow tables should not be synchronized.

You can map a column in a synchronized consolidated table to a remote table column, a value determined when synchronizing, or exclude the column from synchronization. When mapping to a value, you can use the MobiLink user name, the remote database ID, or a SQL expression (which can include MobiLink named parameters). When you map a primary key column to a value and the table mapping is bi-directional, you need to prevent duplicate primary keys when downloading to remote databases.

Change a column mapping for a table mapping

In the Table Mappings pane, select the table mapping.
In the lower pane, open the Column Mappings tab.
Right-click the column mapping you want to change, and select one of the following from the context menu:
- None
- MobiLink User Name
- Remote ID
- Custom
- An unmapped remote column
To synchronize the consolidated column with a remote column, select the unmapped remote column from the bottom group of the menu. Only unmapped remote columns are listed.

To exclude the consolidated column from synchronization, click None. The Direction icon shows that the consolidated column will not be synchronized.

To map the consolidated column to a value, you can choose the MobiLink User Name, the Remote ID, or use Custom to enter a SQL expression that is evaluated when the remote table's upload_insert, upload_update and upload_delete synchronization scripts are executed during the synchronization. The Direction icon shows that the value will only be uploaded; the consolidated column will not be downloaded to the remote database.

Discuss this page in DocCommentXchange.