-2

I am using two SQL 2012 servers and am trying to link them together so I can import data between the two. I have read online that the way to do this is to utilize one as a linked server that is linked to the other. However, what I see online is that you have to create a linked server. Neither server that I am utilizing are linked already. Is there a way to make one of the servers linked so that I can send data from it to the other?

Duncan Leathrum
  • 21
  • 3

1 Answers1

1

Here are a couple of links on how to set that up.

How to Create a Linked Server

StackOverflow Answer

Calling Linked Server In Query

Once you have the linked server set up, you could do this:

INSERT INTO yourtable --table you are importing data into
SELECT *
FROM [server].[database].[schema].[table] --server you are exporting data from
Jason
  • 945
  • 1
  • 9
  • 17