Hello servicedesk,
Please provide me with the correct upgrade path to do the following:
Currently we have Servicedesk application and database (not sure if its MySQL or Postgress) installed on a Win 2003 machine.
We want to migrate the data to a existing Windows 2008R2 server and SQL 2008R2 Server.
We want to host the application on a existing Windows 2008R2 Server.
I have tried migrating with the help of this topic but it does not work.
We have installed the application on the new server
We have restored the data on the SQL server.
After this the server will start but I can not connect to it.
What is wrong? Please tell me what you need to resolve this issue.
Jeroen van Lieshout
B.tw. I also followed the procedure below but the results are the same. The difference is that we are migrating to a new application server and a new database server and a new database model.
How do I convert the database from MYSQL to MSSQL?
The following is the procedure to migrate your ServiceDesk Plus database from MYSQL to MSSQL.Step 1: Stop ManageEngine ServiceDesk Plus service.Step 2: Take a backup of the existing data and configuration under MYSQL 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]\bincmd> backUpData.batwhere, ServiceDesk Plus Home -> C:\ManageEngine\ServiceDesk. This backup will be stored under the Backup folder in ServiceDesk Plus Home directory.Step 3: Invoke ChangeDBServer.bat under [Service Desk-Home]\bin folder. [
Screenshot ]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.Step 5: Start and stop the ServiceDesk Plus 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 service once the restore process is complete.