This is a discussion on Bi-directional Transaction Replication within the SQL Server forums, part of the Microsoft SQL Server category; --> Two Servers, 1st 2nd database a -------> after replication a' b' <------- after replication b on 1st server a ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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 |
| ||||
| 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 |