Replication in Syniti Replicateis defined at the table level, so there is a replication definition for each source-target table pair. To replicate an entire database, see Database Replication Scenarios.
One to One Table Replication
This is the simplest case where a source table is replicated to a target table that may be on the same or a different database server. For this type of replication, you need to define a source database connection and a target database connection. Then you need to specify replication details that include the type of replication, the scheduling and the mapping between source and target fields in the table. You can also write a script to transform values in the source table for the target table.
.png?sv=2022-11-02&spr=https&st=2026-02-13T07%3A55%3A12Z&se=2026-02-13T08%3A08%3A12Z&sr=c&sp=r&sig=ywmSodw0TXt7aiJIsdRZb9X%2FxDp%2BUdmSE6fYBKV8Rao%3D "image(200).png") | |
Source Connections | Target Connections |
SourceDB1 | TargetDB1 |
One to Many Tables Replication
In this scenario, a source table is replicated to more than one target table where the target tables may be on the same or a different database server. For this type of replication, you need to define a source database connection and one or more target database connections. You will need a connection for each database server. Then you need to specify replication details for each source-target pair that include the type of replication, the scheduling and the mapping between source and target fields in the table. You can also write a script to transform values in the source table for the target table. For example, in the Customers source table, you might replicate all the customer data to target table A, but just the customer ID and the fields containing financial information to target B. In this example, you would need the following source and target connections:
One-to-Many Same Target Database | One-to-Many Different Target Database | ||
|---|---|---|---|
.png?sv=2022-11-02&spr=https&st=2026-02-13T07%3A55%3A12Z&se=2026-02-13T08%3A08%3A12Z&sr=c&sp=r&sig=ywmSodw0TXt7aiJIsdRZb9X%2FxDp%2BUdmSE6fYBKV8Rao%3D "image(201).png") | .png?sv=2022-11-02&spr=https&st=2026-02-13T07%3A55%3A12Z&se=2026-02-13T08%3A08%3A12Z&sr=c&sp=r&sig=ywmSodw0TXt7aiJIsdRZb9X%2FxDp%2BUdmSE6fYBKV8Rao%3D "image(202).png") | ||
Replications: SourceT1 - TargetT1 SourceT1 - TargetT2 | Replications: SourceT1 - TargetT1 SourceT1 - TargetT2 | ||
Source Connections | Target Connections | Source Connections | Target Connections |
SourceDB1 | TargetDB1 | SourceDB1 | TargetDB1 |
Many to One Table Replication
In this scenario, multiple source tables are replicated to a single target table. For this type of replication, you need to define source database connections and a target database connection. You need to specify replication details for each source-target pair that include the type of replication, the scheduling and the mapping between source and target fields in the table. You can also write a script to transform values in the source table for the target table. Syniti Replicate does not provide tools to manage possible conflicts when replicating to a table from different sources. When planning the replications, you need to avoid possible conflicts. For example, if performing a Refresh, you may want to skip the truncation step by writing a script for the Refresh_onBeforeTruncate event.
In replicating two different source tables to a single target table, you would need the following source and target connections:
Many-to-One Same Source Database | Many-to-One Different Source Database | ||
.png?sv=2022-11-02&spr=https&st=2026-02-13T07%3A55%3A12Z&se=2026-02-13T08%3A08%3A12Z&sr=c&sp=r&sig=ywmSodw0TXt7aiJIsdRZb9X%2FxDp%2BUdmSE6fYBKV8Rao%3D "image(203).png") | .png?sv=2022-11-02&spr=https&st=2026-02-13T07%3A55%3A12Z&se=2026-02-13T08%3A08%3A12Z&sr=c&sp=r&sig=ywmSodw0TXt7aiJIsdRZb9X%2FxDp%2BUdmSE6fYBKV8Rao%3D "image(204).png") | ||
Replications: SourceT1 - TargetT1 SourceT2 - TargetT1 | Replications: SourceT1 - TargetT1 SourceT2 - TargetT1 | ||
Source Connections | Target Connections | Source Connections | Target Connections |
SourceDB1 | TargetDB1 | SourceDB1 | TargetDB1 |
Many to Many Tables Replications
In this scenario, multiple source tables are each replicated to one or more target tables. Carefully analyze the relationships for each source-target pair and create source and target connections based on the descriptions above in Many to One Table Replication and One to Many Tables Replication. Syniti Replicate does not provide any specific features for handling this type of scenario. In this example, you would need the following source and target connections:
Many-to-Many Same Source and Same Target Databases | Many-to-Many Different Source and Same Target Database | ||
.png?sv=2022-11-02&spr=https&st=2026-02-13T07%3A55%3A12Z&se=2026-02-13T08%3A08%3A12Z&sr=c&sp=r&sig=ywmSodw0TXt7aiJIsdRZb9X%2FxDp%2BUdmSE6fYBKV8Rao%3D "image(205).png") | .png?sv=2022-11-02&spr=https&st=2026-02-13T07%3A55%3A12Z&se=2026-02-13T08%3A08%3A12Z&sr=c&sp=r&sig=ywmSodw0TXt7aiJIsdRZb9X%2FxDp%2BUdmSE6fYBKV8Rao%3D "image(206).png") | ||
Replications: SourceT1 - TargetT1 SourceT1 - TargetT2 SourceT2 - TargetT1 SourceT2 - TargetT2 SourceT2 - TargetT3 | Replications: SourceT1 - TargetT1 SourceT1 - TargetT2 SourceT2 - TargetT1 SourceT2 - TargetT2 SourceT2 - TargetT3 | ||
Source Connections | Target Connections | Source Connections | Target Connections |
SourceDB1 | TargetDB1 | SourceDB1 | TargetDB1 |
Many-to-Many Same Source and Different Target Databases | |
.png?sv=2022-11-02&spr=https&st=2026-02-13T07%3A55%3A12Z&se=2026-02-13T08%3A08%3A12Z&sr=c&sp=r&sig=ywmSodw0TXt7aiJIsdRZb9X%2FxDp%2BUdmSE6fYBKV8Rao%3D "image(207).png") | |
Replications: SourceT1 - TargetT1 SourceT1 - TargetT2 SourceT2 - TargetT1 SourceT2 - TargetT2 SourceT2 - TargetT3 | |
Source Connections | Target Connections |
SourceDB1 | TargetDB1 |
Related Topics
Planning the Replication Process