ryanjadams I am in the planning stage of upgrading a large collection of .NET 6 services to AKS Linux cluster. Many of them do distributed transactions among a handful of SQL Server dbs which will remain on-prem for now. Once the services are deployed in AKS, can I rely on the remote MSDTCs (on-prem) for these transactions assuming that I have the necessary firewall exceptions? If not, is there another way to get this scenario to work without extensive code changes?
At a later stage of the migration, when we do move the SQL Servers into Azure, are there any advantages to running them on Windows, Linux, or Azure SQL Database with regard to MSDTC? This is a legacy app where modest growth (< 20%/yr) seems to be the trend so far, but it supports extremely mission critical functionality. Any guidance would be greatly appreciated.