--- title: "Table Replication Scenarios" slug: "table-replication-scenarios" updated: 2024-03-22T16:20:24Z published: 2024-03-22T16:20:24Z canonical: "skthelp.syniti.com/table-replication-scenarios" --- > ## Documentation Index > Fetch the complete documentation index at: https://skthelp.syniti.com/llms.txt > Use this file to discover all available pages before exploring further. # Table Replication Scenarios 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](/v1/docs/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](/v1/docs/creating-database-connections) and a [target database connection](/v1/docs/creating-database-connections). 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. | ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image(200).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A37%3A50Z&se=2026-11-17T20%3A37%3A50Z&sr=b&sp=r&sig=9Ze5%2FURAElZrg8sM%2FObIartTrr87KfiOFPsOyA%2BZuWM%3D) | | --- | | **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](/v1/docs/creating-database-connections) and one or more [target database connections](/v1/docs/creating-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** | | --- | --- | | ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image(201).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A37%3A50Z&se=2026-11-17T20%3A37%3A50Z&sr=b&sp=r&sig=5H4oGfzgwL3tmyO9JR%2BxW5Tv4rfK7oHSovfSkmLGUdU%3D) | ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image(202).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A37%3A50Z&se=2026-11-17T20%3A37%3A50Z&sr=b&sp=r&sig=uq1MeFt2V2NvlpnAdRZwrDsPvLdOu3v0UZMAiZDr%2F5c%3D) | | **Replications:** **SourceT1 - TargetT1 SourceT1 - TargetT2** | **Replications: SourceT1 - TargetT1 SourceT1 - TargetT2** | | **Source Connections** | **Target Connections** | **Source Connections** | **Target Connections** | | SourceDB1 | TargetDB1 | SourceDB1 | TargetDB1 TargetDb2 | ## 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](/v1/docs/creating-database-connections) and a [target database connection](/v1/docs/creating-database-connections). 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](/v1/docs/writing-scripts-in-syniti-replicate) for the [Refresh_onBeforeTruncate event](/v1/docs/replication-script-events#refreshonbeforetruncate). 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** | | --- | --- | | ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image(203).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A37%3A50Z&se=2026-11-17T20%3A37%3A50Z&sr=b&sp=r&sig=hrcTrUghvvKMU1bWour3xb583z7XybiD4k65nFjzMHw%3D) | ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image(204).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A37%3A50Z&se=2026-11-17T20%3A37%3A50Z&sr=b&sp=r&sig=1Sc2%2F3Wll3spqoUipTs14fzNnTuL9iWqTNadwA1ZjWs%3D) | | **Replications:** **SourceT1 - TargetT1 SourceT2 - TargetT1** | **Replications: SourceT1 - TargetT1 SourceT2 - TargetT1** | | **Source Connections** | **Target Connections** | **Source Connections** | **Target Connections** | | SourceDB1 | TargetDB1 | SourceDB1 SourceDb2 | 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](/v1/docs/table-replication-scenarios#many-to-one-table-replication) and [One to Many Tables Replication](/v1/docs/table-replication-scenarios#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** | | --- | --- | | ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image(205).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A37%3A50Z&se=2026-11-17T20%3A37%3A50Z&sr=b&sp=r&sig=5t1jRfunp7BkWIIYkeNY6VXw1abtRGb1aXImvPp7Sqg%3D) | ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image(206).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A37%3A50Z&se=2026-11-17T20%3A37%3A50Z&sr=b&sp=r&sig=5OlnVk9kuYNp5VW49LqhZAi2xE0CN7d0m0C7BBNFj98%3D) | | **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 TargetDB1 TargetDb2 TargetDb2 TargetDB3 | SourceDB1 SourceDb2 | TargetDB1 TargetDB1 TargetDb2 TargetDb2 TargetDB3 | | **Many-to-Many Same Source and Different Target Databases** | | --- | | ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image(207).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A37%3A50Z&se=2026-11-17T20%3A37%3A50Z&sr=b&sp=r&sig=KH1W0uTdMQG4xWMnJl6roElALih%2FYGoPj2lA8JP%2FrMM%3D) | | **Replications: SourceT1 - TargetT1 SourceT1 - TargetT2 SourceT2 - TargetT1 SourceT2 - TargetT2 SourceT2 - TargetT3** | | **Source Connections** | **Target Connections** | | SourceDB1 | TargetDB1 TargetDB1 TargetDb2 TargetDb2 TargetDB3 | **Related Topics** [Planning the Replication Process](/v1/docs/planning-the-replication-process) [Database Replication Scenarios](/v1/docs/database-replication-scenarios)