Need to Upload a XML file to the server at regular interval and update sql database from that file.

Question

0.00/5 (No votes)

See more:

Hi,

I need to upload the xml file to the server at regular interval and update the sql database from that xml file. While uploading i need to be aware of copying the previous version of the xml file so that data is not lost in any case. I think we can upload the file at regular interval from scheduler in sql or there is some other best approach in MVC4. I can analyze the file status from file system watcher. The main concern is the best approach in the MVC4 for uploading the file after fixed interval of time and taking the backup.

Posted 15-Jan-14 20:33pm

genius4work

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

skydger · Answer 1 · 2014-01-15T21:01:00

Solution 1

Hello, consider to use MS SQL Integration Services[^]. For more informations please refer the following link:
Integration Services Tasks -> XML Task[^]
If you unable to use SSIS, consider to use CLR stored procedures or user defined functions to compose SQL Server jobs.

Posted 15-Jan-14 21:01pm

skydger

Dinesh.V.Kumar · Answer 2 · 2014-01-15T21:36:00

Use MS SQL Server Integration Services [SSIS]. It is very easy and does the work efficiently. If not you can do this with Windows Services.
Add a File watcher to watch a specific location
Once the file is available in the folder [File Watcher triggers an event],
rename the file by appending the datetime to the file.
You can then open it read the contents and move data to the table.

Regards,
Dinesh Kumar.V.