Aniket Narvankar

Aniket Narvankar

  • 538
  • 2.1k
  • 581.2k

Asp.Net and SQL

Aug 31 2019 6:00 AM
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.