VB.net and databases - create new databases/results
Posted on 2007-08-10
I've a vb.net application that connects to an external device and gathers data in tab delimited forms every 2 secs. The data comes simply as a long string with 50 values tab separated for processing.
This data needs to be stored along with calculated results.
The user will create different "projects" on each run on the software, by clicking "Start recording data" to start retrieving the data every two seconds.
I'm not sure whether the data retrieved (and results calculated from it) should be dumped into an SQL server database - in which case a blank database needs created every times the user clicks "Start recording data" or
into an XML file...
or any other database for that matter.
Whats are the thoughts of experts on way to go - server 2005 or XML or other?
If server 2005 I'd need to know how to create new replica of blank database (included in installer) each time the user clicks "Start recording data"
If as an XML file, should the file be saved each 2 seconds, or just at end of recording, or at certain intervals?
Recording may be up to two hours, 50 fields each 2 seconds.
Thanks in advance for help and advice