Changing Source Column Mapping

Changing source column mappings includes:

  • Opening a CONNX Data Dictionary (CDD)

  • Changing which source column a target column is mapped to

 

Change the source column mappings if:

  • You wish to change which source column a target column is mapped to

 

After you change the source mappings you will be able to:

  • Deploy the replication (which will start replicating data from source database to target database)

 

Map Columns allow you to change which source column an existing target column is mapped to.

 

Note: The Source and Target columns must have compatible data type, length, precision and scale.

 

  1. Open the InstantdbSync Replication Administrator.

  1. Select a replication to modify. Click Map Columns. The Map Columns window for an existing target table appears.

map_columns_existing_source_columns.bmp

 

  1. Under Populate columns, click Source Column. Click the Source Column box for the replication you wish to change. A drop down arrow appears. Click on the arrow and a list of available source column names appears.

map_columns_existing_source_name_dropdown.bmp

 

  1. Select the source column name to map the corresponding target column to.

map_columns_existing_source_name_changed_dropdown.bmp

 

  1. The selected Source Column will map to the corresponding Target Column.

map_columns_existing_source_name_changed.bmp

 

  1. Click Done. The InstantdbSync main window reappears.