Create Synchronization Model Wizard: Table Synchronization Mapping page

This page allows you to specify the table mappings between the chosen consolidated and remote tables in the model. This page applies when the remote database schema in the synchronization model is based on an existing remote database.

This page shows the mappings between the consolidated tables and the available tables in the remote database. The Mapping Direction column shows whether the mapping should be Bi-directional, Download to remote only, or Upload to consolidated only.

The page has the following components:

  • Consolidated Table column   Shows the consolidated database tables that the wizard is trying to map to the tables in the Remote Table column.

    Note

    Default table mappings are made on a best effort basis. Mappings may not be found for all tables, and of the tables that are mapped, the mappings may not be what you intended, so you should verify all tables mappings before proceeding.

    You cannot proceed until all tables are mapped.

  • Mapping Direction column   Shows the direction of synchronization between the consolidated table and the chosen remote table. The direction can be Bi-Directional, Download to remote only, or Upload to consolidated only. The default is Bi-Directional. To change the direction, choose a new direction from the dropdown list.

  • Remote Table column   Lists the chosen remote database tables.