Migrating OpManager Database

 These steps are valid upto build 11600.

Migrating from MySQL to PGSQL 

  1. Stop OpManager.
  2. Take a backup: cmd > OpManager\bin\backup
  3. Execute BackupDB.bat -targetdb pgsql (proceed to next step after the backup is completed).    
  4. Since PGSQL was not bundled with earlier versions, take a complete OpManager backup and save it on different location as folder backup.
  5. Uninstall OpManager completely and delete OpManager folder.
  6. Install same build of OpManager with PGSQL database option and make sure OpManager works fine. (link to download older builds of OpManager:  http://archives.manageengine.com/opmanager/)
  7. Stop OpManager service and copy the backup folder located under OpManager from the backup folder to the newly installed folder under the same location.
  8. Restore the database using RestoreDB.bat present under OpManager/bin/backup directory and restart OpManager.

       For ex : C:\<OpManager Home>\bin\backup>RestoreDB.bat "c:\OpManager\backup\BackUp_APR3_2009_17_43_38_8100.zip"

       Note : For linux - please use BackupDB.sh 

 

 Migrating from MySQL to MSSQL (Same steps for PGSQL to MSSQL)

  1. Take a backup: cmd > OpManager\bin\backup
  2. Execute BackupDB.bat -targetdb mssql (proceed to next step after the backup is completed)     
  3. Select Start > Programs > ManageEngine OpManager > DB Manager > DB Configuration
  4. A DB Configuration window pops up. Select MSSQL and click on Save.

Configure the following information:

  1. DB Host : The name or the IP address of the machine where MSSQL is installed.
  2. Port: The port number in which OpManager must connect with the database. Default is 1433.
  3. User Name and Password: The user name and password with which OpManager needs to connect to the database.
  4. Driver Jars: Specify the path of the Database driver
  5. Click OK.

 4.  Restore the data using RestoreDB.bat present under OpManager/bin/backup directory and restart OpManager.

      For ex : C:\<OpManager Home>\bin\backup>RestoreDB.bat "c:\OpManager\backup\BackUp_APR3_2009_17_43_38_8100.zip"

 

Migrating from MSSQL to PGSQL

  1. Take a backup, cmd > OpManager\bin\backup : BackupDB.bat -targetdb pgsql (proceed to next step after the backup is completed)     
  2. Select Start → Programs → ManageEngine OpManager → DB Manager → DB Configuration.
  3. A DB Configuration window pops up. Select PGSQL and click on Save.
  4. Restore the data using RestoreDB.bat present in OpManager/bin/backup directory and restart OpManager. For ex: (C:\<OpManager Home>\bin\backup>RestoreDB.bat "c:\OpManager\backup\BackUp_APR3_2009_17_43_38_8100.zip")

 

Note: Find the files bcp.exe and bcp.rll in MSSQL server and ensure to copy them under opmanager/bin folder. If the MSSQL server is installed on a 64-bit OS, and OpManager is installed on 32-bit server, the bcp.exe and bcp.rll copied from the MSSQL server will not work on the OpManager machine. You'll need a 32-bit bcp.exe and bcp.rll.