I suggest you ...

'Linked Server' has been merged into this idea

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.

502 votes
Vote 0 votes Vote Vote
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service

    You'll receive a confirmation email with a link to create a password (optional).

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    anonymousanonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    anonymousanonymous shared a merged idea: Linked Server  ·   ·  Show description
    anonymousanonymous shared a merged idea: Allow 3-part synonyms (database.schema.object) to use other databases in the server.  ·   ·  Show description

    15 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service

      You'll receive a confirmation email with a link to create a password (optional).

      Signed in as (Sign out)
      Submitting...
      • Toby PageToby Page commented  ·   ·  Flag as inappropriate

        Hugely important for our implementation. Left us with some horrid code-based solution (merging datatables) and thinking whether Azure is really right for us...

      • Amit AroraAmit Arora commented  ·   ·  Flag as inappropriate

        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?

      • Rick JewsonRick Jewson commented  ·   ·  Flag as inappropriate

        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!

      • Johan van TonderJohan van Tonder commented  ·   ·  Flag as inappropriate

        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 GAidan G commented  ·   ·  Flag as inappropriate

        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 GMike G commented  ·   ·  Flag as inappropriate

        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.

      • Tim ShafferTim Shaffer commented  ·   ·  Flag as inappropriate

        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.

      • Simon LampenSimon Lampen commented  ·   ·  Flag as inappropriate

        This would help with functions like warehousing of reporting data to another database to keep the main transactional db performant.

      Knowledge Base and Helpdesk