Migrating OpManager Nexus Database

Migrating from MySQL to PGSQL

1. Stop OpManager Nexus
2. Take a backup, cmd > OpManagerPlus\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 Nexus backup and save it on different location as folder backup
5. Uninstall OpManager Nexus completely and delete OpManager Nexus folder 
6. Install same build of OpManager Nexus with Pgsql database option and make sure OpManager Nexus works fine 
7. Stop OpManager Nexus service and copy the backup folder located under OpManager Nexus from the backup folder to the new installed folder under the same location
8. Restore the database  using RestoreDB.bat present under OpManagerPlus/bin/backup directory and restart OpManager Nexus.

       For ex : C:\<OpManagerPlus Home>\bin\backup>RestoreDB.bat "c:\OpManagerPlus\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 > OpManagerPlus\bin\backup
2. Execute BackupDB.bat -targetdb mssql (proceed to next step after the backup is completed)     
3. Select Start > Programs > ManageEngine OpManagerPlus > DB Manager > DB Configuration
4. A DB Configuration window pops up > Select MSSQL

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 Nexus must connect with the database. Default is 1433.
3. User Name and Password: The user name and password with which OpManager Nexus 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 OpManagerPlus/bin/backup directory and restart OpManager Nexus.

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

Important Note : If your migrating the database from PostgreSQL or MySQL to MSSQL, please follwo the steps below.

1. Download the SQL Native Client from the link below. You will need to scroll down the page for the Native Client downloads:

   http://www.microsoft.com/download/en/details.aspx?id=16978 Microsoft SQL Server 2008 R2 Native Client (SQL Server Native Client) is a single dynamic-link library (DLL) containing both the SQL OLE DB provider and SQL ODBC driver. It contains run-time support for applications using native-code APIs (ODBC, OLE DB and ADO) to connect to Microsoft SQL Server 2000, 2005, or 2008. SQL Server Native Client should be used to create new applications or enhance existing applications that need to take advantage of new SQL Server 2008 R2 features. This redistributable installer for SQL Server Native Client installs the client components needed during run time to take advantage of new SQL Server 2008 R2 features, and optionally installs the header files needed to develop an application that uses the SQL Server Native Client API.                                  

   X86 Package (sqlncli.msi) X64 Package (sqlncli.msi) IA64 Package (sqlncli.msi)

   For more details on installing the native client, refer this site: http://msdn.microsoft.com/en-us/library/ms131321.aspx

   Courtesy: http://msdn.microsoft.com                                                                                                                                                                                                     Here is a quick video of SQL Native client installation.

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

Migrating from MSSQL to PGSQL

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