The Column Mappings tab shows the mapped columns.
You can mark a column mapping for deletion by selecting a row in the Column Mappings tab, right-clicking the column and choosing None for the mapping direction. The column mapping is deleted when you save the model.
The Column Mappings tab shows the following information for the selected table mapping:
Consolidated column name This is the column that you are synchronizing in the consolidated database.
Consolidated column number This column indicates the order in which columns are returned by a SELECT * FROM tablename statement.
Consolidated column data type The data type of the consolidated column.
Mapping direction The mapping direction of the column.
For a column-to-column mapping the direction is the same as for the table mapping. A column can have the same mapping as its table or not be synchronized. For example, if the table has a bi-directional table mapping, the table's columns can either be Bi-Directional or Not Synchronized.
If the column mapping direction is Not Synchronized, the column is part of the remote database schema. When the model is deployed, the column is created on the remote, but no information is synchronized to it.
If you don't want the column to be created on the remote, delete it from the model. You can not delete primary key columns. See Modifying how deletes are recorded.
Remote column name Show the remote column or upload value that the consolidated column is mapped to, or if it is not synchronized.
Columns in consolidated database tables can be mapped to upload values in the Column Mappings tab by clicking the ellipsis (three dots) button and selecting MobiLink User Name, Remote ID, or Custom, which allows you to enter a SQL expression that can include MobiLink named parameters. Upload values do not correspond to a column in the remote table, so they only apply to uploads to the consolidated database. If you map a consolidated primary key column to an upload value, you should also apply a corresponding subset to your downloads and download deletes to ensure uniqueness of primary keys on downloads.
If your remote database existed before you created your synchronization model, the information in this column represents a best guess that you should check.
Remote column number This column indicates the order in which columns are returned by a SELECT * FROM tablename statement.
Remote column data type The data type of the remote column.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|