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 :
S
tart 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:
S
top 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:
S
tart 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.
New to ADSelfService Plus?
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 administrator 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 ...