Transporting data from Remote server

• sqllearner-339367

  Hall of Fame

  Points: 3004

  More actions

  May 7, 2009 at 9:14 am

  #95199

  Does we need add a remote server as linked in server to access the data and port it to our local database. In addition to this can we access them using Ip Address?

  Ta

• Florian Reischl

  SSC-Dedicated

  Points: 37301

  More actions

  May 8, 2009 at 8:42 am

  #991152

  Hi

  Usually you should use a linked server. Other approaches are OPENROWSET or OPENDATASOURCE but the best (simplest) way should be a linked server.

  Greets

  Flo