Sunday, November 18, 2012 5:30 AMI have a SQL Azure Server (DBn), I need to copy some of the tables from (DBn) to number of other SQL Azure Servers (DBn1,DBn2,....). I should be able to execute the copy operation through a worker role. Is this possible via Linked server feature in SQL Azure?
- Moved by Iric WenModerator Monday, November 19, 2012 8:53 AM (From:Data Mining)
Monday, November 19, 2012 9:07 AMModerator
Yes, it is possible.
We can add a Windows Azure SQL Database as a Linked Server and then use it with Distributed Queries that span the on-premises and cloud databases. This is a new component for database hybrid solutions spanning on-premises corporate networks and the Windows Azure cloud.
Please refer to these blogs:
TechNet Community Support
- Marked As Answer by Iric WenModerator Monday, November 26, 2012 1:34 AM
Tuesday, November 20, 2012 2:23 AMAnswererafaik, you can add Azure SQL Database as a linked server in SQL Server but you cannot add a linked server to another Azure SQL Database from within Azure SQL Database itself. there is no feature for adding a linked server from within Azure SQL Database itself.