Editing a replication set

You can add or remove tables from an existing replication set and change the set name.

1. Use one of the following methods to begin:
   • From the Data Replication screen, locate the replication set in the table, click the far right of the row to open a menu, and click Edit.
   • From the monitoring screen for the replication set, click Edit replication set.
2. Add or remove tables from the set by using the object selection table. You can also choose whether to replicate all CREATE TABLE and DROP TABLE statements within a schema by using the Replicate create and drop tables toggle. After you make your choices, click Next.
   
   Notes:

   • When you remove a table, you are only changing the configuration that defines how data is replicated. The actual database table is not affected.
   • When you remove a table that you no longer plan to replicate, you should alter the table to remove the DATA CAPTURE CHANGES attribute on the source. You can use the following SQL statement:

     ALTER TABLE schema.table-name DATA CAPTURE NONE
     

3. On the Review Selections screen, you can also remove tables by clicking at the far right of each table's row. If you need to add tables at this point, click Previous and return to the Select Objects screen. When you are done click Next.
   
4. On the Finalize screen, check the Load all tables that were newly added to the replication set option if you want the replication programs to delete all data in the target tables and replace it with data from the source after you start replication.
   Notes:

   • Do not choose this option if you want to preserve the data in the newly added target tables, for example if you are using two-way replication for a primary and standby server in a failover/failback scenario.
   • Replication does not automatically start for tables that are added to an active replication set.
5. When ready, click Configure, and then click OK on the confirmation window.