How do I convert the database from PGSQL to MSSQL?

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 to Connect to SCP Database ? (from 11000 builds)

                        In-Built POSTGRES (PGSQL) : Open a CMD prompt as an administrator and navigate to ManageEngine\supportcenterplus\pgsql\bin and run the below command 1. If the database is PGSQL (Default database) psql -h localhost -U scpadmin -p 65432 -d ...
                      • How to Change default password on PGSQL database

                        Please do follow the below steps which would assist you in changing the default Postgres password.  1. Stop the application services.   2. Please take a trimmed backup <OR> take a Snapshot of  the Server 3. Open Command Prompt with Admin Privileges ...
                      • 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 ...
                      • No Managed Connections. Steps to enable Read Committed Snapshot Isolation- MSSQL

                        Enabling Read Committed Snapshot Isolation in MS SQL server In MS SQL environments enabling 'Read committed Snapshot isolation (RCSI)' is the first step in handling application server performance and crash issues. What is RCSI?   Since databases ...
                      • How to connect to Database in Version 11.0? PGSQL

                        1.Open a cmd with admin privileges 2.navigate to ManageEngine\SupportCenterPlus\pgsql\bin and enter the below command: psql.exe -U scpadmin -p 65432 -h 127.0.0.1 supportcenter For example: SupportCenterPlus\pgsql\bin>psql.exe -U scpadmin -p 65432 -h ...