Migration between Postgres and Microsoft SQL
SupportCenter Plus comes bundled with Postgres. From build 14000, the database files generated from the scheduled backup are no longer cross-compatible. However, you can migrate between Postgres and Microsoft SQL using the method discussed below.
Shut down ManageEngine SupportCenter Plus service before you perform a backup of your data.
Click Start > Programs > ManageEngine SupportCenter Plus> Backup Data. [OR]
From command prompt, go to <SupportCenter Plus>\bin directory and execute the backUpDataOld.bat as shown below,
C:\ManageEngine\SupportCenter Plus\bin\backUpDataOld.bat
A backup of the data in the database and the file attachments that have been added in the application is created in <SupportCenter Plus>\backup directory. The backup file has to be a .data file.
A backup of the data in the database and the file attachments that have been added in the application is created in <SupportCenter Plus>\backup directory. The file name for the backup file will be in the pattern below.
backup_databasename_[build number]_fullbackup_month_date_year_hr_min.data
Example: backup_mssql_11000_fullbackup_01_18_2011_15_28.data
Step 2: Restore
Shut down ManageEngine SupportCenter Plus service before you restore the data.
From the command prompt, go to <SupportCenter Plus>\bin directory.
Execute the file restoreData.bat as shown below:
C:\ManageEngine\SupportCenter Plus\bin\restoreData.bat --dbmigration
The Restore Data dialog pops-up. Browse the backed up file and click OK.
Step 1: Taking a Backup
Follow the steps given below to take a backup of the ManageEngine SupportCenter Plus data:
Shut down ManageEngine SupportCenter Plus service before you perform a backup of your data.
Go to <SupportCenter Plus>/bin directory from the command prompt.
Execute the backUpData.sh file as given below:
$ sh backUpDataOld.sh
The backup file is created in the <SupportCenter Plus>/backup directory. The file name for the backup file will be of the pattern below.
backup_databasename_[build number]_fullbackup_month_date_year_hr_min.data
Example: backup_mssql_11000_fullbackup_01_18_2011_15_28.data
Step 2: Restore
Shut down ManageEngine SupportCenter Plus service before you restore the data.
Go to <SupportCenter Plus>/bin directory from the command prompt.
Execute the file restoreData.sh as shown below: