Deleting Column Mappings from a New Target Table

Deleting new column mappings includes:

  • Opening a CONNX Data Dictionary (CDD)

  • Deleting a row from the column map grid

 

Delete a new column mappings if:

  • You wish to remove source data from the current column mapping

 

After you delete a new column mappings you will be able to:

  • Create the target table

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

 

A target table is considered to be "new" if it does not exist on the target database and it has not been created or deployed.

 

Note:  Deleting a column map does not change the structure of the Source table or an existing Target table.  The Add Row, Delete Row, Row Up and Row Down buttons are only available when mapping to a new target table.  If you are mapping to an existing target table and wish to change the structure of that table, you will need to press the "Drop Target Table" button (available when mapping to an existing table).  This will drop the target table and allow you to re-create it with the new structure.  Warning: Only do this if you intend to physically drop and re-create the target table.  All data in the existing table will be lost.

 

  1. Open the InstantdbSync Replication Administrator.

  1. Select a replication and click Map Columns. The Map Columns window appears.

map_columns_main_screen.bmp

 

  1. To delete a column from the Target Table:

  1. Select the row that represents the column on the target to be deleted.

map_columns_add_row_and_row_up.bmp

    1. Click Delete Row. The following message appears:

delete_row_message.bmp

    1. Click Yes. The row is deleted.

map_columns_delete_row.bmp

 

Note: You can not use the column mapper to delete a column from the Source Table.

  1. Click Done. The InstantdbSync main window reappears.