Migrating Endpoint Central MSP from MySQL to PgSQL database

How to migrate Endpoint Central MSP database from MySQL to PostgreSQL server?

Description

This document is applicable only to customers who are using Endpoint Central MSP build # 92000 or later versions. Endpoint Central MSP will stop supporting MySQL database, from 31st of May 2016. You can refer to this document to know more about the steps involved in migrating Endpoint Central MSP database from MySQL to PGSQL. You can ensure that there is no loss of data when you migrate the database.

Note : Refer to this document, to migrate your MySQL server to MSSQL server.

If you want to migrate your database to PostgreSQL, follow the steps mentioned below sequentially on the computer where Endpoint Central MSP server is installed:

  1. Stop Endpoint Central MSP Server 
  2. Move the data from MySQL to PostgreSQL Database
  3. Start the Endpoint Central MSP Server

Stop Endpoint Central MSP MSP Server

  1. Right click Endpoint Central MSP icon on the notification area of the task bar.
  2. Click Stop Service.

Ensure that Endpoint Central MSP server service is stopped, by running services.msc and verifying the status of ManageEngine Endpoint Central MSP Server.

Move the data from MySQL to PostgreSQL Database

Note: 

  • Ensure that you do not download PGSQL binaries during the migration process, since the binaries are already bundled with Endpoint Central MSP.
  • Ensure that port # 8028 is available for PostgreSQL to avail it.

Steps

  1. Go to command prompt and navigate to this location : <Desktop Central MSP installation location\bin folder>.
  2. Execute changeDBServer.bat. The migration tool, will be opened, click Save to initiate the migration process. 
     

You can see that all the data will be successfully migrated from your MySQL to PostgreSQL database.

Start the Endpoint Central MSP Server

  1. Right click Endpoint Central MSP icon on the notification area of the task bar.
  2. Click Start Service.

You have successfully migrated your data to PostgreSQL database. You can also ensure the same by verifying it here: Go to Support Tab on the Endpoint Central MSP web console and scroll down to "Database Information" under General Details, at the bottom of the page, which will now contain details of your PostgreSQL database.

Remote Desktop & Mobile Device Management Software for MSPs trusted by