Migrating between Postgres and Microsoft SQL

ServiceDesk Plus comes bundled with Postgres. From build 11304, 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
 

If Desktop Central (DC) is downloaded and installed within ServiceDesk Plus(SDP) for inventory, remote control, and tools functionality in a Windows server, the backup and restore for DC has to be performed separately. Please refer to this doc for the steps to be followed. 

  1. Shut down ManageEngine ServiceDesk Plus service before you perform a backup of your data. To shut down the application, open the command prompt with admin privileges and execute the command shutdown.bat. Alternatively, you can stop the application by navigating to services.msc

  2. Click Start -> Programs -> ManageEngine ServiceDesk Plus -> Backup Data. [OR]

    From command prompt, go to <ServiceDesk>bin directory and execute the backUpDataOld.bat as shown below,

C:ManageEngineServiceDeskbinbackUpDataOld.bat

  1. A backup of the data in the database and the file attachments that have been added in the application is created in <ServiceDesk>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 <ServiceDesk>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_8000_fullbackup_01_18_2011_15_28.data

Step 2:  Restore 
 

 If Desktop Central (DC) is downloaded and installed within ServiceDesk Plus(SDP) for inventory, remote control, and tools functionality in a Windows server, the backup and restore for DC has to be performed separately. Please refer to this doc for the steps to be followed.

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

  2. From the command prompt, go to <ServiceDesk>bin directory.  

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

C:ManageEngineServiceDeskbinrestoreData.bat --dbmigration

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

 

For Linux

Step 1:  Taking a Backup
 

If Desktop Central (DC) is downloaded and installed within ServiceDesk Plus(SDP) for inventory, remote control, and tools functionality in a Windows server, the backup and restore for DC has to be performed separately. Please refer to this doc for the steps to be followed. 

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

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

  2. Go to <ServiceDesk>/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 <ServiceDesk>/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_8000_fullbackup_01_18_2011_15_28.data


Step 2: Restore
 

If Desktop Central (DC) is downloaded and installed within ServiceDesk Plus(SDP) for inventory, remote control, and tools functionality in a Windows server, the backup and restore for DC has to be performed separately. Please refer to this doc for the steps to be followed.

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

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

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

$ sh restoreData.sh --dbmigration