Move database from one machine to another

Move database from one machine to another

Following is the procedure to migrate your ServiceDesk Plus – MSP database from one MSSQL to another.


Step 1: Stop ManageEngine ServiceDesk Plus – MSP service.

Step 2: Take a backup of the existing data and configuration under MSSQL database.

From command prompt, go to [ServiceDesk Plus-Home]\bin directory and execute backUpData.bat command to start the data backup.

cmd> [ServiceDesk Plus Home]\bin

cmd> backUpData.bat

where, ServiceDesk Plus – MSP Home -> C:\ManageEngine\ServiceDeskPlus-MSP. This backup will be stored under the Backup folder in ServiceDesk Plus – MSP Home directory.

Step 3: Invoke ChangeDBServer.bat under [Service Desk-Home]\bin folder. [  Screenshot ]

Step 4: Provide the details of the new SQL server (i.e.) Host name, username and password and click Test, By doing this, we will be able to check the connectivity with the SQL server.
The message should say connection established as displayed above. Then click Save.

Step 5: Start and stop the ServiceDesk Plus – MSP server once.

NOTE: A database called ServiceDesk would be created in the SQL server.

Step 6: Now invoke restoreData.bat under [Service Desk-Home]\bin folder. The data should now be restored under your MSSQL server instance. Follow the on screen instructions to restore the latest backup data performed in step 2. [  Screenshot ]

Step 7: Start ManageEngine ServiceDesk Plus – MSP service once the restore process is complete.
 
Factors to consider:

1. Please make sure that the connectivity does not get lost during the process.

2. Also, take a back up of the application.
          • Related Articles

          • How to move the application to another server when you have a MSSQL Database ?

            1. Since you have MSSQL database, take a .BAK backup from the existing SQL server and restore the data on to the new SQL server in the SQL Studio.  Follow the regular steps of restoring Microsoft database. 2. On your new server,  Install  the 64 bit ...
          • How do I move ServiceDeskPlus – MSP from one server to another server?

            Following are the steps to move data from the existing server to a new server.  Before you start, click stop fetching under Admin->Mail Server Settings->Incoming in your existing instance. So that the mails in the servicedesk mailbox will be fetched ...
          • How to move the application folder from one drive to another?

            Use case When changing the location of the application folders you might want to reconfigure the services.msc to start the desired instance.  For Example from C Drive to D Drive.  Steps 1. Stop the application: -> Stop the application services from ...
          • How to Connect to SDP MSP Database ?

            1. In-Built POSTGRES (PGSQL) : Open a CMD prompt as an administrator and navigate to ManageEngine\ServiceDeskPlus-MSP\pgsql\bin and run the below command                                     From SDP MSP version 10.6 , please use the below method.     ...
          • 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 admin and execute  command to start the data backup. ...