Dropping and recreating new target database tables includes:
Drop and recreate new target database tables if:
After dropping and recreating new target database tables you will be able to:
|
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.
Open the Open Systems Event Replicator CDD.
Go to the target table row, click Active, click Create, and click Build Targets.
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.