Comparing data in databases on two different servers

• Ron Kunce

  SSCrazy

  Points: 2128

  More actions

  November 28, 2007 at 3:39 pm

  #377260

  I need to do a comparisson of retailer chain and store records in two different databases on different servers. I could easily create the needed SQL if I were comparing data from two different databases on the same server but have never done it across multiple servers before. What do I need in my SQL to select data from a different server?

  Ron K.

  "Any fool can write code that a computer can understand. Good programmers write code that humans can understand." -- Martin Fowler

• Matt Miller (4)

  SSC Guru

  Points: 124210

  More actions

  November 28, 2007 at 4:31 pm

  #755188

  If you plan on doing this a lot - you should look at setting up a linked Server. That will allow you to access the data from a remote server on the local server.

  Otherwise - take a look-see into the syntax for OPENQUERY, OPENDATASOURCE, or OPENROWSET. They should point you in the right direction.

  ----------------------------------------------------------------------------------
  Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

• Ron Kunce

  SSCrazy

  Points: 2128

  More actions

  November 28, 2007 at 4:37 pm

  #755190

  Thanks Matt!

  Love your take on the "lack of planning - emergency" quote!

  Ron K.

  "Any fool can write code that a computer can understand. Good programmers write code that humans can understand." -- Martin Fowler

• Matt Miller (4)

  SSC Guru

  Points: 124210

  More actions

  November 28, 2007 at 4:41 pm

  #755191

  Thanks! - when all of your end-users are doctors (who think of themselves as royalty), then you tend to have to play fireman a lot....:P

  ----------------------------------------------------------------------------------
  Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?