Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Distributed database transaction vs cross database transaction

What's the different between Distributed database transaction and cross database transaction in SQL Server.

I know that Distribute database transaction is a transaction between multiple database and can use by following query :

BEGIN DISTRIBUTED TRANSACTION
...
COMMIT TRANSACTION
like image 825
mehdi lotfi Avatar asked Jun 01 '14 04:06

mehdi lotfi


1 Answers

A Cross database transaction occurs between 2 or more databases on the same server. It does not require the involvement of a DTC (Distributed Transaction Coordinator)

A Distributed database transaction occurs between 2 or more databases hosted on multiple servers. DTC (Distributed Transaction Coordinator) services are required on each participating server.

like image 111
Mitch Wheat Avatar answered Oct 14 '22 13:10

Mitch Wheat