Migrate EventLog Analyzer Data from PGSQL to MSSQL Database


Note: Applicable to EventLog Analyzer Build 8050/8051 and the versions above.

 

EventLog Analyzer allows the user to migrate the existing EventLog Analyzer data available in PGSQL database to MSSQL database.

This procedure is applicable only if you are already using the EventLog Analyzer with PGSQL 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 to the Configuring MSSQL 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. Run the command prompt as an administrator. Go to <EventLog Analyzer Home>toolsbackUpDatabase.bat to backup the data available in PGSQL database and wait for backup completion. By default, backup file will be stored under <EventLog Analyzer Home>backup directory with the file name 'backup_eventlog_<Build_Number>_MM_DD_YYYY_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 file from SQL Server (Version 2005 & above) installed in one 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)
http://download.microsoft.com/download/4/4/d/44dbde61-b385-4fc2-a67d-48053b8f9fad/sqlncli.msi

MSSQL 2005 (64 bit)
http://download.microsoft.com/download/4/4/d/44dbde61-b385-4fc2-a67d-48053b8f9fad/sqlncli_x64.msi

MSSQL 2008 (32 bit)
http://go.microsoft.com/fwlink/?LinkId=123717&clcid=0x409

MSSQL 2008 (64 bit)
http://go.microsoft.com/fwlink/?LinkId=123718&clcid=0x409

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

MSSQL 2016

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

  1. Invoke the <Eventlog Analyzer Home>toolschangeDBServer.bat in command prompt to configure the MS SQLSERVER credentials like ServerName, Port, User Name 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 Device Name and Port of the SQL Server from the instances.

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

  5. The options are:

‚Äč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.

For Windows Authentication, enter the Domain NameUser Name and Password

 

Win authentication

 

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

 

SQL 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 a 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

 

Note: Executing the restoreDatabase.bat will delete the existing data, if any.
  1. Start the Eventlog Analyzer Server/Service to work with the MS SQL Server 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 is given below.
<Eventlog Analyzer Home>tools:>backUpDatabase.bat D:Mysql

Get download link