Support Get Quote

Other Resources

    Migrate EventLog Analyzer Data from MySQL to MSSQL Database

    Post database change steps for Managed Server

    • When the Managed Server is installed, it is registered with Admin Server as Managed Server with MySQL. If the database of the Managed Server is changed from MySQL to MSSQL, it has to be re-registerd with Admin Server as Managed Server with MSSQL.
    • After changing the database, when the Managed Server is started as application, it will prompt the user to re-register with the Admin Server.
    • After changing the database, when the Managed Server is started as service, there will not be any prompt to re-register. User has to ensure that the Managed Server is re-registered with the Admin Server.


    EventLog Analyzer lets users to migrate the existing EventLog Analyzer data available in MySQL database to MSSQL database.

    This procedure is applicable only if you are already using the EventLog Analyzer with MySQL and you want to change the database to MSSQL.
    If you want to configure the MSSQL for fresh installation of EventLog Analyzer server, please refer the Configuring MSSQL Database page and follow the procedure given there.

    The steps to migrate and run the Eventlog Analyzer server with SQLSERVER as the database is given below:

    1. Stop the Eventlog Analyzer Server/Service.

    2. Invoke the <Eventlog Analyzer Home>toolsbackUpDatabase.bat in command prompt, to backup the data available in MySQL database and wait till the data backup is getting completed. By default backup file will be stored under <Eventlog Analyzer Home>backup directory with the file name like 'backup_eventlog_<Build_Number>'.

    3. From the installed MS SQLSERVER, copy the files bcp.exe and bcp.rll to <Eventlog Analyzer Home>mysqlbin folder.

    Note: If you are copying the above file from SQL Server (Version 2005 & above) installed server and the EventLog Analyzer is installed in other machine, please install the following SQL Native Client in the EventLog Analyzer machine as per the SQL vesion and CPU type of EventLog Analyzer machine.

    MSSQL 2005 (32 bit)

    MSSQL 2005 (64 bit)

    MSSQL 2008 (32 bit)

    MSSQL 2008 (64 bit)


    For Windows Authentication, enter the Domain Name, User Name and Password. Ensure that both EventLog Analyzer server and SQL Server are in the same domain and logged in with the same Domain Administrator account.

    Win authentication

    1. Invoke the <Eventlog Analyzer Home>toolschangeDBServer.bat in command prompt, to configure the MS SQLSERVER credentials like ServerName, Port, UserName and Password.

    2. Database Setup Wizard pops-up.

    3. In the wizard screen, select Server Type as SQL Server. Available SQL Server Instances are listed in a combo box. Enter the Host Name and Port of the SQL Server from the instances.

    4. Select the authentication type using the "Connect Using:" options.

    5. The options are:

    • Windows Authentication

    For SQL Server Authentication, enter the User Name and Password.

    SQL authentication

    • SQL Server Authentication


    1. Click Test button to check whether the credentials are correct. If the test fails, the credentials may be wrong, recheck and enter the correct credentials.

    2. Click Save button to save the SQL Server configuration. Note that, it will take few minutes to configure the settings of the SQL Server database.

    3. Invoke the <Eventlog Analyzer Home>binrun.bat to start the Eventlog Analyzer server in the command prompt.

    4. After the server is started completely, stop the server by terminating the run.bat in the command prompt or invoke the <Eventlog Analyzer Home>binshutdown.bat

    5. Invoke the <Eventlog Analyzer Home>toolsrestoreDatabase.bat, browse and select the created backup file. Now click on 'OK' and wait till the database is completely restored.

    Restore data

    Executing the restoreDatabase.bat will delete the existing data, if any.
    1. Start the Eventlog Analyzer Server/Service to work with the MS SQLSERVER as the database.

    Note: You can also change the backup directory. Execute the batch file to backup by passing the absolute path of the directory as argument in the command prompt. Example command execution as follows:
    <Eventlog Analyzer Home>tools:>backUpDatabase.bat D:Mysql

    EventLog Analyzer Trusted By

    Los Alamos National Bank Michigan State University
    Panasonic Comcast
    Oklahoma State University IBM
    Accenture Bank of America
    Ernst Young

    Customer Speaks

    • Credit Union of Denver has been using EventLog Analyzer for more than four years for our internal user activity monitoring. EventLog Analyzer provides great value as a network forensic tool and for regulatory due diligence. This product can rapidly be scaled to meet our dynamic business needs.
      Benjamin Shumaker
      Vice President of IT / ISO
      Credit Union of Denver
    • The best thing, I like about the application, is the well structured GUI and the automated reports. This is a great help for network engineers to monitor all the devices in a single dashboard. The canned reports are a clever piece of work.
      Joseph Graziano, MCSE CCA VCP
      Senior Network Engineer
    • EventLog Analyzer has been a good event log reporting and alerting solution for our information technology needs. It minimizes the amount of time we spent on filtering through event logs and provides almost near real-time notification of administratively defined alerts.
      Joseph E. Veretto
      Operations Review Specialist
      Office of Information System
      Florida Department of Transportation
    • Windows Event logs and device Syslogs are a real time synopsis of what is happening on a computer or network. EventLog Analyzer is an economical, functional and easy-to-utilize tool that allows me to know what is going on in the network by pushing alerts and reports, both in real time and scheduled. It is a premium software Intrusion Detection System application.
      Jim Lloyd
      Information Systems Manager
      First Mountain Bank

    Awards and Recognitions

    A Single Pane of Glass for Comprehensive Log Management