JOINING TWO TABLES IN TWO DATABASES IN TWO DIFFERENT SERVERS AND RETURNING A DATASET

• Ronvy

  Mr or Mrs. 500

  Points: 597

  More actions

  April 9, 2006 at 8:57 am

  #116871

  I have two databases situated at two MS SQL Servers and one of them is kept as global.

   

  I have a table called MANUFACTURER table in the global DB and ITEMS table in the other DB.

   

  MANUFACTURER

  MfgID    MfgName   MfgDesc

   

  ITEMS

  ItemID    ItemName   ItemDesc MfgID

   

  Now I want to refer to MANUFACTURER table from the other database which is in the other server where my query is executed.

   

  For e.g. I want to create a dataset by joining the MANUFACTURER to ITEMS table and include Manufacturer name and description in this dataset, which i'll be using as a source of my datagrid in my interface.

   

  Ie;

  Resultant DATASET should be

  ItemName, ItemDesc, MfgName, MfgDesc

    

  Will I have to get the data to this server from the Global DB which is in the other?

   

  Can somebody help me with this, I'd be really, really grateful.

   

  Thanks so much,

  Ron.

• [KH]

  SSCommitted

  Points: 1908

  More actions

  April 9, 2006 at 9:23 pm

  #631650

  you can use linked server to link one SQL Server to another.

  Check it out from Books OnLine