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!
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.0Jose_Manuel_Jurado
Microsoft
Joined November 29, 2018
Azure Database Support Blog
Follow this blog board to get notified when there's new activity