Synchronization csv file to Database

AlbertNguyen

New member
Joined
Jul 10, 2013
Messages
1
Programming Experience
Beginner
Hi everybody, SQL Server 2008 R2

I am making a simple tool to synchronize data from csv files to SQL Server Database.


My SCADA Signal transfer data through csv files (3 SCADA signals --> 3 csv files) and datas will be transfered 1time/1day.
And I will make a simple tool, read csv files and import to SQL Server Database.


My issues are:
1. I have no ideas how to handle the csv files when they were transfered back with diffirent names.
2. How to set time to synchronize (1time/1day).
3. Can I make a windows service to synchronize?


Please help me.
If you have the user interface for issue 1, please give me!


Thank you very much
 

jmcilhinney

C# Forum Moderator
Staff member
Joined
Apr 23, 2011
Messages
3,225
Location
Sydney, Australia
Programming Experience
10+
1. I don't really know what you mean by that. Are you saying that you don't know what the name of the source file will be?
2. If your app is always running then you can use a Timer to raise an event at a regular interval. If your app only runs for this purpose then you can use Windows Task Scheduler.
3. Yes.
 
Top Bottom