How to use Cross database table in Azure?

Jan 4 at 4:26 AM
Happy New Year all :)

In my trigger a other database table has been referenced, could you please advise how to achieve cross DB queries in Azure.


Thanks,
Arunraj.
Coordinator
Jan 4 at 4:41 AM
Hi Arunraj,

Azure SQL DB does not support cross database joins. You will have to move the trigger logic to the middle tier and let it update both the primary and secondary databases (think parallel threads).

Sorry,
George
Jan 4 at 4:53 AM
Thanks George for your quick reply, I will try to move this trigger logic to my code base middle tier.

Thanks,
Arunraj.
Coordinator
Jan 14 at 4:53 AM
Arunraj

There is also a new feature in azure to support cross database joins. This may resolve your issue: Cross DB Joins in Azure

Thanks

Lonny
Jan 14 at 6:34 AM
Thanks Lonny, I will try this for my case and get back here for any issues.

Thanks,
Arunraj.