GA of DTC for Azure SQL Managed Instance

sasapopo

Microsoft

Nov 15, 2023

I’m happy to announce General Availability of DTC for Azure SQL Managed Instance.

This functionality is part of the Azure SQL Managed Instance November 2022 feature wave, that is now also GA!

With DTC for SQL MI (also known as MS DTC or Distributed Transaction Coordinator) you can run distributed transactions in mixed environments, between multiple Azure SQL Managed Instances, multiple SQL Servers, other RDBMSs and custom applications, hosted anywhere. Whether you’re using ODBC or JDBC driver, XA transactions, or T-SQL or .NET based distributed transactions, it’s all supported with Azure SQL Managed Instance.

Great news! You won’t have to worry about DTC log file management, as we’ve made it out-of-the-box both managed and highly available, same as Azure SQL Managed Instance.

Support for DTC and distributed transaction scenarios enables you to migrate your databases from on-prem and IaaS environments and modernize them. You can also develop new, modern, mission critical apps that require transactional consistency across complex architectures.

To run distributed transactions with SQL MI in mixed environment, you will need to configure few DTC settings, network connectivity between environments and DNS settings. You can read all about the DTC configuration here.