Working with database
You can read events stored in a database and you can upload
events into a database table.
Event Log Explorer support Microsoft SQL Server databases.
First you should connect the database. To do so, select
Database->Connect from the main menu.
You cannot connect more than one database simultaneously. If you
want to connect another database, you should disconnect the
connected database before establishing a new connection.
To disconnect from the database, select Database->Disconnect
from the main menu.
Although it's recommended to create new databases from special
tools like SQL Server Management studio, Event Log Explorer lets
you create a new database.
To create database, click Create New Database in Database
Connect dialog, type server name and your credentials and click
Connect button. Then type database name, its file parameters and
review or modify database creation script. Click Create button to
start the creation script.
Upload events into table
To upload events into a table from the active event view, select
Database->Upload to Table from the main menu.
In Upload to table dialog, type table name and select the
required upload options.
- Append if table exists – if checked, Event Log Explore will
append events to the existing table. If not checked and table
exists, Event Log Explorer will delete all events from the table
- Export XML data – if checked, Event Log Explorer will extract
XML for each event and upload it into the table. This may take long
time on large event views, so we recommend using Event Log Database Export utility to upload
Load events from table
To load events from the database, select Database -> Load
Select the required table name and click OK.
Event Log Explore will display events from the database table as
a native windows event log.
Event Log Database Export utility