Reset a Database Target
To drop all of the target tables in the task, reset a relational target table in a Data Replication task.
You might want to drop a target table when you want to re-create it based on the latest source object definition. When you reset target tables for a Data Replication task, the task performs the following actions:
- 1. Drops all of the target tables included in the Data Replication task from the database.
- 2. Sets the load type for the Data Replication task to full load.
After you run the Data Replication task to reset the target, you must run the Data Replication task again to reload the data from all source objects included in the task. When you run the Data Replication task after you reset the target, the Data Replication task recreates each target table. The Data Replication task then loads all of the data into the new table.
If the target table is damaged, the Data Replication task might consistently fail to write to the target table. You might need to reset the relational target.
Resetting a Target
You can reset the relational target tables included in a Data Replication task.
1. Click Task Wizards > Data Replication.
2. Click Reset Target next to the applicable Data Replication task.
Rules and Guidelines for Resetting a Target Table
Use the following rules and guidelines when you reset a target table:
- •If you previously created indexes on a target table and reset the target table, the Data Replication task drops the indexes and the target table. You must create the indexes again.
- •If you try to reset a target table that does not exist in the target database, an error appears.
- •The Data Replication task drops the target table that was updated the last time the task ran. For example, if you change the prefix of the target table and do not run the Data Replication task, the Data Replication task resets the old target table.