Merge statement between two SQL Azure databases hosted in same SQL azure server

Question

Hi Team,

Currently we have a SQL Virtual machine with two databases, namely Source_DB, Destination_DB (Both within in same SQL server).  And we have cross database merge statement to move data between them.

We have planned to migrate to SQL Azure Database.   So, I will create a SQL Azure server and create Source_DB & Destination_DB  databases in this server.  Is there any good performance way to run merge statement between these two SQL Azure databases present in same SQL server?

Regards,

Kannan Eswar.

Answer 1

I think that this article on Cross-Database Queries in Azure SQL Database can help you here:

https://azure.microsoft.com/en-us/blog/querying-remote-databases-in-azure-sql-db/

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-scale-overview-split-and-merge

---

Mustafa Toroman, Azure MVP