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.
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:
Bi-directional
Upload to consolidated only
Download to remote only
Not synchronized
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.
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.
Note that 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.
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:
If your remote database is based on the consolidated database, use the Create New Remote Table window. See Creating remote tables when the remote database schema is based on the consolidated database.
If your remote database is based on an existing remote database: from the Remote Table dropdown list, select a different table.
To change column mappings for a table: Select the table, and open the Column Mappings tab in the lower pane.
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |