Replication Problem

Hi

I have two location and 1 centralised server.
while doing transactional replication first the data from the 1st server got replicated in the central server , while doing with the second location , the data in the central server got overwrited and now the replication from the first location is not happening.Only the replication from the second location is happening.

Please tell me how to do the replication with two location and a centralised server.

Regards
Aneesh

If you want central server always download changes to two clients, you can just set transactional replication on central server and choose two clients as subscribers. But if you have changes on client server, which you want to upload onto central servers as well, you can set merge replication on central server and two clients as subscribers. As for merge replication, if there are conflicts from central server and clients, you need to set conflicts resolver to make sure the data won as what you expected.

Hope it will help.

Thanks

Yunjing

|||

Hi Yunjing,

thanks for your reply.

I dont want central server always download changes to two clients, instead i have to upload the date from the location1 and location2 to the central server. I mean publishers in location1 and location2 and i have a subsciber in central server.

I want to replicate the data from the location1 and location2 servers to the central server.