Setting up the database |
Top Previous Next |
EventSentry uses a set of tables where event log information is stored. Starting with version 2.50, the table names cannot be customized anymore but are instead hardcoded into the application.
MS SQL Server If you are using MS SQL Server, then you can have the database for EventSentry created automatically during the installation, no further action will be required. Just make sure that you select Setup MS SQL Server when installing EventSentry. You can still create additional database with the Database Setup Wizard.
MS Access When using MS Access simply use the installed MS Access database located in the installation directory of EventSentry. Again, make sure that you select Install Sample Access Database during the installation.
MySQL and Oracle If you are using a different database or were not able to automatically setup the database with the installer, then you can use the database setup wizard located in the Start Menu. The database setup wizard is a GUI application that currently supports MS SQL Server, MySQL and Oracle and will create the tables, indexes and permissions that are required for the EventSentry database consolidation to work. Please see Database Setup Wizard for more information.
Please see the next chapters for more information on the relationships between the main and heartbeat tables with the lookup tables.
|