Explore Courses Blog Tutorials Interview Questions
0 votes
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!!

Welcome to Intellipaat Community. Get your technical queries answered by top developers!

30.5k questions

32.5k answers


108k users

Browse Categories