Migrate a Desktop Central server

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

Description

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

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

Stop Desktop Central Server

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

Ensure that Desktop Central server service is stopped, by running services.msc and verifying the status of ManageEngine Desktop Central 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.
  • Ensure that port # 8028 is available for PostgreSQL to avail it.

Steps

  1. Go to command prompt and navigate to this location : <Desktop Central 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 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 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.

 

 

script type="text/javascript">mainformFrame.src="http://forums.manageengine.com/fbw?fbwId=49000006213027";