SQL Data Transfer

data-migrationsqlsql-server

I need to transfer data from one table to the same table in another server which has been truncated. What is the easiest way to do this?

Best Solution

Setup linked servers and then use the following on the destination database:

INSERT INTO existingTable (col1,col2..)

SELECT col1,col2...
FROM linkedserver.dbo.database.othertable