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. ...Query to show Average response time for Category (MSSQL & PGSQL)
Tested in build PGSQL (14300) and MSSQL (14306) 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 ...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", ...Syntax for SDP MSP migration to Linux
While migrating to different database you can use backupdataold.bat. Here backup will be in .data format and this can be restored in across DB platform. Note: Backup from taken from a particular build can be restored only on the same build. Example: ...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 ...