The Master configuration defines what data should be replicated to different Replicas.
A replication group is a group of receivers that share a configuration and thus receives exactly the same data.
Open the Replication folder.
On_New
and On_Modify
are properly checked.E.g. :new.<column_name> = value
. String values have to
be surrounded by single quotes.
Note 1! A Replica can be part of several replication groups and a Replication Object can be connected to several replication groups. Avoid configurations where a Replica is part of several replication groups where some replication objects is present in more then one group. This will not generate any errors but it will generate unnecessary Connectivity messages.
When the Replication configuration for all the replication groups are finished the configuration should be sent to all the Replicas. The configuration will be installed in the Replicas repository and used for configuration of receiving replicated objects.
Open the Replication folder.
Note!. When the network configuration is received at a participating site its repository will be updated.
Open the Connectivity folder.
When the Replication configuration for all the replication groups are finished all triggers and packages must be generated and installed on the Master. As soon as the triggers and packages are installed replication will start. If the background processes are not running replication data will be queued in the replication queue table. When the background processes are started data will be replicated to the participating sites.
Open the Replication folder.
Note! There may be errors when installing triggers due to references to view columns in the triggers. If this is the case go back to the Replication Object Definition and check the configuration. Any view columns that don’t have a corresponding table column with the same name must have a table column name entered in Table Key Name. Enter the table column name that corresponds the view column name or if there is no corresponding table column any valid table column name (a replicated column).