Query to copy rows from sql server to another sql server

Question

I have two sql servers, SE1 and SE2, they are basically having the same schema, but each one has its own usability. I need to find a query to copy some rows from SE1.Table1 Where Destination Like '%HR%' to SE2.Table2. Is there such query ?? Thx in advance.

Answer 1

I find the easiest way is to add a remote connection from one to the other. So, go to the second server and do:

sp_addlinkedserver SE1

Then you can go to the database you want to use and do something like:

insert into database.dbo.Table1(<column list>)
    select <column list>
    from SE1.database.dbo.Table1
    where col like '%HR%';

This uses the four-part naming convention to access the remove table.