Azure Daily 2022 by Gordon

MS DTC for Azure SQL Managed Instance - extending distributed transaction support (private preview) - Microsoft Tech Community

Today, Azure SQL Managed Instance supports cross-instance distributed transactions, meaning that you can run distributed transactions between multiple databases hosted on several managed instances.

The scope of this improvement can enable you to run distributed transactions between Azure SQL Managed Instance and other distributed transaction participants and that includes:

  • Azure SQL Managed Instance
  • SQL Server hosted anywhere
  • Relational Database Management Systems
  • Other software that can participate in distributed transactions, such as MSMQ.

MS DTC for Azure SQL Managed Instance - extending distributed transaction support (private preview)

Running distributed transactions in a heterogenous environment can enable you to perform transparent migration of your databases from SQL Server; to entirely or partially migrate or modernize your existing solutions; and develop new applications with complex transactional patterns on Azure SQL Managed Instance.

Source: MS DTC for Azure SQL Managed Instance - extending distributed transaction support (private preview) - Microsoft Tech Community

Comments