(1) create linked server on the source server against the destination server
(2) write your stored to do batch processing (such as insert into destinationserver.dbo.destinationtable select * from sourcetables)
(3) schedule the stored proc to run periodically using SQL Server Agent