0

I have two nodes and one database. I want to transfer data between them. DML operations on server node-1 should transfer to node-2 and DML operations on node-2 should transfer to node-1 as well.

Is this possible and what is the best (most fast, safe, and stable) way?

Improve this question
0

1 Answer 1

Reset to default
2

Distributing reads is easy; distributing writes is not. In SQL Server, most availability technologies require a specific node or database to be the "master" where all writes go. Some possible options:

What is "best"? That's not really the kind of question we can answer here unless you get much, much more specific about what you mean by "best."

Improve this answer
3
  • It means fast, safe and stable. Thank you for answer. I'm gonna try these.
    – Yunus UYANIK
    Commented Jul 22, 2019 at 14:49
  • 1
    But again, sometimes you have to pick one or two of those things as the most important thing, and trade off the other(s). And you don't mention complexity or cost, which are surely also decision factors, as is the likelihood of things to go wrong (replication is high on this IMHO) and future support.
    – Aaron Bertrand
    Commented Jul 22, 2019 at 14:52
  • 2
    You're right but I was hoping that someone with experience could tell me about it. Although, these info enough for me, thank you. I can try these on my test server and I can research.
    – Yunus UYANIK
    Commented Jul 22, 2019 at 15:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.