Step 1: Stop ManageEngine ServiceDesk Plus service.
Step 2: Take a backup of the existing data present in MSSQL database using the backupData.bat batch file.
From the command prompt, go to [ServiceDesk Plus-Home]\bin directory and execute the backUpData.bat command to start the data backup.
cmd> backUpData.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.
cmd> ChangeDBServer.bat
Step 4: Provide the details of the PgSQL server (i.e.) Hostname, username, and password and click Save.
Hostname: localhost
Port: 65432
Database Name: servicedesk
Username: sdpaadmin
Password: sdp@123
You can ignore any errors you see (like the one below) and click OK in the pop-up.
After clicking on Ok, you should see the below pop-up for which you can click on OK again.
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.
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 > 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.