Database Migration

Database Migration

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.


For Windows

Step 1: Taking backup
 
  1. Shut down ManageEngine SupportCenter Plus service before you perform a backup of your data.

  2. 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

  1. 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

  1. Shut down ManageEngine SupportCenter Plus service before you restore the data.

  2. From the command prompt, go to <SupportCenter Plus>\bin directory.  

  3. Execute the file restoreData.bat as shown below:

C:\ManageEngine\SupportCenter Plus\bin\restoreData.bat --dbmigration

  1. The Restore Data dialog pops-up. Browse the backed up file and click OK.

 

For Linux

Step 1:  Taking a Backup

Follow the steps given below to take a backup of the ManageEngine SupportCenter Plus data:

  1. Shut down ManageEngine SupportCenter Plus service before you perform a backup of your data.

  2. Go to <SupportCenter Plus>/bin directory from the command prompt.

  3. 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
 

  1. Shut down ManageEngine SupportCenter Plus service before you restore the data.

  2. Go to <SupportCenter Plus>/bin directory from the command prompt.

  3. Execute the file restoreData.sh as shown below:

$ sh restoreData.sh --dbmigration

    • Related Articles

    • Database Migration Tool

      You can use this tool to migrate data between two databases (Postgres to MSSQL and vice versa) as well as between operating systems (Linux to Windows and vice versa). You can perform the following data migration with this tool: Server migration ...
    • Contract Migration Disclaimer

      Rate Type: Rate Type configuration is implemented through Bill Rules and Request & Time Entry additional fields for cost handling Request and Time Entry picklist additional fields will be created with the name "Rate type" with the previously present ...
    • Configuring Database

      In GUI Setups Configuring Database Server SupportCenter Plus is bundled with PostgreSQL database. You can also configure the application to set up MS SQL database. PostgreSQL 1. Go to <SupportCenter_Plus_Home>\bin directory in the command prompt and ...
    • Database Error Codes and Troubleshooting

      The following table provides common database errors and corresponding troubleshooting tips. Error ID   Error Root cause and troubleshooting steps 1000 ERROR_WHILE_GETTING_CONNECTION Root cause: Connection could not be established with the MSSQL ...
    • Backup Process

      Beginning with build 14000, SupportCenter Plus supports native backup and restore for databases. The backup files of builds 14000 or later do not support cross-compatibility between PostgreSQL(bundled with SupportCenter Plus) and Microsoft SQL ...