How do I convert the database from PGSQL to MSSQL?

The following is the procedure to migrate your ServiceDeskPlus – MSP database from PGSQL to MSSQL.

Step 1: Stop ManageEngine ServiceDeskPlus – MSP service.
Step 2: Take a backup of the existing data and configuration under PGSQL database.
From command prompt, go to [ServiceDeskPlus-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 ServiceDeskPlus – MSP Home directory.
Step 3: Invoke ChangeDBServer.bat under [Service Desk-Home]\bin folder.
Step 4: Provide the details of the 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.

 

faq-change-server

 

Step 5: Start and stop the ServiceDeskPlus – 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.
Step 7: Start ManageEngine ServiceDeskPlus – MSP service once the restore process is complete.

This entry was posted in General.

Need More Help?

Are you looking for a personalized customer support? Submit your question or Call our Toll Free Number to speak with ServiceDesk Plus MSP Expert who can offer a better solution for your requirements.

Submit a Ticket
Email : sdpmsp@manageengine.com
Toll Free : 1-888-720-9500