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 ADSelfService Plus?