How do I convert the database from PGSQL to MSSQL?
1. Stop ManageEngine ServiceDeskPlus – MSP service.
2. Take a backup of the existing data and configuration under PGSQL database by following the below steps. Open CMD as an administrator and execute command to start the data backup.
\ManageEngine\ServiceDeskPlus-MSP\bin>backUpData.bat
This backup will be stored under \ManageEngine\ServiceDeskPlus-MSP\backup.
Converting the DB to MSSQL
If you already have a .data (zip) file , start from the below steps to change the DB type to MSSQL
3. Open database setup wizard using the below command, (You need to execute the batch files mentioned below from an Administrator command prompt)
\ManageEngine\ServiceDeskPlus-MSP\bin>Changedbserver.bat
4. Provide the details of the SQL server (i.e.) Host name, 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. Then click Save.
5. Start and stop the ServiceDeskPlus – MSP service once.
NOTE: A database called ServiceDesk would be created in the SQL server.
6. Now open the restore process wizard using below command,
\ManageEngine\ServiceDeskPlus-MSP\bin>restoreData.bat
Browse and apply the .data or ezip file
Dont close the command prompt till the process is completed or you see a message stating restore successful.
The data should now be restored under your MSSQL server instance. Follow the on screen instructions to restore the latest backup data performed in step 2.
7. Start ManageEngine ServiceDeskPlus – MSP service once the restore process is complete.
New to ADSelfService Plus?
Related Articles
How do I convert the database from MSSQL to PGSQL ?
Kindly plan to perform this process ONLY during Non Operational hours. You can do this process in the same server that you have SDP MSP installed. Step 1: Stop the application and Take a backup of the existing data in the application. Navigate to ...Error While connecting default Postgres Database
If you are getting the below error while connecting the postgresDB , please follow the steps below : Error : psql: FATAL: no pg_hba.conf entry for host “::1”, user “postgres”, database “servicedesk”,SSL off Please open pg_hba.conf under [ServiceDesk ...Unable to start the application due to Pgsql privilege issue
ISSUE: Application does not start via both services and command prompt. ERROR TRACE: Serverout: [16:26:36:443]|[05-10-2023]|[com.adventnet.db.adapter.postgres.PostgresDBAdapter]|[SEVERE]|[27]: Exception occurred while obtaining mode of the database| ...How to Connect to SDP MSP Database ?
1. In-Built POSTGRES (PGSQL) : Open a CMD prompt as an administrator and navigate to ManageEngine\ServiceDeskPlus-MSP\pgsql\bin and run the below command From SDP MSP version 10.6 , please use the below method. psql -h localhost -U sdpadmin -p 65432 ...Incoming and Outgoing conversations with Attachment name and location (MSSQL & PGSQL)
Tested in Build PGSQL (14300) or MSSQL (14306) PGSQL & MSSQL: Incoming: (Referred as 'Conversations' in the database) select conv.conversationid "Conversation ID", conv.workorderid "Request ID", wo.title "Request Subject", aaau.first_name "Sender", ...