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.
Disable the Replication
In the Management Center:
-
Display the Replication Browser tab.
-
Select the replication you want to modify.
-
On the right mouse button menu, uncheck the Enable Replication option.
Open the Replication Properties Dialog
In the Management Center Metadata Explorer:
-
Expand the Replications folder.
-
Select the replication you want to modify.
-
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:
-
Display the Replication Browser tab.
-
Select the replication you have modified.
-
On the right mouse button menu, check the Enable Replication option.
Related Topics
Using the Management Center while Replications are Running