Database migration from MySQL to Postgres/MSSQL in SCP 8.1

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 application and take a trimmed backup of your data from the existing installation. Kindly copy the following folders from the current SupportCenter installation directory and save it on a safe location:

custom
inlineimages
index
fileAttachment

2. Once the backup has been completed, please download and install the same exact version of SupportCenter Plus as your Backup.

3. During the installation, you may choose the respective DB choose Postrges/MSSQL according to your choice and configure the DB to continue with the installation.

4. Post installation, restore the data that you've backed up.

5. Start the server and check whether everything is working fine. Then move the following folders as mentioned in the 1st point, from the old installation directory to the new installation SupportCenter directory:

custom
inlineimages
index
fileAttachment

          • 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 ...
          • No DB bundled with the application error in the logs while starting from windows services

            When not able to start the application from the windows services and it runs in the CMD fine without any issues. After checking the logs you will find the error trace as "NO DB BUNDLED WITH THE APPLICATION". If the database is MSSQL please follow the ...
          • 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 ...
          • 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 ...
          • Database will not start when mysql database is used with SCP

            Check with the wrapper.conf and check the database type specified and change it from pgsql to mysql. i.e look for the line wrapper.java.additional.12=-Ddb.home=../pgsql and change it as wrapper.java.additional.12=-Ddb.home=../mysql.