Shalom ,Hi ,Salam ,
DTC AND MTS WHAT AND FOR WHAT
Toda ,Thanks, Shukran
Efrat
Printable View
Shalom ,Hi ,Salam ,
DTC AND MTS WHAT AND FOR WHAT
Toda ,Thanks, Shukran
Efrat
Shalom!
The DTC coordinates transactions between database servers
Example
You have ORDERS in a MS SQL server
You have INVENTORY in an ORACLE server
You need to place an order and decrease inventory levels, but this has to be done across databases, and the data integrity must be maintained
The DTC will coordinate with the transaction managers of the SQL and Oracle databases to ensure that BOTH transactions succeeded (add order, decrease inventory). If the transaction fails for some reason on either database, the DTC will instruct BOTH databases to roll back their transactions.
This is how data integrity is maintained between databases in the MS world...
HTH
Tom
Hi Tom
Thanks Thanks Thanks ..
Great Answer ..
You are the Best Thanks for yours time .
Now i know .
Again Thanks .