How do I convert the database from MSSQL to PGSQL ?

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 the below path in CMD as an administrator.

ManageEngine\ServiceDeskPlus-MSP\bin>BackUpData.bat

This backup will be stored under the default Backup folder in \ManageEngine\ServiceDeskPlus-MSP\ directory or in the path where if you have specified.

Step 2: Now copy this Full backup to the Desktop or somewhere handy.

Step 3: Navigate to the below path in CMD to change the database type to PGSQL and save.

ManageEngine\ServiceDeskPlus-MSP\bin>ChangeDBServer.bat

Step 4 : Start the application service once for the new tables to get created in the database. Login and check Help->About to see if DB shows PGSQL.

Step 5: Stop the application service.

Step 6: Navigate to the below path in CMD to restore the database.

\ManageEngine\ServiceDeskPlus-MSP\bin>RestoreData.bat 

browse and select the latest backup taken.

Once the restore is complete you will get a pop up saying "Restore completed successfully", click Ok.

Step 7: Start the application service and check your data.

Step 8: License file can be obtained from the old server under \ManageEngine\ServiceDeskPlus-MSP\lib and the file name would be AdventNetLicense.xml. License can be applied through Help->License at the right top corner of the application.

For other clarifications, kindly drop an email to support@servicedeskplusmsp.com.

          • Related Articles

          • 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 admin and execute  command to start the data backup. ...

          • How to move the application to another server when you have a MSSQL Database ?

            1. Since you have MSSQL database, take a .BAK backup from the existing SQL server and restore the data on to the new SQL server in the SQL Studio.  Follow the regular steps of restoring Microsoft database. 2. On your new server,  Install  the 64 bit ...

          • 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.     ...

          • Query to show Average response time for Category

            PGSQL: SELECT accountdefinition.org_name "Account",cd.categoryname "Category", TO_CHAR(((avg(wo.respondedtime)-avg(wo.createdtime))/1000 || ' second')::interval, 'HH24:MI:SS') "Avg Response Time" FROM workorder wo LEFT JOIN workorderstates wos ON ...

          • Move database from one machine to another

            Following is the procedure to migrate your ServiceDesk Plus – MSP database from one MSSQL to another. Step 1: Stop ManageEngine ServiceDesk Plus – MSP service. Step 2: Take a backup of the existing data and configuration under MSSQL database. From ...