Get the table data from one server and fetch into table of other server

hi
here I am adding an instructions which you can follow to accomplish your task

1)write Wcf Service in that two method one which takes data from one server (the connection string can be kept in web.config file)
2) another method which inserts data to other server (the address of other server can be retrieved from web.config file).

now you can refer another posts to write WCF service.
how to write a simple WCF service