I have a publication server aaa and subscriber server bbb and i am replication tables a1,a2,a3,a4,a5 from server aaa to bbb. I have the same tables a1,a2,a3,a4 on server ccc.Now i want to server cv as a publisher and server aa as subscriber.
So now the new scene is that
publication server suscriber server
ccc-------aaa
aaa-------bbb
So now can make server aaa as a subscriber to ccc(remember itz a publisher for bbb)
Thanks.can anyone help me in this issue...
Thanks.|||Are you trying to get Merge Replication (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/repltypes_6my6.asp), or just create true chaos ?
-PatP|||I am not planning for merge replication ?Is't a better one in this case?
Thanks.|||Yes. the replications should work in your described scenario.
Wednesday, March 7, 2012
replication
Labels:
aaa,
bbb,
database,
microsoft,
mysql,
oracle,
publication,
replication,
server,
sql,
subscriber,
tables
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment