How Can I Remove Tables From a Channel with Activated Replication?

Question

How can I remove tables from a channel with activated replication?

Environment

HVR 6

Answer

To avoid errors and ensure we don't capture transactions for tables that are no longer in your channel, we recommend that you remove tables from your existing replication by doing the following:

1. Suspend your Capture job.

2. Wait until the Integrate jobs have finished integrating all the changes.

3. Go to the Channel Details page.

4. Click the tables link available in the Channel Summary pane to open the Tables page.

5. Select the checkbox next to each table you want to remove.

6. Click the Delete Tables button at the top right.

7. In the pop-up dialog, click OK.

8. Reactivate your channel to regenerate jobs and enroll files.

   i. Go back to the Channel Details page.

   ii. Click the Activate Replication button at the top right.

   iii. In the Activate Replication dialog, under Locations, ensure the applicable source location is selected.

   iv. Under Replication Components, ensure the options Jobs, Table Enrollment, and Replace All Old Enrollment are selected.

   v. Click Activate Replication.

9. Drop the unwanted tables from your target database.