Lesson Learned #475:Cross-Database Queries Read and Write in Azure SQL Database.
This week, we addressed a service request from a customer who wanted to keep two tables synchronized across different databases on the same Azure SQL Database server. Unfortunately, in Azure SQL Database, it's not possible to directly call the database in the operation, for instance using the command select * from master.sys.sys_databases . For this reason, I'd like to share an alternative to tackle this limitation.
