Radim Motycka

Radim Motycka

  • NA
  • 31
  • 32k

Importing data into DB

Nov 16 2011 9:18 AM
Hello,
Please would you advise? I have a pile of txt files in this format.


111010 ####User:  xxx
111010 ####Computer:  yyy
111010 Adobe Flash Player 10 ActiveX 10.2.152.26
111010 McAfee Agent 4.5.0.1810
....

The number of lines depends on the amount of installed soft. And these reports are generated weekly.

DB should look like:

USER;COMP;SOFT;VERSION
xxx;yyy;McAfee Agent,4.5.0.1810
...;....;....;....

After that I will be building ASP application over it.

I was thinking to use powershell to somehow format it into csv and then import it. Do you have any better idea how to manage it? Or how to design the DB? Some free tool maybe? How to manage the weekly import into DB etc.. server is 2008R2.

All ideas will be really appreciated.

Many thanks!



Answers (1)