October 15, 2008 at 6:35 am
Guys,
I have a utility on each server that runs every quarter to generate HTML report of the server (like what is OS patached to, CPU utilization, drives etc).
Is there any way to import html files into SQL database and query it. In the sense that view source of each HTML can it be loaded into the database
as XML datatype and query the same. if so please provide any inputs to load such files and query them.
Thanks
October 15, 2008 at 6:38 am
You can definitely load up HTML documents as binary documents. I'd assume that XML would work as well.
As far as querying, it would query like any other XML document, though with multiple
tags, you might find yourself struggling a bit since it might be less hierarchical than a regular XML document.
How is the HTML document generated? Perhaps you're be better off getting the data and storing that.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply