Microsoft SQL Server forum - Bi-directional Transaction Replication

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Bi-directional Transaction Replication

senthilprabu

2005-08-25, 7:23 am

Two Servers,

1st 2nd
database a -------> after replication a'
b' <------- after replication b

on 1st server a is replicated to 2nd
on 2nd server b is replicated to 1st

I tried with merge replication it is working fine.But if i tried to use
transactional replication it give some error like "access
violation".Using tansactional replication is it possible.plz help me to
slove this problem.

Regards,
Senthil prabu R

Simon Hayes

2005-08-25, 7:23 am

I have no idea myself, but under "Nonpartitioned, Bidirectional,
Transactional Replication", Books Online says that to implement
bidirectional transactional replication "substantial customization and
programming is usually required."

So you might get a better response in
microsoft.public.sqlserver.replication, as it seems to be something
quite specialized.

Simon

Sponsored Links