Database replications typically fall into one of the following categories.
One to One Database Replication
The easiest and most common scenario involves one source database and one target database, where Syniti Replicatereads data from the source database or log/journal, and writes to the target database. The replication may involve one table or several tables. If the replication involves more than one table, you can set up replications for each table quickly and efficiently using the Multiple Replications wizard. See also Table Replication Scenarios for additional scenarios.
.png?sv=2022-11-02&spr=https&st=2026-02-13T07%3A56%3A09Z&se=2026-02-13T08%3A08%3A09Z&sr=c&sp=r&sig=xg1%2Bs0564yWuHEnXPQUxLy3X6WL5jJjzQp3attgJi6k%3D "image(208).png")
For this type of replication, you will need to define one source connection and one target connection before defining replication details for each table involved in the replication. Replication details depend on whether you intend to perform a refresh replication, perform synchronization, or set up mirroring from the source to the target database.
One to Many Databases Replication
In this scenario, data from a single source database must be replicated to multiple target databases. The replication may involve one table or several tables on the source and target sides. See Table Replication Scenarios for more information.
.png?sv=2022-11-02&spr=https&st=2026-02-13T07%3A56%3A09Z&se=2026-02-13T08%3A08%3A09Z&sr=c&sp=r&sig=xg1%2Bs0564yWuHEnXPQUxLy3X6WL5jJjzQp3attgJi6k%3D "image(209).png")
For this type of replication, you will need to define one source connection and one target connection for each database to which you are replicating data. You will also need to define replication details for each table involved in the replication. For example, if you have two tables on the source database, one of which needs to be replicated to a SQL Server target database, and the other to an Oracle target database, you will need to set up two replications. Replication details depend on whether you intend to perform a refresh replication, perform synchronization, or set up mirroring from the source to the target database.
This approach could be useful in the following conditions:
Department databases are present
Security policies require several target databases
You need to reduce network traffic by replicating data only where necessary
Many to One Database Replication
.png?sv=2022-11-02&spr=https&st=2026-02-13T07%3A56%3A09Z&se=2026-02-13T08%3A08%3A09Z&sr=c&sp=r&sig=xg1%2Bs0564yWuHEnXPQUxLy3X6WL5jJjzQp3attgJi6k%3D "image(210).png")
This scenario often occurs when consolidating enterprise data. You will need to define one source connection for each database from which you are replicating. If you are replicating to different tables in the target database, you can set up a single target database connection and define the tables to replicate in the Replication wizard. If you are replicating from tables in multiple source databases to a single table in the target database, a restriction applies. Even though you are targeting a single database, connections to the same table cannot be shared so you will need to set up a target connection that matches each source connection using the same table. The replication requires a unique target connection. You will also need to define replication details for each table involved in the replication. For example, if you have two tables on two source databases that both need to be replicated to the target database, you will need to set up two replications. Replication details depend on whether you intend to perform a refresh replication, perform synchronization, or set up mirroring from the source to the target database.