Connect Two Different databases on two Different Data server Locations

• sajidsdali

  Valued Member

  Points: 51

  More actions

  April 18, 2013 at 11:22 pm

  #292413

  Hi Friends,

  i had a requirement , which leads to work on two database on two different data servers. Now my Problem is how to connect one database to another database.

  i have to access the other database procedures and other operation like CRUD .

  Please give me some examples or Idea to approach

  Thanks in Advance

• Stuart Davies

  SSCoach

  Points: 19505

  More actions

  April 19, 2013 at 12:54 am

  #1608088

  Hi,

  Firstly, you need to link the servers, after that it is fairly straight forwards:-

  select * from database.schema.table1

  inner join server.database.schema.table2

  on . . . . . .

  You only need to specify the server for the linked server - the above, very rough example means that table1 is on the local server

  Hope this helps

  -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
  There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
  I would never join a club that would allow me as a member - Groucho Marx