Querying multiple database

• boo

  Newbie

  Points: 9

  More actions

  July 26, 2005 at 12:16 am

  #363254

  Hai all,

  I need to query multiply database like sql, oracle, db2 and collect the information to another centralized server. this is oneway, i cannot add any thing to the existing servers, but i can qurey from the centralized server. Can anyone tell me how to achive this thing.

  thanks in advance,

  cheers,

  boopathi

• raj-247939

  SSCertifiable

  Points: 5999

  More actions

  July 26, 2005 at 1:52 am

  #577081

  Hi,

  Can u create linked server respective to ur databases.

   

  from

  killer