Migrating to PgSQL Database from MySQL.


Please follow these steps to migrate the data from your existing Exchange Reporter Plus server which has MySQL database to a new installation which has PostgreSQL.

1. Follow these steps to migrate Exchange Reporter Plus from MySQL to PostgreSQL on the same machine.

  1. Stop Exchange Reporter Plus (Go to Start --> All Programs --> Exchange Reporter Plus --> Stop Exchange Reporter Plus).
    Note: In case you have installed Exchange Reporter Plus as an NT Service, stop the service (Go to Start --> Run --> type 'services.msc' and click OK . In the 'Services' window, locate the service named ManageEngine Exchange Reporter Plus and stop it.)

  2. Update your current Exchange Reporter Plus installation (which has MySQL database) to the latest version by applying the latest service pack.
    (You can download the service pack from here and apply it using the steps mentioned under 'Service Pack Installation Steps'.)

  3. Open the 'database_params.conf' file located in: Exchange Reporter Plus installation directory\conf

  4. In the 'url', change the 'port number' from 33309 to a different one, say 33319 or 33329.

  5. Open (in notepad) the setCommonEnv.bat' file located in: Exchange Reporter Plus installation directory\bin . Find the text DB_PORT, and change the port number to the one you had mentioned in Step 4.

  6. Go to the InstallShield Installation Information folder ( C:\Program Files (x86)\InstallShield Installation Information); add _bak as suffix to the folder {CCB34152-8A6B-4442-8713-48E2F437E548} (That is, {CCB34152-8A6B-4442-8713-48E2F437E548}_bak).

  7. Download and install the latest version of Exchange Reporter Plus. When the installation is complete, uncheck the Start Exchange Reporter Plus in console mode option and click on Finish.

  8. Open the command prompt as administrator, navigate to the new Exchange Reporter Plus installation directory\bin and start the DB alone by executing startDB.bat file.

  9. Now, in the old installation directory, open the command prompt as administrator; go to Exchange Reporter Plus\bin and execute changeDB.bat file.

    • For 'Server Type', select 'PostgreSQL Server'.

    • For 'Host Name', specify 'localhost'

    • For Port Number, specify 33309

    • Choose Yes to Migrate Data

    • For Database Name, specify erp and click Test Connection. If the test connection is successful, click Save

  10. Once the database migration is complete, execute stopDB.bat in the command prompt window opened in Step 8.

  11. Start the new installation. Check if all the configurations and data from the old Exchange Reporter Plus have successfully migrated to the new one.

If you need any further assistance or information, please write to our support team (support@exchangereporterplus.com) or call us (+1-408-916-9892); we will be glad to help you out.

 

2.Follow these steps to migrate Exchange Reporter Plus from MySQL to PostgreSQL on a different machine

  1. Stop Exchange Reporter Plus (Go to Start --> All Programs --> Exchange Reporter Plus --> Stop Exchange Reporter Plus).
    Note: In case you have installed Exchange Reporter Plus as an NT Service, stop the service (Go to Start --> Run --> type 'services.msc' and click OK . In the 'Services' window, locate the service named ManageEngine Exchange Reporter Plus and stop it.)

  2. Update your current Exchange Reporter Plus installation (which has MySQL database) to the latest version by applying the latest service pack.
    (You can download the service pack from here and apply it using the steps mentioned under 'Service Pack Installation Steps'.)

  3. Download and install the latest version of Exchange Reporter Plus. When the installation is complete, uncheck the Start Exchange Reporter Plus in console mode option and click on Finish.

  4. In the new Exchange Reporter Plus server,

    • Enable remote connection in PostgreSQL database server by making the following changes in the pg_hba.conf and postgresql.conf files located in: New Exchange Reporter Plus installation directory\pgsql\data. We recommend that you backup these files before modifying them.

      • In 'pg_hba.conf' file, under the heading 'IPv4 local connections', replace the ip address '127.0.0.1/32' with 'all' and save the file.

      • In 'postgresql.conf' file, find this text: #listen_addresses = 'localhost'. Replace it with this: listen_addresses = '*' and save the file.

  5. Open the command prompt as administrator, navigate to the New Exchange Reporter Plus installation directory\bin, start the DB alone by executing startDB.bat file.

  6. Now, in the Old Exchange Reporter Plus server, open the command prompt as administrator, go to Exchange Reporter Plus installation directory/bin and execute changeDB.bat file.

    • For 'Server Type', select 'PostgreSQL Server'.

    • For Host Name, specify the new Exchange Reporter Plus host name (Eg: consto-dc1).

    • For Port Number, specify 33309.

    • Choose Yes to Migrate Data.

    • For 'Database Name, specify erp and click Test Connection. If the test connection is successful, click Save.

  7. Once the database migration is complete on the new server, execute stopDB.bat in the command prompt window opened Step 5.

  8. Revert the changes that you made in files pg_hba.conf' and postgresql.conf located in: New Exchange Reporter Plus installation directory\pgsql\data.

  9. If archive path configured in the old Exchange Reporter Plus machine is not a shared location, copy the archived files from the old Exchange Reporter Plus machine to the same path in the new Exchange Reporter Plus machine.

  10. Start the new Exchange Reporter Plus server. Check if all the configurations and data from the old Exchange Reporter Plus server have migrated to the new one successfully.

If you need any further assistance or information, please write to our support team (support@exchangereporterplus.com) or call us (+1-408-916-9892); we will be glad to help you out.

Copyright © 2019, ZOHO Corp. All Rights Reserved.
ManageEngine
Get download link