Step 1: Stop ManageEngine ServiceDesk Plus service.
Step 2: Take a backup of the existing data present in PgSQL database using the backupDataOld.bat batch file.
From the command prompt, go to [ServiceDesk Plus-Home]\bin directory and execute the backUpDataOld.bat command to start the data backup.
cmd> backUpDataOld.bat --trimmed
where, ServiceDesk Plus Home --> Drive:\ManageEngine\ServiceDesk. This backup will be stored under the trimmedbackup folder in ServiceDesk Plus Home directory.
Step 3: Invoke ChangeDBServer.bat under [Service Desk-Home]\bin folder.
Step 4: Provide the details of the SQL server (i.e.) Hostname, username, and password and click Test, By doing this, we will be able to check the connectivity with the SQL server.
The message should say connection established as displayed above. Then click Save.
Step 5: Once your are back in the command prompt, type in run and hit enter.
This will load all the modules and will start the application. Once all the modules are loaded, you should see a message "Server started" in the command prompt.
After you see this message, open up a browser and try to access the localhost url that is displayed in the command prompt. If you see the login page, try to login with the default administrator credentials by clicking on the credential listed below.
NOTE: A database called ServiceDesk would be created in the SQL server.
Step 6: If login action is successful, close the browser and come back to the command prompt and hit CTRL+C which would terminate the batch job that's running. You should see the modules being stopped and destroyed. At the end, when you are prompted for a confirmation for terminating the process, press 'Y' and hit enter.
Step 7: Now invoke restoreData.bat under [Service Desk-Home]\bin folder as indicated below. This would bring up a GUI to choose the backup file. During this point, you will need to choose the trimmed backup that you had taken in Step 2.
cmd> restoreData.bat --dbmigration > 1.txt
You need to choose only the part1.data file while initiating a restore. The system would automatically pick up the other parts in the backup (if exists). You need not manually select part2.data or perform any other action.