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