Mysql to Pgsql/Mssql -- Plugin

Mysql to Pgsql/Mssql -- Plugin

Mysql to Pgsql/Mssql  Migration Plugin:

Stop Opmanager service and take a backup of the entire Opmanager folder before doing the data migration.

  • Install Opmanager 11500 pgsql with Netflow 10250 (for mssql, select mssql DB during installation).  from  http://archives.manageengine.com/opmanager/netflow-opmanager/10250/
  • start the OpManager & apply license.
  • Stop OpManager.
  • Copy the backup folder from OpManager(mysql) to the new installation under <Opmanager Home> directory.
  • Restore the database using RestoreDB.sh present under OpManager/bin/backup directory and restart the Opmanager.
                     ex:-   Navigate to  c:\<OpManager Home>\bin\backup
                             Execute RestoreDB.bat "c:\OpManager\backup\BackUp_APR_2015_17_43_38_8100.zip".

  • Start the service and Make sure that OpManager is working fine.
  • Stop OpManager service.
  • Download and Unzip MigrateData.Zip under OpManager\<NetFlow> directory.
  • Open a cmd prompt as administrator , Navigate to  OpManager\<NetFlow>\MigrateData and execute "migrate.bat.
                     1. Input existing Mysql installation Directory path and press enter .
                               ex:--   c:\ME\OpManager\NetFlow
                     2. Wait for Script Completion
  • Start the OpManager(pgsql).You can get the current migration status in Netflow Plugin UI as banner.




Reference :-- 
          OpManager Migration Link -- http://help.opmanager.com/migrating_database.
                New to ADManager Plus?

                  New to ADSelfService Plus?

                    • Related Articles

                    • Firewall Analyzer Mysql to Pgsql migration steps.

                      Stop the Firewall Analyzer Service. Take the backup or a VM snapshot of ManageEngine\Firewall folder. Download the correct zip files based on your OS(32/64bit) from the below link and extract it under <Firewall Analyzer Home>. ...
                    • Device Expert 5990 migration from Mysql to Pgsql

                      Please follow the steps to migrate DeviceExpert data from mysql to postgres. Note: .bat is for Windows and .sh is for linux installation. DeviceExpert Backup steps : Please stop DeviceExpert. IMPORTANT: Take a copy of the entire <DeviceExpert> ...
                    • Migration of Database from MYSQL to MSSQL in the Firewall Analyzer

                      Please refer the below link for MYSQL to MSSQL migration. http://www.manageengine.co.in/products/firewall/help/appendix/migrating-data-mysql-mssql-database.html Note: I request to stop the Firewall Analyzer service and take the backup of complete ...
                    • Unable to start NetFlow plugin after install

                      If NetFlow Plug-in is not started after fresh install, we require the below information to narrow down to find the sollution. Name of the exe file that the NetFlow plug-in was installed. (32 bit or 64 bit) Version and build number of Opmanager: you ...
                    • Database Migration from Mysql to Postgres in NetFlow Analyzer version 10250

                      Steps to Migrate NetFlow Standalone Mysql DB to pgsql Datase Note: Migration is applicable only in build 10250 Both the MYSQL and PGSQL installation should be in the same server to perform the Migration. Make sure that you have enough disk space ...