LOG2SQL

This tool imports W3C Extended Log File Format log-files to MS SQL database. It works on 32bit Windows platform and requires .NET Framework v1.1 or v2.0 to run. Access to local or remote MS SQL Server is necessary.

Download: log2sql-2006-11-24.zip (~35k) Support: Report a problem or request a feature

Features

• Automated creating LOG tables and LOG database (/i option)
• Importing W3C Extended Log File Format log files to MS SQL database
• Importing processing is optimized by keeping track of loaded LOG files

Content of package

Two executables - log2sql11.exe and log2sql20.exe for use depending on framework version;

Installation instructions

Download and uncompress to any new folder on your local hard disk. No additional installation steps are necessary.

Usage instructions

1. Start Command Prompt (Run cmd);
2. Drag log2sql11.exe or log20sql2.exe into Command Prompt window, from where you unzipped it;
3. Press Enter in Command Prompt window. Simple usage instructions follow: Command Line Switches: /l:<LogPath> Path to log-files (multiple allowed)
   /h:<Host> SQL Server host name or IP address (default is localhost)
   /d:<Database> Database name (default is LOGS)
   /t:<Table> Table name (default is LOGS)
   /i Install (create the database and log table)

Examples

1. Import logs to local SQL server:
   log2sql20.exe /l:%windir%\system32\LogFiles\W3SVC1 /l:%windir%\system32\LogFiles\MSFTPSVC1 /l:%windir%\system32\LogFiles\SMTPSVC1
2. Import w3 logs to w3 table, create the table if it is missing:
   log2sql20.exe /i /t:w3 /l:%windir%\system32\LogFiles\W3SVC1
3. Import ftp logs to ftp table, create the table if it is missing:
   log2sql20.exe /i /t:ftp /l:%windir%\system32\LogFiles\MSFTPSVC1
4. Import smtp logs to smtp table, create the table if it is missing:
   log2sql20.exe /i /t:smtp /l:%windir%\system32\LogFiles\SMTPSVC1