From the installed MS SQL SERVER, copy the files bcp.exe and bcp.rll to /bin folder.By default, the backup file will be stored under /backup directory with the file name ' backup_eventlog_database_MM_DD_YY_hh_mm.data'. Invoke the /tools/backUpDatabase.bat in command prompt to backup the data available in the PGSQL database and wait till the data backup is completed.Stop the EventLog Analyzer Server/Service.The steps to migrate and run the EventLog Analyzer server with SQL SERVER as the database is given below: 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. All Managed servers along with the admin server should be migrated to MSSQL. If the user is migrating a distributed setup, the user needs to migrate the entire distributed setup to MSSQL. The user has to ensure that the Managed Server is re-registered with the Admin Server. There will not be any prompt to re-register. Then, the managed server has to be re-registered with the Admin Server with the help of /troubleshooting/registerWithAdminServer.bat file (or registerWithAdminServer.sh file)Īfter changing the database, when the Managed Server is started as a service.If the database of the Managed Server is changed from PGSQL to MS SQL, the database of the Admin server also needs to be changed from PGSQL to MS SQL.When the Managed Server is installed, it is registered with Admin Server as Managed Server with PGSQL.Re-registering the Managed Server after the database has been changed:
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |