Software

Ask something
Discussion Locked

Sql 2000

0 helpful
2 replies

by ajayn

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Pls. let me know whether I can synchronize online sql db placed in 2 different geographical locations. I mean If I insert or update etc data at one location, it should also update the db in other location at the same time and vice versa.

2 replies

by mike.bullock

If you are talking about both servers being read/write then no, I don't believe this is possible to do. Otherwise, look into "log shipping" to keep a backup server ready for failover purposes.

by tony hopkinson

It would be hideously complicated in any but the most trivial schema though.
When you add in fault tolerance, one db off line and catch up when it comes back etc.

There's no off the shelf solution as far as I'm aware, and if there was it would n't work.

Just as a for instance you can't use Identity columns as unique IDs.

Personally I'd look at posting changes to a common service that then updated the distributed databases in a transaction. ie it's the only mechanism that writes to the DBs.

This discussion is closed to new replies.