Migrating OpManager setup with MSSQL DB from one server to another.

Migrating OpManager setup with MSSQL DB from one server to another.

Question : I have OpManager with MSSQL DB and both are installed in same server. I want to move both from one server to another.

Steps to be followed :

1. Take a SQL DB backup using SQL Management tool.

2. Download and install a fresh setup of OpManager in the new server with same build number as in the old setup.

3. During installation, select the DB as MSSQL and give the DB name as OpManagerDB.

4. Once the installation is completed, start the OpManager service and make sure if it works fine.

5. Stop the OpManager service.

6 Restore the MSSQL DB backup(taken from old server) in the new server using SQL Management tool(under the name OpManagerDB).

7. In the new server, navigate to OpManager home directory-->conf-->take a backup of customer-config.xml file.

8. Now go to the old server, navigate to OpManager home directory-->conf-->copy the customer-config.xml file and paste it(replace the old file) in OpManager home directory-->conf folder of the new server.

9. Start the OpManager service.


          • Related Articles

          • Migrating OpManager from one server to another

            Here are the steps to go about migrating OpManager to a new server: 1. Please click on Support->About on the OpManager webclient to make a note of the build number of the existing OpManager installation. 2. Take a backup of your existing database by ...
          • Moving OpManager from one server to another server without reinstalling OpManager

            Question : How do I move OpManager from one server to another without reinstalling OpManager. Solution:  It is easy to move OpManager from one Server to another just by copying  the complete OpManager folder and installing  the service. Steps: 1)Stop ...
          • OpManager DB migration from PGSQL to MSSQL on the same server in Version 12.3

            Please follow the below mentioned steps to migrate DB from PGSQL to MSSQL on the same server. These steps are applicable only on builds 12.3.045 and above. If you are in older versions below 12.3.045, please upgrade to 12.3.045 and follow these ...
          • OpManager DB migration from PGSQL to MSSQL in Version 125230

            For OpManager version 125230: PGSQL to MSSQL Migration Steps : In the PGSQL setup, go to OpManager home → bin, start Command Prompt with administrator privilege from this path and run DBConfiguration.bat. In the popup shown, please chose MSSQL, check ...
          • How to move OpManager from one drive to another ?

            Follow the steps below to move OpManager from one drive to another. 1. Stop OpManager Service. 2. Go to OpManager current location cmd > OpManager\bin : Execute command > OpManagerService.bat -r (make sure to close the services window before you run ...