Yes you can do that using linked server.
Create one SP to insert to your records from one server db to another server db .
You can create a job and set your intervel like how freequently you need to run the SP.
Google for Linked server and for running Job in SQl