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
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 failure for Postgres Database with a blank space in it
Trace : \ManageEngine\ServiceDesk\Patch\AdventNet_ManageEngine_ServiceDesk_Plus-14.2.0-SP-1.0.0\SERVICEDESK\PreInstall\pg_migrate\pgsql_old\bin\pg_dumpall.exe", -U, postgres, -p, 65433, -h, 127.0.0.1, -r, -w, |, ...How to connect to external postgres(external DB)
1. From the postgres installed path navigate to bin folder and open a command prompt 2. Execute the command --> pg_ctl -D "C:\Program Files\PostgreSQL\10\data" start (Postgres server gets started) 3. Connect to DB using the command-->psql -U postgres ...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 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. ...