I am stuck on one task.Please guide me how to proceed.
 
In sql i have A server and B server
On A server I have C Database and D Table in it.On B Server I have C Database and D Table in it.I want to create a windows scheduler in asp.net which will copy records from C Database and D Table on B server and update it in D Table of C Database on A server if present.If not present insert the same.I do not have link server available.Please guide me on this.A way to do this.There are around 65 thousand records on B server.Also first time scheduler runs it will update or insert the records.Next time when it will run it should not update the previously updated ones.