Perform transaction on 2 databases on 2 different servers.

  • Thread starter Thread starter Hetal
  • Start date Start date
H

Hetal

Hi..

I am working on VB.NET (windows forms) and i am using ADO.NET to deal
with databases. I have 2 databases say dbA (on Server1) and dbB (on
Server2). I am reading data from dbA and writing it on dbB. After i am
done writing, i delete information from dbA. Is there a way i can
perform this activity as a single transaction?

Any help on this one will be much appreciated. Thank you.

Hetal.
 
Hi Robin,

The keyword "Distributed Transaction" did the trick for me. I found a
bunch of helpful articles online. Thanks.
 
Back
Top