Procedure to migrate from MySQL to MSSQL

Here is the procedure to migrate your SD+ database from MySQL to MSSQL.

a) Stop ManageEngine ServiceDesk Plus service

b) Migrate to 6.0. Follow the instructions @ http://forums.manageengine.com/forumHome.do?forumGroupId=49000000002007&forumTopicId=49000003329137 to help you migrate to 6.0

c) Take a backup of the existing data and configuration under MySQL database using [ServiceDesk-Home]\bin\backupdata.bat

d) Invoke ChangeDBServer.bat under [ServiceDesk-Home]\bin folder

e) Follow the onscreen instructions to change the database from MySQL to MSSQL.

f) Start and stop the SD+ server once.

g) Now invoke RestoreData.bat under [ServiceDesk-Home]\bin folder. The data should now be restored under your MSSQL server instance. Follow the onscreen instructions to restore the latest backup data.

h) Start ManageEngine ServiceDesk Plus service.

Let me know if you have any issues.

Rgds
Karthik
ServiceDesk Plus Technical Support.