I have a csv file in which data are continuously inserting by a program. I want to read that data continuously or at certain interval and insert (not update) that data to a certain file.
Time interval may be at each 5 min. I just want to get the latest data inserted to table. It is expected that within 5 min maximum 200 new data may inserted to that csv file. 99.5 % reliability required for this process.
My first preference is MS SQL server 2008 express edition. if the solution is not possible with that, Please suggest the cheapest product I can use to achieve solution.
However, I also need to make backup for one week long csv file and start with a empty csv file. How can I avoid downtime?
I have no need to keep transaction log. Please help.