DTC & MTS

[efrat]

Shalom ,Hi ,Salam ,

DTC AND MTS WHAT AND FOR WHAT

Toda ,Thanks, Shukran

Efrat

[Clunietp]

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

[efrat]

Hi Tom
Thanks Thanks Thanks ..
Great Answer ..
You are the Best Thanks for yours time .

Now i know .

Again Thanks .