As many organizations have Bentley Raceway & Cable Management users working at remote locations and need to manage the requirement for users to connect from/to any location. perform different tasks(insert, update, delete), and the database should be kept synchronized across multiple sites.Below are the terms used in this article:Publisher: It is the source database, which contains data to replicate.Subscriber: This is the destination database, there may be ma y subscribes for single publisher.Distributor: It is used to distribute the transactions to the subscriber database.Pre-requisites: In order to configure Peer-To-Peer publication, you need to have SQL Server 2012 developer edition or higher.
Microsoft Distributed Transaction Coordinator (MS DTC)
The following steps must be done at both the Master server and Remote server.
Microsoft Distributed Transaction coordinator Firewall Settings:
SQL Server Peer-To-Peer Replication:Configuring Distribution on Master Server
Configuring distribution on Remote Server:
You need to follow the same process as we did for the Master server. From the Connect to Server dialog: Server name – Select the serverLogin – Use an account with SYSADMIN privileges.Click Connect.
Please follow the steps given in Configuring Distribution on Master Server.
Configure the Publication on Master Server:
Configure Peer-To-Peer Topology:
Configure Publication Properties for both Servers: