Home / server / Questions / 274532
In Process
Gabriel Guimarães
Asked: 2011-05-28 06:07:42 +0800 CST

SQL 2008 R2 Bi directional replication

  • 772

I'm looking for the right replication for my case:

I can't use P2P replication because one of my SQL's is Standard. I have 2 SQL 2008 R2 and want to create a bi-directional replication.

What are my options?

Is a "always on" Merge replication functional?

sql-server sql-server-2008-r2 transactional-replication

1 Answers

  1. I would say to look into SQL server transactional replication with immediately updating subscribers.

    • 1