Microsoft® SQL Server 2008 R2 Unleashed

Distributed Transactions

With SQL Server distributed transactions, it is now possible to manipulate data from several different data sources in a single transaction. Distributed transactions are supported if the OLE DB provider has built in the XA transactional functionality. For example, suppose two banks decide to merge. The first bank (let’s call it OraBank) stores all checking and savings accounts in an Oracle database. The second bank (let’s call it SqlBank) stores all checking and savings accounts in a SQL Server 2008 database. A customer has a checking account with OraBank and a savings account with SqlBank. What would happen if the customer wanted to transfer $100 from the checking account to the savings account? You can handle this ...