How to make multiple replication in one server to another

Question

BeUnique 2,332

I'm planning to do replicate data from one server to another.

I have done one part of the replication, but, when i am trying for second replication i'm struggling to do this. below is my requirement.

I have 3 SQL server and i want to transfer data from one server to another using replication.

For example,

Below is the three servers.

Server-1, Server-2 and Server-3

**First,**Already i have a replication from Server-2 to Server-3 with different database and same table structure. - Already done this

Server-2 DB Name : Prod_A (Table name : material (mat_id,mat_name,mat_date)

Server-3 DB Name : Prod_B (Table name : material (mat_id,mat_name,mat_date)

Second, i want to make one more replication from Server-1 to Server-2 to with same database with same table structure

Server-1 DB Name : Prod_A (Table name : material (mat_id,mat_name,mat_date)

Server-2 DB Name : Prod_A (Table name : material (mat_id,mat_name,mat_date)

What is the best way to do multiple replication in the above requirement..?

This is very urgent and i'm struggling to do in next step..

pls. help us to resolve this..?

Erland Sommarskog 128.7K Reputation points MVP Volunteer Moderator

2023-11-30T22:25:40.3533333+00:00

Why do you want to do it this way? Why not replicate from Server-1 to both the other servers?
BeUnique 2,332 Reputation points

2023-12-01T04:58:48.5733333+00:00

Hi @Erland Sommarskog ,

Thanks for your reply.

Server-2 and Server-3 is different database, but same table structure.

Do we need to create 2 replication from server-1..?

pls. guide and provide if we have any reference link..
Erland Sommarskog 128.7K Reputation points MVP Volunteer Moderator

2023-12-01T21:55:42.3+00:00

I know too little about your situation to say exactly, but to me it sounds like one publisher and two subscribers.

But I should add that I don't work a whole lot with replication, so maybe I am missing something.
BeUnique 2,332 Reputation points

2024-03-12T10:24:28.84+00:00

Thanks. It's working..

Your answer

Erland Sommarskog 128.7K Reputation points MVP Volunteer Moderator

2023-11-30T22:25:40.3533333+00:00

Why do you want to do it this way? Why not replicate from Server-1 to both the other servers?
BeUnique 2,332 Reputation points

2023-12-01T04:58:48.5733333+00:00

Hi @Erland Sommarskog ,

Thanks for your reply.

Server-2 and Server-3 is different database, but same table structure.

Do we need to create 2 replication from server-1..?

pls. guide and provide if we have any reference link..
Erland Sommarskog 128.7K Reputation points MVP Volunteer Moderator

2023-12-01T21:55:42.3+00:00

I know too little about your situation to say exactly, but to me it sounds like one publisher and two subscribers.

But I should add that I don't work a whole lot with replication, so maybe I am missing something.
BeUnique 2,332 Reputation points

2024-03-12T10:24:28.84+00:00

Thanks. It's working..