Post database change steps for Managed 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:
Stop the Eventlog Analyzer Server/Service.
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>_MM_DD_YYYY_hh_mm.data'.
From the installed MS SQLSERVER, copy the files bcp.exe and bcp.rll to <Eventlog Analyzer Home>mysqlbin folder.
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.
Invoke the <Eventlog Analyzer Home>toolschangeDBServer.bat in command prompt, to configure the MS SQLSERVER credentials like ServerName, Port, UserName and Password.
Database Setup Wizard pops-up.
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.
Select the authentication type using the "Connect Using:" options.
The options are:
For SQL Server Authentication, enter the User Name and Password.
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.
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.
Invoke the <Eventlog Analyzer Home>binrun.bat to start the Eventlog Analyzer server in the command prompt.
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
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.
Start the Eventlog Analyzer Server/Service to work with the MS SQLSERVER as the database.