Overview
The Replication Dependencies feature allows you to define the dependent replications that must be run and completed before executing the selected replication. This feature is helpful when you want to replicate tables with constraints (for example, foreign key relationship) in the source database. Dependencies are honored only when the related replications are executed at the specific target, source, or group combinations.
Note
It is recommended to create a separate group for replications that are related to each other or fulfil dependency constraints.
You can define or modify the dependent replications only for the specific target and source datastore combinations. For example, you cannot select or define replications from the Target A - Source B combination as dependent replications for a particular replication in the Target A - Source A combination.
When you execute or schedule a replication job, Replicate Preview honors these replication dependencies and executes the dependent replications before running the selected replication job. The Replication Dependencies dialog box lists the available replications for the selected target and source datastores combination.
The Replication Dependencies dialog box displays the following columns in the grid:
Column Name | Description |
|---|---|
Table Name | The name of the replications available in the selected target and source datastores combination. |
Target Name | The Target Datastore associated with the replications. |
Source Name | The Source Datastore associated with the replications. |
Columns in grids throughout the Syniti Knowledge Platform (SKP) can be individually customized, sorted, and filtered. You can also search for names or values for in columns that have the Search feature enabled. The selected settings are remembered per user. Refer to SKP Grid Searching, Sorting, and Filtering for more information.
To configure replication dependencies:
In the Targets panel, select the required target datastore. Source datastores associated with this target datastore is displayed in the Sources panel.
In the Sources panel, select the required source datastore. Replications associated with the selected target and source datastore combination is displayed in the Replications panel.
In the Replications panel, select a replication and click the Replication Dependencies icon. The Replication Dependencies dialog box is displayed.
Select the checkboxes for the required replications to run it before executing the selected replication.
Click Save.
You have successfully defined dependent replications to be run before executing the selected replication.