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.
We announced the public preview of elastic database query at \Build recently. Full details at http://azure.microsoft.com/en-us/documentation/articles/sql-database-elastic-query-overview/
Matthew Allen commented
This would be very useful for some of our systems.
Kameron Voller commented
Please add the cross database reference feature. If your goal is to get IT departments to move their databases to Azure then this is a must have
Jose Antonio Ocampo commented
Same problem we need to avoid merging databases.
Toby Page commented
Hugely important for our implementation. Left us with some horrid code-based solution (merging datatables) and thinking whether Azure is really right for us...
Sudheer kumar commented
This would be helpful for migrations.
While Migrating, this will be very usefull feature
Amit Arora commented
If this feature is available, a substantial number of existing apps can move to sql azure, not just those being written from scratch specifically targetting azure. Can you explain if there are any architeture level restrictions and is this feature at least being mulled over for a future release of azure?
this is a big sad story since it was announced i think.
Rick Jewson commented
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!
Cross Database reference is essential feature for many reasons. We must have it!
Johan van Tonder commented
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 commented
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 commented
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.
our databases are heavily dependent on these.
Melissa Sue Perry commented
we should get it for free for windows
Tim Shaffer commented
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 commented
yes this would be absolutely usefull!
Simon Lampen commented
This would help with functions like warehousing of reporting data to another database to keep the main transactional db performant.