19. Working with Database
You can read events stored in a database and you can upload events into a database table.
Event Log Explorer Viewer 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.
Load events from table
If you use Event Log Explorer Enterprise Edition and collect events using Elodea Event Collector, you already have event tables as Elodea feeds.
To load events select Database -> Load from table.
Select the required table name and click OK.
Event Log Explorer Viewer will display events from the database table as a native windows event log.
Create database
You can create a new database and upload your own logs directly from Event Log Explorer Viewer.
Although it's recommended to create new databases from special tools like SQL Server Management studio, you create a new database directly from Event Log Explorer Viewer.
To create a database, select Database->Connect and 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 if required select Append if table exists option. If checked Event Log Explorer will append events to the existing table. If not checked and the table exists, Event Log Explorer will delete all events from the table before upload.
