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:
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:
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
fileAttachmentNew to ADSelfService Plus?
Related Articles
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 ...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 ...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 ...solution for postgres 11 upgrade issues
When Supportcenter Plus is upgraded to 14300 or later, postgres is also upgraded to 11.17. If you are using bundled postgres, data migration through pgdump and restore mechanism also happens. To ensure efficiency in Postgres 11.17, make sure your ...SCP upgrade from 11.0 to 14.0 prerequisites
Before migration to scp version 14 below 2 points has to be done in scp 11027 1. Back up password should not be default i.e SCP123!, it should be updated 2. TLSv1, TLSv1.1 has to be added under the file /home/jre/lib/security/java.security file ( ...