427 votes
Cross database reference
The ability to query (read-only) data from a difference database or linked server. This will allow to reference (join) some tables from the source database and build views that uses two or more SQL Azure databases.

Rick Jewson
Can we have an indication of whether this feature will be worked on soon? According to everyone I spoke to at AuTechEd, it was thought it must have been an oversight! Some form of roadmap would really help!
meenxip
Cross Database reference is essential feature for many reasons. We must have it!
Johan van Tonder
It would enable more possibilities for true cloud-computing, since our on-premise enterprise systems are based around a core database surrounded by other seperate application databases which "plugs" into the main one, hence cross database queries are the norm. With this in the cloud, building cloud-apps that build other apps becomes possible. If this is your everyday business, and it is not supported by SQL Azure, you cannot and will not move to SQL Azure.
Aidan G
Hi
This would be perfect for our setup. We have 600+ rules, since we will be running, eventually, 100's of databases, then I will have to replicate and maintain on each database, which is a pain :)
Mike G
Again lots of our software writes queries that is across multiple databases, mostly on the same server. Without this we will not be able to move any of our products to SQL Azure. I can't think of any efficient way of running the queries without just merging all the databases into one big database... which I don;t want to do.
Sridhar
our databases are heavily dependent on these.
Melissa Sue Perry
we should get it for free for windows
Tim Shaffer
I need to be able to Insert/Update data in 1 SQL Azure database with select results from another SQL Azure database inside a stored procedure. This is required to migrate my data warehousing databases to SQL Azure. Urgently needed within 60 days.
Lukas Swom
yes this would be absolutely usefull!
Simon Lampen
This would help with functions like warehousing of reporting data to another database to keep the main transactional db performant.