Synchronise database A with xml retrieved data from database B (webservice) and Insert,update, delete missing column

Question

I am using c# console application program to synchronize data. Previously i get the data from database B using web service json Restful which returns a XML document. After extraction of data from the XML, its inserted to my MSSQL database. I need to run the application everyday at a certain time to make sure the database is updated on my side. How to write a certain codes at my console app so that it sync the data from the XML (database B) and my data from my MSSQL? Insert, update and delete after comparison. If there is missing rows on my table, i update the rows and deletes if there is additional rows.

I've already looked into it. Are there any other alternatives? — huiru, Sep 17 '15 at 06:17

score 0 · Answer 1 · edited May 23 '17 at 12:14

0

Use Windows Service with Quartz (Cron Job Scheduler)

Read this question: Simple, working example of Quartz.net

Quartz is one of the best Job Scheduler out there for Windows Service

edited May 23 '17 at 12:14

Community

1
1

answered Sep 17 '15 at 02:11

VJPPaz

917
7
21

Synchronise database A with xml retrieved data from database B (webservice) and Insert,update, delete missing column

1 Answers1