question

PimBelien avatar image
0 Votes"
PimBelien asked navid-0630 published

Azure SQL Managed Instance XA Transactions

Hi All,

Are XA transactions (so not MSDTC) on Managed Instance fully supported now? Or is it advised to use MS SQL Server on VM.
If it is, do I enable it the same way as I do on SQL Server?

azure-sql-database
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@PimBelien We are checking this with our Product team.

Regards
Navtej S

0 Votes 0 ·
NavtejSaini-MSFT avatar image
0 Votes"
NavtejSaini-MSFT answered

@PimBelien -

Managed Instance does not support XA transactions. On Azure SQL VMs one can use XA the same way as on SQL Server on-prem. Please visit the Azure Feedback page here to provide feedback and upvote the feedback here (1, 2)

Please get back to us for more information.

Regards
Navtej S


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thnx very much for the info! Too bad it is not supported, ill have to stick to my Azure VMs then.

0 Votes 0 ·
navid-0630 avatar image
0 Votes"
navid-0630 answered navid-0630 published

Interested in this feature as well, any roadmap updates as of today?

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.