How do I convert the database from PGSQL to MSSQL?
1. Stop ManageEngine Supportcenter Plus 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.
\ManageEngine\SupportcenterPlus\bin>backUpData.bat --trimmed
This backup will be stored under \ManageEngine\SupportcenterPlus\trimmed backup.
Converting the DB to MSSQL
If you already have a .data (zip) file , start from the below steps to change the DB type to MSSQL
3. Open database setup wizard using the below command, (You need to execute the batch files mentioned below from an Administrator command prompt)
\ManageEngine\SupportcenterPlus\bin>Changedbserver.bat
4.
Provide the details of the SQL server (i.e.) Host name, database name, username and
password and click Test, By doing this, we will be able to check the
connectivity with the SQL server. The message should say connection
established. Then click Save.
5. Start the application so that the tables get created on the new database. Connect to the UI once and ensure that everything is fine.
6. Now, stop the Supportcenter Plus service.
7. Open the restore process wizard using below command,
\ManageEngine\SupportcenterPlus\bin>restoreData.bat
Browse and apply the .data or ezip file
Dont close the command prompt till the process is completed or you see a message stating restore successful.
The
data should now be restored under your MSSQL server instance. Follow
the on screen instructions to restore the latest backup data performed
in step 2.
8. Start ManageEngine SupportcenterPlus service once the restore process is complete.
9. Connect to the application and ensure that the data is fine.
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 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 ...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 ...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", ...