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 rather 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).
1. Open the InstantdbSync CDD.
2. Go to the target table row, click Active, click Create, and click Build Targets.
If a target table exists on the target database, there is no check in the Create Table column.
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:
Droping and recreating a table will delete all data in the target table.