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.


          • Related Articles

          • Device Expert migration from 5990 to 12200

            Backup the DeviceExpert data: Note: These steps are only application over the Device Expert build 5990 with Postgres database.   Also, take the backup of the complete DeviceExpert_Home directory after stopping the Device Expert service and proceed ...
          • 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 ...
          • Device Expert migration from 5990 to the NCM 123183

            Backup the DeviceExpert data: Note: These steps are only application over the Device Expert build 5990 with Postgres database.   Also, take the backup of the complete DeviceExpert_Home directory after stopping the Device Expert service and proceed ...
          • 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>. ...