Modifying/Adding Replication Settings

After creating a replication using the Replication wizard or Multiple Replications wizard, you can modify some replication properties as follows. Note that if you have created a replication as part of a group, you cannot modify the replication properties without first removing the replication from the group.

  1. Disable the replication.

  2. Open the Replication Properties dialog.

  3. Modify any of the editable replication properties.

  4. Enable the replication.

Disable the Replication

In the Management Center:

  1. Display the Replication Browser tab.

  2. Select the replication you want to modify.

  3. On the right mouse button menu, uncheck the Enable Replication option.

Open the Replication Properties Dialog

In the Management Center Metadata Explorer:

  1. Expand the Replications folder.

  2. Select the replication you want to modify.

  3. From the right mouse button menu, choose Replication Properties.

Modify/Add Property Values

Edit properties as needed:

  • General tab/Use script: Add scripts

  • General tab/Mapping: Change mappings

  • General tab/Replication Mode: Change the replication mode. Note that if you change the replication mode from a transactional replication to a refresh replication involving Oracle, Db2 or SQL Server, you will be asked if you want to remove objects/components that were created on the database server to support your transactional replication. For example, if using SQL Server, a distributor is created for you.

  • Scheduler tab: Change the replication schedule

  • Preferences tab: Modify thread settings and command/record pool sizes for performance

  • Preferences tab: For synchronization replications, set a conflict resolution approach

  • Preferences tab: Change the isolation level for transactional replications

  • Preferences tab: Set a SQL WHERE condition for refresh replications to filter the records replicated.

Enable the Replication

In the Management Center:

  1. Display the Replication Browser tab.

  2. Select the replication you have modified.

  3. On the right mouse button menu, check the Enable Replication option.

Related Topics
Using the Management Center while Replications are Running