I am trying to achieve a Peer-to-Peer Replication in SQL Server 2008 – Configure a two-node topology
We have a head office and a branch office. Currently applications installed in the branch office connect to the SQl server via a VPN. This solution is really slow and causes the applications to stall all the time.
Thus we decided to do a peer to peer replication in SQl server 2008 :
I followed the steps listed in this article :
My Questions :
1. Do we need SQl server 2008 EE on both ends to make this topology work?(There is a comment posted after the article which claims that you need SQL Server EE on both ends.)
2. When Setting up a publication do I need to include SPs, Views, functions as well in published articles or just including the tables are enough?