Easiest method:(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
(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