- 22 Mar 2024
- 1 Minute to read
- Contributors
- Print
- DarkLight
Modifying/Adding Replication Settings
- Updated on 22 Mar 2024
- 1 Minute to read
- Contributors
- Print
- DarkLight
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