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 M365 Manager Plus?
        New to M365 Manager Plus?
          New to RecoveryManager Plus?
          New to RecoveryManager Plus?
            New to Exchange Reporter Plus?
            New to Exchange Reporter Plus?
              New to SharePoint Manager Plus?
              New to SharePoint Manager Plus?
                  See all integrations
                  New to ADManager Plus?
                  See all integrations
                  New to ADManager Plus?

                    New to ADSelfService Plus?

                    Start your free trial
                    Start your free trial

                      • Related Articles

                      • 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 - https://support.zoho.com/portal/manageengine/helpcenter/articles/mysql-32-bit-installation-to-64-bit-migration   (For builds up to 9700) ...

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

                        Related Products