Migrating Desktop Central MSP from MySQL to PgSQL database

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

Description

This document is applicable only to customers who are using Desktop Central MSP build # 92000 or later versions. Desktop 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 Desktop 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 Desktop Central MSP server is installed:

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

Stop Desktop Central MSP Server

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

Ensure that Desktop Central MSP server service is stopped, by running services.msc and verifying the status of ManageEngine Desktop 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 Desktop 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 Desktop Central MSP Server

  1. Right click Desktop Central 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 Desktop 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