%3CLINGO-SUB%20id%3D%22lingo-sub-369033%22%20slang%3D%22en-US%22%3ELesson%20Learned%20%2337%3A%20How%20to%20use%20distributed%20transactions%20in%20Azure%20SQL%20Database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-369033%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3EFirst%20published%20on%20MSDN%20on%20Mar%2030%2C%202018%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%20Currently%2C%20there%20is%20not%20possible%20to%20update%20two%20tables%20of%20different%20databases%20using%20a%20single%20transaction%20in%20Azure%20SQL%20Database%20in%20the%20same%20way%20that%20we%20have%20in%20SQL%20Server%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20If%20you%20need%20to%20implement%20in%20your%20code%20a%20distributed%20transactions%2C%20your%20application%20will%20the%20coordinator%20of%20this%20distributed%20transaction%20using%26nbsp%3Bthe%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fes-es%2Fdotnet%2Fapi%2Fsystem.transactions.transactionscope%3Fview%3Dnetframework-4.7.1%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%20transaction%20scope%20%3C%2FA%3E%20method%20using%20.NET.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20In%20this%20YouTube%20channel%20you%20will%20find%20in%20%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DtDKLgl0psys%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%20Spanish%20%3C%2FA%3E%20and%20%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D2K1xVNpvkIw%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%20English%20%3C%2FA%3E%20how%20to%20implement%20in%20your%20application%20distributed%20transactions.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Enjoy!%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-369033%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20MSDN%20on%20Mar%2030%2C%202018%20Currently%2C%20there%20is%20not%20possible%20to%20update%20two%20tables%20of%20different%20databases%20using%20a%20single%20transaction%20in%20Azure%20SQL%20Database%20in%20the%20same%20way%20that%20we%20have%20in%20SQL%20ServerIf%20you%20need%20to%20implement%20in%20your%20code%20a%20distributed%20transactions%2C%20your%20application%20will%20the%20coordinator%20of%20this%20distributed%20transaction%20using%26nbsp%3Bthe%26nbsp%3Btransaction%20scope%20method%20using%20.%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-369033%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20SQL%20Database%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Edistributed%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Etransaction%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1295060%22%20slang%3D%22en-US%22%3ERe%3A%20Lesson%20Learned%20%2337%3A%20How%20to%20use%20distributed%20transactions%20in%20Azure%20SQL%20Database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1295060%22%20slang%3D%22en-US%22%3E%3CP%3EGracias%20por%20la%20lecci%C3%B3n%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F247500%22%20target%3D%22_blank%22%3E%40Jose_Manuel_Jurado%3C%2FA%3E.%20No%20es%20por%20hacer%20la%20pelota%20pero%20la%20coincidencia%20es%20que%20estaba%20prepar%C3%A1ndome%20una%20entrevista%20que%20me%20vas%20a%20hacer%20en%20un%20rato%20y%20he%20googleado%20%22azure%20sql%20distributed%20transaction%22%20y%20me%20ha%20salido%20este%20art%C3%ADculo%20en%20segundo%20puesto%2C%20escrito%20por%20ti.%3C%2FP%3E%3C%2FLINGO-BODY%3E
First published on MSDN on Mar 30, 2018
Currently, there is not possible to update two tables of different databases using a single transaction in Azure SQL Database in the same way that we have in SQL Server

If you need to implement in your code a distributed transactions, your application will the coordinator of this distributed transaction using the transaction scope method using .NET.

In this YouTube channel you will find in Spanish and English how to implement in your application distributed transactions.

Enjoy!
1 Comment
Occasional Visitor

Gracias por la lección @Jose_Manuel_Jurado. No es por hacer la pelota pero la coincidencia es que estaba preparándome una entrevista que me vas a hacer en un rato y he googleado "azure sql distributed transaction" y me ha salido este artículo en segundo puesto, escrito por ti.