Can Transactional Replication be Bi-Directional ?

[JohnBates]

hi everyone,

I have 2 SQL servers - a primary and a second server which serves data to a web site.

Table1 resides on both servers. I need for any changes made to the table on either server to be replicated over to the other server.

I know Merge-replication can do this. But merge has its problems unless they improved some of the weaknesses in ver 2000.


So can Transactional replication be configured as 2-way ?

Thanks, John

 

[camy123]

merge i would say is your best option . It does work very well well in server 2000 ive had no problems with it or if u dont like that have a push from one server then a pull from the other server but that is very messy, i wuold go for that option.