Migrate EventLog Analyzer Data from PGSQL to MS SQL Database

EventLog Analyzer allows you to migrate the existing EventLog Analyzer data available in the PGSQL database to the MS SQL database.

This procedure is applicable only if you are already using the EventLog Analyzer with PGSQL and you want to change the database to MS SQL.

If you want to configure MS SQL for a fresh installation of the EventLog Analyzer server, please refer to the Configuring MS SQL Database page and follow the procedure given there.

The steps to migrate and run the EventLog Analyzer server with SQL SERVER as the database is given below:

1. Stop the EventLog Analyzer Server/Service.
2. Invoke the <EventLog Analyzer Home>/tools/backUpDatabase.bat in command prompt to backup the data available in the PGSQL database and wait till the data backup is completed. By default, the backup file will be stored under <EventLog Analyzer Home>/backup directory with the file name 'backup_eventlog_<Build_Number>_database_MM_DD_YY_hh_mm.data'.
3. From the installed MS SQL SERVER, copy the files bcp.exe and bcp.rll to <EventLog Analyzer Home>/bin folder.
Note: If you are copying the above files from SQL server (Version 2012 and above) and EventLog Analyzer is installed in another machine, please install the SQL native client as per the SQL version and CPU type of the EventLog Analyzer machine.

For MSSQL version 2012, install the native client and for the remaining versions of MSSQL, install the ODBC driver (links given below).

MSSQL 2012

https://www.microsoft.com/en-us/download/confirmation.aspx?id=50402

MSSQL 2014

https://www.microsoft.com/en-us/download/details.aspx?id=36434

MSSQL 2016

https://www.microsoft.com/en-us/download/details.aspx?id=50420

MSSQL 2017

https://www.microsoft.com/en-us/download/details.aspx?id=53339

MSSQL 2019

64bit link: https://go.microsoft.com/fwlink/?linkid=2137027

32bit link: https://go.microsoft.com/fwlink/?linkid=2137028

MSSQL 2022

64bit link: https://go.microsoft.com/fwlink/?linkid=2266640

32bit link: https://go.microsoft.com/fwlink/?linkid=2266742

4. Invoke the <EventLog Analyzer Home>/tools/changeDBServer.bat in command prompt to configure the MS SQL SERVER credentials like ServerName, Port, User Name and Password.
5. Database Setup Wizard pops-up.
6. In the wizard screen, select Server Type as SQL Server. Available SQL Server Instances are listed in a combo box. Enter the Device Name and Port of the SQL Server from the instances.
7. Select the authentication type using the "Connect Using:" option.
8. The options are:
• Windows Authentication
• SQL Server Authentication
Note: Ensure that both EventLog Analyzer Server and MS SQL Server are in the same domain and logged in with the same Domain Administrator credentials.

Windows Authentication

For EventLog Analyzer version 8.0 (Build 8010) onwards,



SQL Server Authentication

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


9. Click the Test Connection button to verify the correctness of the credentials. If the test fails, recheck and enter the correct credentials.
10. Click the Configure DB button to save the SQL Server configuration. Note that configuring the settings of the SQL Server database may take a few minutes.
11. The product will start automatically after the configuration is complete.