This questions has been covered (slightly) in various topics but I never really found one that hit the mark 100%. Basically I have a program that runs under KiX and compiles lots of information on software/hardware on a machine (~2500 machines currently) then sends this in a text file to a central location. This is parsed into a csv file then imported into access. ASP is then used to display on the web.

Anyway, I am looking at expanding this application throughout our environment and realise that copying flat files about is pretty horrible. Which leaves me with the issue of copying about files. The current file i copy is only a few lines (~1k).

My options as I see them are to either go with SQL (I can use KiX for this) or look at re-writing the script in some other language.

The questions I have are:

  • Is SQL the right way to go?
  • Is Kix the right way to go for a potentially global product (~10000 machines)
  • Is SQL efficient in terms of bandwidth. I.e. 4 lines to text translates to small information transmittal.


I have had a look about on various sites and nothing really seemed to hit the mark. Any help would be much appreciated and I would be willing to share the work I have done.