just to make sure I understood this right -
1) I cannot have a transaction spanning multiple transaction managers (in fact, make that multiple resource managers)
2) I CAN have transactions that update tables in different databases in the same SQL Azure instance!
??
OK, but is explicit client management of transaction for a single Azure SQL DB supported?
I.e. can one use .NET client transaction management functions, like SqlConnection.BeginTransaction?
Hi Wayne,
I've been following your blog for a while. Good resources for SQL Azure, well done!
I have a topic I would like to see covered but I haven't found anything on the web: environment & configuration. What are the recommended best practices to have configuration changing from a dev environment to staging & prod?
Let's say I would like my team to work on a local SQL Server in dev, an SQL Azure in Staging and another instance of an SQL Azure in prod. What is the best way to manage the connection strings?
Thanks in advance if you cover this and keep up the good work!
Vincent-Philippe
Krisha: 1) That is true. 2) That is not true, you can not currently update two different Azure databases in a single transaction.
Mike: SqlConnection.BeginTransaction maps to the SQL Server implementation of BEGIN TRANSACTION. msdn.microsoft.com/.../86773566.aspx so you can use that command.
