Perform transaction on 2 databases on 2 different servers.

[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.

 

[Robin Tucker]

Hi Hetal,

What you are describing is called a Distributed Transaction. If you google
for that you will come up with lots of links and resources. Of course it
all depends on your specific configuration/setup. I found this article
quite quickly though.

http://www.c-sharpcorner.com/Upload...onScope04142006103850AM/TransactionScope.aspx


Robin

 

[Hetal]

Hi Robin,

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

 

[Hetal]

Thanks Robin.