sql - 将 Web 服务器日志(apache、iis 等)转换为关系数据库

Question

我有一些 Apache 日志，我希望能够查询其中的数据。
所以我想知道是否可以将此日志数据转换为关系数据库，以便我以后可以使用 sql statments 查询和分析数据。
谢谢

Answer 1

Log Parser Microsoft 将允许您使用 SQL 查询各种类型的数据，而无需对其进行转换。

Log parser is a powerful, versatile tool that provides universal query access to text-based data such as log files, XML files and CSV files, as well as key data sources on the Windows® operating system such as the Event Log, the Registry, the file system, and Active Directory®. You tell Log Parser what information you need and how you want it processed. The results of your query can be custom-formatted in text based output, or they can be persisted to more specialty targets like SQL, SYSLOG, or a chart.