Openrowset is performance impact option. use linked server. sp_addlinkedserver will help you to add the link server and you can proceed the servername before DB.TableName in the query
select * into server1.DB1.dbo.Targettable from server2.DB2.dbo.SourceTable
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)