Blog Post

Azure Database Support Blog
1 MIN READ

Lesson Learned #37: How to use distributed transactions in Azure SQL Database

Jose_Manuel_Jurado's avatar
Mar 14, 2019
First published on MSDN on Mar 30, 2018
Currently, there is not possible to update two tables of different databases using a single transaction in Azure SQL Database in the same way that we have in SQL Server

If you need to implement in your code a distributed transactions, your application will the coordinator of this distributed transaction using the transaction scope method using .NET.

In this YouTube channel you will find in Spanish and English how to implement in your application distributed transactions.

Enjoy!
Updated Mar 14, 2019
Version 2.0

1 Comment

  • daniel_abadias's avatar
    daniel_abadias
    Copper Contributor

    Gracias por la lección Jose_Manuel_Jurado. No es por hacer la pelota pero la coincidencia es que estaba preparándome una entrevista que me vas a hacer en un rato y he googleado "azure sql distributed transaction" y me ha salido este artículo en segundo puesto, escrito por ti.