TRY SERVICEDESK PLUS MSP FREE FOR 30 DAYS
DOWNLOAD NOW
REQUEST DEMO|GET QUOTE|LIVE DEMO|VISIT WEBSITE
Masterclass 2022 Switch to User Guide >

    Migration between Postgres and Microsoft SQL 

    ServiceDesk Plus MSP comes bundled with Postgres. From build 10600, 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 Endpoint Central is downloaded and installed within ServiceDesk Plus MSP for inventory, remote control, and tools functionality in a Windows server, the backup and restore for Endpoint Central has to be performed separately. Please refer to this doc for the steps to be followed.

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

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

      From command prompt, go to <ServiceDeskPlus-MSP>\bin directory and execute the backUpDataOld.bat as shown below,

    C:\ManageEngine\ServiceDeskPlus-MSP\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 <ServiceDeskPlus-MSP>\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 <ServiceDeskPlus-MSP>\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_10500_fullbackup_01_18_2011_15_28.data

    Step 2:  Restore
     

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

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

    2. From the command prompt, go to <ServiceDeskPlus-MSP>\bin directory.  

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

    C:\ManageEngine\ServiceDeskPlus-MSP\bin\restoreData.bat --dbmigration

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

     

    For Linux

    Step 1:  Taking Backup
     

    If Endpoint Central is downloaded and installed within ServiceDesk Plus MSP for inventory, remote control, and tools functionality in a Windows server, the backup and restore for Endpoint Central 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 MSP data:

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

    2. Go to <ServiceDeskPlus-MSP>/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 <ServiceDeskPlus-MSP>/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_10500_fullbackup_01_18_2011_15_28.data


    Step 2: Restore
     

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

     

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

    2. Go to <ServiceDeskPlus-MSP>/bin directory from the command prompt.

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

    $ sh restoreData.sh --dbmigration


    Zoho Corp. All rights reserved.