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 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 ...Migration of SCP from one server to another
1. Stop the application on the production server. 2. Take a trimmed backup of the application (backup without attachments) if you are using the default PgSQL database. If you are using MSSQL, you can take a SQL backup (.bak). 3. Download and install ...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 ...Database migration from MySQL to Postgres/MSSQL in SCP 8.1
We no longer support the use of MYSQL as database in SupportCenter Plus. Hence, we request our users to migrate to Postgres (which is in-built) or Microsoft SQL. Please follow the below steps to carry out the database migration: 1. Shutdown the ...