Do Azure Elastic Database Pools allow Cross Database transactions?

0
votes

We have Stage database, which contains stored procedures, and transfers data into an OLTP Database.

Do Elastic SQL Databases reside on same server, and give ability to conduct cross-db stored procedure transactions?

Would Elastic databasepool allow this?

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-pool

1
sql-serverazuredatabase-designazure-sql-databaseazure-elasticpool

1 Answers

0
votes

You can achieve elastic transactions spanning across databases using .NET client applications. This is currently under preview.

Elastic transactions at server side are planned in future.

for more information