How to deal with file import into database? asp.net, MSSql
Posted on 2012-03-18
Purely at a theoretical level, I don't know if there is a "correct" answer. I know this is really general but I would appreciate some advice.
I have a project that requires a file import on a daily basis. I'd like to optimize the database but I'm not sure what's best in this situation. I've never had to deal with a daily import of data before.
The daily list is a .csv file that is a list of vehicles with make, model, year, condition, but also includes stuff like address, city, etc. The database itself will include this imported list and mainly administration type things like: Admin, Users, Offers and then layout/display type info to facilitate searches/display, etc.
Is it worth the time to import the list, then transfer to tables like, Address, Vehicle, Users, Admin and do the foreign key, typical database structure?
Or should I just leave the list as is and only optimize the Admin stuff?