How to add or remove tables in an active config. (4300080)

How to make changes to an active config.

The procedure for making changes to an active config is as follows:

1. Copy the active config:
sp_ctrl> copy config active_config_name to new_config_name

2. Edit the new config and make the required changes, e.g. delete a table, add a table, other replication changes required:

sp_ctrl> edit config new_config_name

Save and exit to save the changes to the new config file.

3. Verify the config file:

sp_ctrl> verify config new_config_name

4. Activate the config file:

sp_ctrl> activate config new_config_name

If new objects were added to the new config file, those objects will be locked and analyzed. Once the new config is successfully activated, the old config will be deactivated. If the new activation fails for some reason, the old activation is retained. The activity of the activation program will be registered in the event_log.

Latest versions of SharePlex allow "edit config" on an active config file but it is not recommended. Because if the current config file is modified and fails activation then replication will stop. By copying the active config file to a new config file and activating the new config file, the active config will remain active if the new config activation fails.