Firstly you need to create a windows service then you can use anyone of following option to implement your requirement:
: SQL script generating through manual tool.
Transfer data or script between two SQL Server databases
: 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
Go through below link to create Linked server:
How to Config Linked Servers in a Minute