Hi,
Is there a way to make a bi-directionnal Replication with SQL Server ?
(BDD 1) Table 1 <=> (BDD 2) Table 1
Thanks.
+1
A:
There are a few solutions that might suit your need.
Each of them has its own advantages and disadvantages. Choosing one depends on the nature of your scenario.
Mehrdad Afshari
2009-01-11 13:12:19
Does Merge Replication is an Instant Replication ? or it's differed ?
Yoann. B
2009-01-11 13:12:51
It's usually used for deferred situations. If DB servers are always available, you could use database mirroring instead.
Mehrdad Afshari
2009-01-11 13:15:34
my problem is to prevent from one of the db servers get down. So i needed a 2 way instant replication between the 2 servers whenever they are onlines. And if one of the server is down, update the database when goes up.
Yoann. B
2009-01-11 13:18:23
Yaonn. B: I think database mirroring is specifically designed for such a situation.
Mehrdad Afshari
2009-01-11 13:20:34
Ok thanks, I'll take a look at these solutions.
Yoann. B
2009-01-11 13:21:45