Distributed database transactions spanning multiple Azure SQL Managed Instances
Published date: 14 October, 2020
Now in preview, distributed database transactions spanning multiple Azure SQL Managed Instances have been added to enable frictionless migration of existing apps, as well as development of modern multi-tenant apps relying on vertically or horizontally partitioned database architecture.
By utilising distributed transactions, you will save time when migrating existing apps that require this capability as it eliminates the need to change app code and to perform extensive testing. If you develop new apps, you can benefit from partitioning data into multiple databases to overcome current sizing limitations of Azure SQL Managed Instance, while utilising distributed transactions to keep partitioned data in a consistent state.
During preview, two methods of running distributed transactions will be supported using BEGIN DISTRIBUTED TRANSACTION statement from Transact-SQL code and using TransactionScope class from .NET code.