Sometimes, you may need to copy data from one SQL Server database to another Server.

This comes in handy if you have a lot of data that has changed and you cannot perform a full backup and restore on the database itself, but only need to import data into one table.

First, we need to create a LINK to the other Server

[SQL Server - Create a LINK to the other Server]

CFFCS | CarrzSynEdit: | SQL Script

exec sp_addlinkedserver @server="SQLServerListener,2433"
--OR

exec sp_addlinkedserver @server="MyServer\SQLInstance"

Next, we need a list of all column names so we can prepare them for the insert statement.

[QL Server - List all columns from Remote Server]

CFFCS | CarrzSynEdit: | SQL Script

insert into TableTemp_New (Col1, Col2, Col3, Col4, Col5, Col6) 
Select Col1, Col2, Col3, Col4, Col5, Col6 from [SQLServerListener,2433].DB_Name.dbo.TableTemp_New as ev2