how to copy table from differet server

• manik-255187

  SSC Rookie

  Points: 38

  More actions

  August 24, 2005 at 10:24 pm

  #363487

  how to copy data from table, from one server to another server. using simple query.

  i give example in one server

  insert into test..categories from select * from northwind..categories.

  in my case i use different server. so how to do it, only using simple query.

• ramesh_kondaparthy

  Ten Centuries

  Points: 1069

  More actions

  August 24, 2005 at 11:41 pm

  #584861

  Add the Server1 as linked server to Server2, using sp_addlinkedserver.

  In Server2 Query Analyzer

  sp_addlinkedserver 'server1'

  Then in Server2 Queryanalyzer use this query to get the data

  Select * from Server1.northwind.dbo.[tablename]

   

  Regards,

  Ramesh K

• AJ Ahrens

  SSC-Insane

  Points: 20676

  More actions

  August 25, 2005 at 5:28 am

  #584911

  OR you could use the import/export wizard OR a DTS package with copy objects OR ....

  
  
  Good Hunting!

  AJ Ahrens
  
  
  webmaster@kritter.net