SQL Server Copy tables from one Server Database to another Servers Database

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
exec sp_addlinkedserver @server="SQLListener,2433" --OR exec sp_addlinkedserver @server="MyServer\SQLInstance"
Next, we need to have a list of all the column names so we can prepare them for the insert statement.

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