Dropping and Recreating Target Database Tables

Dropping and recreating new target database tables includes:

  • Opening a CONNX Data Dictionary (CDD)

  • Dropping selected target tables

  • Recreating selected target tables

 

Drop and recreate new target database tables if:

  • The target data is not valid

  • The target data is out-of-date

  • It's easier to re-create the target data than try to fix it before deployment

 

After dropping and recreating new target database tables you will be able to:

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

 

There are two ways to drop and recreate tables on the target database without deploying the Event Replicator.  

 

If a target table exists on the target database, there is no check in the Create Table column.  

 

  1. Open the Open Systems Event Replicator CDD.

  2. Go to the target table row, click Active, click Create, and click Build Targets.

 

Drop_and_Recreate_Target_Table.bmp

 

This will drop and recreate the table on the target database without deploying the replication.

 

If the purpose of dropping the target table is to change the column mapping, the target table can also be dropped from within the Map Columns Dialog by pressing the Drop Target Table button.  (this button is only visible when mapping to an existing target table)  After dropping the table and re-mapping the columns, press the Done button to return to this screen.  The Create check box will be checked.  Press Build Targets to rebuild the target table.

 

Caution: Drop and recreate will delete all data in the target table.