One To Many SQL Replication

Question

Can i do a One to Many Replication. I have following Scenario:- Source & Target Servers in same location with Alias configured & working properly but now i want to replicate to another Target Server at different location over WAN. Is it possible with failover? Can i have the Same Alias name for LAN & WAN Replication? & if possible can i prioritize the Alias failover. LAN Failover should only occur & in case of complete site disaster WAN failover should happen.

yito1 · Answer

Hi,Alias can select only one target. Therefore, your scenario cannot be achieved.Yoshinobu

Natha1 · Answer

Then how can i achieve the above scenario.Is it possible to do one to many replication.

yito1 · Answer

Hi,Your scenario cannot be achieved with RepliStor.The precondition of Alias is one to one.If AutoStart is combined with RepliStor, your scenario will become possible.Yoshinobu

Replication Manager

Was this post helpful?