Wednesday, March 7, 2012

replication

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.

No comments:

Post a Comment