Cross database reference

Discussion in 'Pre-sales questions' started by Guest, Sep 20, 2012.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. Guest

    Guest Guest

    Does Discountasp.net support cross database reference? Say I have two different MS Sql server 2012 databases. Will I be able to write a query and joins two tables from different databases..
     
    Guest, Sep 20, 2012
    #1
  2. mjp

    mjp

    Not on databases we host I'm afraid.
     
    mjp, Sep 20, 2012
    #2
  3. Guest

    Guest Guest

    I am not sure if you misunderstood my question but I was able to create a new login and add the new login to both of the databases.. Now I can cross reference them like example below

    select Firstname from DatabaseA.TableA Inner Join DatabaseB.TableB
    on DatabaseA.TableA.EmpNum = DatabaseB.TableB.EmpNum
     
    Guest, Sep 27, 2012
    #3
  4. mjp

    mjp

    I see, good.

    That works if the databases are on the same server, but that's not always the case if the databases were ordered and set up at different times. They could be on different SQL servers and then you would have a problem with your query. I should have been more specific.
     
    mjp, Sep 27, 2012
    #4
  5. RayH

    RayH DiscountASP.NET Lackey DiscountASP.NET Staff

    Just wanted to reiterate that cross-database joins are only possible if the databases reside on the same server. You will have to plan out your databases in advance and order them at the same time to increase the likelihood that they will be created on the same server. Our provisioning process is automated, and we can't move the databases once you order them.
     
    RayH, Sep 27, 2012
    #5
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page