Bi-directional Replication

• charles-work

  Grasshopper

  Points: 20

  More actions

  February 27, 2019 at 8:37 pm

  #381562

  Our company has been using Sybase for quite some and we are looking to switch to SQL Server.  i have been looking online for master master replication and it's been hard to  find any recent examples of this for SQL Server.   Is SQL server replication piece "easy" to set up? Is there another production that might better for Master-Master replication like MySQL?

• drew.allen

  SSC Guru

  Points: 76988

  More actions

  February 28, 2019 at 10:42 am

  #2023225

  The closest thing is Merge Replication.  I've never used it, so I can't tell you much more.

  Drew

  J. Drew Allen
  Business Intelligence Analyst
  Philadelphia, PA

• sgmunson

  SSC Guru

  Points: 110640

  More actions

  March 6, 2019 at 7:10 am

  #2023665

  Replication in SQL Server just doesn't provide that kind of functionality.   It's entirely a one-way operation.   However, have you looked into high availability features?

  Steve (aka sgmunson) 🙂 🙂 🙂
  Rent Servers for Income (picks and shovels strategy)

• e4d4

  SSCertifiable

  Points: 5777

  More actions

  March 6, 2019 at 8:35 am

  #2023674

  There is Peer-to-Peer replication
  https://docs.microsoft.com/en-us/sql/relational-databases/replication/transactional/peer-to-peer-transactional-replication?view=sql-server-2017

• sgmunson

  SSC Guru

  Points: 110640

  More actions

  March 6, 2019 at 9:38 am

  #2023688

  e4d4 - Wednesday, March 6, 2019 8:35 AM

  There is Peer-to-Peer replication
  https://docs.microsoft.com/en-us/sql/relational-databases/replication/transactional/peer-to-peer-transactional-replication?view=sql-server-2017

  Looks like I've learned something new today.   Thanks!

  Steve (aka sgmunson) 🙂 🙂 🙂
  Rent Servers for Income (picks and shovels strategy)