How to use two databases at a time and update simultaneously in two different locations

Question

How to use two databases at a time? They are placed at different networks. Is it possible in .net?

are you planning to update them within a single transaction? — govi, Feb 22 '12 at 11:11
S @govi how to acheive this.they are at different locations[networks]. — Sravanti, Feb 22 '12 at 11:51
hmm.. i havent tried these, but there is http://stackoverflow.com/questions/1063502/how-to-implement-transaction-over-multiple-databases and the whole bunch of links in there. Are they helpful? — govi, Feb 22 '12 at 12:49

score 1 · Answer 1 · answered Feb 22 '12 at 12:58

If you want a Transaction that spans multiple databases you can use a TransactionScope.

using (TransactionScope t = new TransactionScope())
{
    // Execute code
    t.Commit();
}

The Transaction will be promoted to a distributed transaction when necessary. You need to make sure that the Distributed Transaction Coordinator is installed and then everything will work without further configuration.

score 1 · Answer 2 · answered Mar 02 '12 at 11:33

1

Use DataMirroring concept in Sqlserver.

answered Mar 02 '12 at 11:33

Sravanti

1,409
4
22
45

How to use two databases at a time and update simultaneously in two different locations

2 Answers2