Table mappings indicate which tables should be synchronized, how tables should be synchronized, and how the synchronized data should be mapped between the remote and consolidated databases.
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.
In a model, you can only specify tables as download-only; you cannot create download-only publications. This is because a model can have only one publication.
To change the table mapping direction
In Model mode, open the Mappings tab.
In the Table Mappings pane, select a remote table.
In the Mapping Direction dropdown list, select one of the following:
By default, shadow tables are not synchronized. Do not attempt to synchronize them.
If necessary, select a consolidated table to map to from the Consolidated Table dropdown list.
To not synchronize a column
In Model mode, open the Mappings tab.
In the Table Mappings pane, select a table.
Column information for the table appears in the Column Mappings tab in the lower pane.
Select a column.
In the Mapping Direction dropdown list, choose Not Synchronized.
Primary keys must be synchronized.
If your model is based on an existing remote database, the column mappings represent a best guess. You should check them and customize them as required.
To change table mappings
In Model mode, open the Mappings tab.
In the Table Mappings pane, select a table.
To change the consolidated table that is mapped: From the Consolidated Table dropdown list, select a different table.
To change the remote table that is mapped:
To change column mappings for a table: Select the table, and open the Column Mappings tab in the lower pane.
| Send feedback about this page via email or DocCommentXchange | Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0 |