Device Expert 5990 migration from Mysql to Pgsql

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> installation directory and save it somewhere.

Postgres Installation :

MySQL installation :

  • Stop the Device Expert service.

  • Open DeviceExpert mysql installation folder and navigate to DeviceExpert_Home/bin directory.

  • Open MigrateFromMySqlToPGSQL.bat/.sh file using wordpad and edit the entry -Xms128m -Xmx2448m to  -Xmx512m to -Xmx1024m

  • Open a command prompt with administrator privilege and navigate to DeviceExpert\bin directory.

  • Execute MigrateFromMySqlToPGSQL.bat/.sh

hostname  - localhost

Provide pgsql Port number:-13306

username -postgres

Password - postgres

database name - deviceexpert 

  • Try to Migrate and let us know how it goes.

  • Once done navigate to DeviceExpert_Home/bin and execute deviceexpert.bat/.sh remove

Once Migration completed Please navigate to the new Postgres installation follow the below steps to start the service:

1. Open command prompt as Administrator and navigate to DeviceExpert_Home/bin and execute stopDB.bat/.sh 13306 to stop the postgres database running and also make sure that there is no Postgres process running in Task Manager.

2.  Once done execute deviceexpert.bat/.sh install from DeviceExpert_Home/bin.

3. Start the ManageEngine Device Expert service from services.msc and check if all the information is migrated.

                    New to ADSelfService Plus?

                      • Related Articles

                      • 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 ...
                      • Device Expert_old

                        Note: These steps are only application over the Device Expert build 5990 with Postgres database. Also take the backup of complete DeviceExpert_Home directory after stopping the Device Expert service and proceed with the below steps. Stop the Device ...
                      • 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>. ...
                      • 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 ...
                      • Netflow Analyzer migration (Links based on installation type)

                        Kindly refer the links below to migrate your Netflow Analyzer installation per your need -   (For builds up to 9700) ...