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

SQL Anywhere 10.0.1 » SQL Anywhere 10 - Context-Sensitive Help » MobiLink Plug-in Model Mode Help » MobiLink Model mode » Mappings tab

 Mappings tab Next Page

Mappings: Table Mappings

The Table Mappings pane contains one row for each remote table. A remote table is mapped if a consolidated database is selected and the mapping direction is either Bi-directional, Upload to Consolidated Only, or Download to Remote Only.

The values in the columns show the values you chose in the Create Synchronization Model wizard, or the wizard's defaults if you did not make a choice. You can modify these values on a table-by-table basis by editing this table.

The Table Mappings pane contains the following columns.

Ordinal column    This column has no title. It numbers the gridlines in the table. If you change the sorting of the tables (by clicking column headings), the grid numbers do not change with the reorder. Icons appear in this column if a remote table has been added, marked for delete, or modified.

Status column    This column notifies you if there is an error, warning, or informational message for the table mapping. If an icon appears in this column, select the table mapping, and then open the Status tab in the Details pane to see the content of the message.

Remote Table column    This is the remote table that you are synchronizing in the remote database. The name of the remote table owner is included in parentheses.

You can mark a remote table for deletion by right-clicking the row in the Table Mappings pane and choosing Delete. The remote table is deleted when you save the model. Deleting a remote table means that it is not created when you deploy to a new remote database. See Modifying how deletes are handled.

You can add a remote table using the Create New Remote Tables dialog. See Modifying the remote database that your model will create.

Mapping Direction column    The direction of synchronization. The direction can be Not Synchronized, Bi-directional, Download to Remote Only, or Upload to Consolidated Only.

If the table mapping direction is Not Synchronized, then the table is still part of the remote database schema. When the model is deployed, the table is created on the remote, but no information will be synchronized to it. See Modifying table and column mappings.

If you don't want the table to created on the remote, delete the it from the model. See Modifying how deletes are handled.

See Upload-only and download-only synchronizations.

Consolidated Table column    This is the consolidated table that will be synchronized with the corresponding remote table. Synchronization occurs between these tables and the tables in the Remote Table column. You can change the consolidated table by clicking the column and choosing a different table from the list of consolidated tables.

Look at the Column Mappings tab in the Details pane to check how the remote columns are mapped to the consolidated columns for the selected table mapping.

Download Type column    You can view and modify the implementation in the Download Type tab in the Details pane. Your options in this column are:

Download Deletes column    If this checkbox is selected, data that is deleted on the consolidated database is deleted on the remote databases.

If you are using timestamp-based synchronization and this column is selected, the deletions on the consolidated database need to be recorded. There are two ways of doing this: using shadow tables (the default), or using logical deletes. Open the Download Deletes tab in the Details pane to view and modify the implementation.

If you are using snapshot downloads and this column is selected, all existing rows in the remote database are deleted before the downloaded rows are added.

This option cannot be selected if the download type is Custom. In that case, you must write your own download_delete_cursor script. You can do this on the Events tab in the Details pane.

Download Subset column    Your options in this column are:

Conflict Detection column    Your options in this column are:

See Detecting conflicts.

Conflict Resolution column    Your options in this column are:

See Resolving conflicts.