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:
Ensure that Desktop Central MSP server service is stopped, by running services.msc and verifying the status of ManageEngine Desktop Central MSP Server.
You can see that all the data will be successfully migrated from your MySQL to PostgreSQL database.
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.