Biztalk in alwayson SQL 2019 Good morning all
I am working on a Biztalk migration project On an alwayson SQL environment
Who has an idea if BIztalk is compatible with ALWAYSON if YES it is from Which version?
another question for the activation of the MSDTSC function should you activate this option in Always on
thank you for your help
Biztalk is compatible with ALWAYS ON from SQL Sever 2016: https://docs.microsoft.com/en-us/biztalk/core/high-availability-using-sql-server-always-on-availability-groups
You have here a brief introduction and a setup of Microsoft Distributed Transaction (MS DTS). Microsoft says that is available starting from SQL Server 2016 Service Pack 2.
I found a link that is talking about best practice and is mentioning Biztalk which is exaclty your scenario but.... it doesn't give any example about how to setup MS DTS with Bitztalk.