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?