Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
in Azure by (13.1k points)
Can anyone help me is it possible to have a transaction from on premises SQL Server to Azure SQL database?

1 Answer

0 votes
by (26.7k points)

No, you cannot able to have a transaction from on premises to Azure SQL database as because Azure SQL database supports elastic transactions whereas on premises servers supports Microsoft Distributed Transaction Coordinator(MSDTC). Also, you can try migrate your database either to Azure SQL or on premises.

I hope this will help.

Want to become an Azure expert? join azure developer training now!!

Browse Categories