We currently use merge replication and have had numerous issues with it. Primarily that there is a single point of failure.
We are looking at moving to peer-2-peer transactional replication but we are currently running standard edition and have no plans/budget to upgrade.
Will peer-2-peer be available in standard edition in the near future?
View Complete Post