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

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

                    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 change the database from MySQL/PostgreSQL to MSSQL

                        The steps mentioned below are applicable only if you migrate the DB from PgSQL to MSSQL. This means that the application server is going to remain the same. The data alone is going to be transferred to MSSQL DB from the existing PgSQL DB.    For ...
                      • 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 ...
                      • 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: ...
                      • Migration failure for Postgres Database with a blank space in it

                        Trace : \ManageEngine\ServiceDesk\Patch\AdventNet_ManageEngine_ServiceDesk_Plus-14.2.0-SP-1.0.0\SERVICEDESK\PreInstall\pg_migrate\pgsql_old\bin\pg_dumpall.exe", -U, postgres, -p, 65433, -h, 127.0.0.1, -r, -w, |, ...