'MSDTC is not supported by AWS RDS SQL server
I have transaction scope in my code which move transaction to MSDTC. But when I run this code into AWS cloud where RDS is SQL server. It is not supporting MSDTC please how can I make this supportable or what will be alternative way for this. I need MSDTC in my code.
Solution 1:[1]
Well, there isn't much that you can do since AWS does not support it (https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_SQLServer.html).
Features Not Supported and Features with Limited Support The following Microsoft SQL Server features are not supported on Amazon RDS:
Stretch database Backing up to Microsoft Azure Blob Storage Buffer pool extension Data Quality Services Database Log Shipping Database Mail Distribution Transaction Coordinator (MSDTC) File tables FILESTREAM support Maintenance Plans Performance Data Collector ... ...
The alternative is to deploy/host/manage your own MSSQL server on AWS.
Solution 2:[2]
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.Options.MSDTC.html
Looks like this is now supported by AWS.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Vincent Le |
| Solution 2 | Henry Wycislo |