Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

SQL SERVER 2008 Peer to Peer Replication

Avatar of isaackhazi
isaackhazi asked on
Microsoft SQL ServerMicrosoft SQL Server 2005Microsoft SQL Server 2008
4 Comments1 Solution575 ViewsLast Modified:
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 :

http://www.databasejournal.com/features/mssql/article.php/3814591/Peer-to-Peer-Replication-in-SQL-Server-2008--Configure-a-two-node-topology.htm

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?
 
ASKER CERTIFIED SOLUTION
Avatar of monicai
monicaiFlag of Singapore image

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 4 Comments.
See Answers