分布式数据库事务与跨数据库事务 [英] Distributed database transaction vs cross database transaction

问题描述

SQL Server中的分布式数据库事务和跨数据库事务之间有什么区别.

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

我知道Distribute数据库事务是多个数据库之间的事务，可以通过以下查询使用:

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

BEGIN DISTRIBUTED TRANSACTION
...
COMMIT TRANSACTION

推荐答案

跨数据库事务发生在 相同 服务器上的2个或更多数据库之间.不需要DTC(分布式事务处理协调员)的参与

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)

分布式数据库事务在多个服务器上托管的两个或多个数据库之间发生.每个参与服务器上都需要DTC(分布式事务处理协调器)服务.

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.

这篇关于分布式数据库事务与跨数据库事务的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！