Firstly you need to create a windows service then you can use anyone of following option to implement your requirement:
Option 1: SQL script generating through manual tool.
Transfer data or script between two SQL Server databases[
^]
Option 2: Through Linked Server
Step1: Create your table on the target serve .
Step2: On the target server, you can execute a StoredProcedure:
INSERT INTO dbo.YourTargetTableNameHere
SELECT *
FROM [SourceServer].[SourceDatabase].dbo.YourSourceTableNameHere
Go through below link to create Linked server:
How to Config Linked Servers in a Minute[
^]