Move from one SQL server to another SQL server
Please follow the below steps to move from one SQL server to another SQL server
Step 1: Stop ManageEngine ServiceDesk Plus 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 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.
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.
Note : if you are not able to change the database name , edit the mssql-ds.xml under [ServiceDesk-HOME]\server\default\deploy and change the database name and save the file.But after that don't save the changedbserver.bat settings after
Step 5: Start and stop the ServiceDesk Plus server once.
NOTE: A database called ServiceDesk(if changed new name new name will be present) 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 ServiceDesk Plus service once the restore process is complete.
Another way of moving from one SQL Server to Another SQL Server.
Step 1: Stop ManageEngine ServiceDesk Plus service.
Step 2: Take a backup of the existing database in the Sql Server.which will give you a .bak file.
Step 3:Restore the backup to the new database in the New SQL Server.
Step 4: Invoke ChangeDBServer.bat under [Service Desk-Home]\bin folder.
Step 5: 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.
Note : if you are not able to change the database name , edit the mssql-ds.xml under [ServiceDesk-HOME]\server\default\deploy and change the database name.But after that dont save the changedbserver.bat settings.
Step 6: Start the ServiceDesk Plus server.
Krishna Bharat
Step 1: Stop ManageEngine ServiceDesk Plus 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 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.
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.
Note : if you are not able to change the database name , edit the mssql-ds.xml under [ServiceDesk-HOME]\server\default\deploy and change the database name and save the file.But after that don't save the changedbserver.bat settings after
Step 5: Start and stop the ServiceDesk Plus server once.
NOTE: A database called ServiceDesk(if changed new name new name will be present) 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 ServiceDesk Plus service once the restore process is complete.
Another way of moving from one SQL Server to Another SQL Server.
Step 1: Stop ManageEngine ServiceDesk Plus service.
Step 2: Take a backup of the existing database in the Sql Server.which will give you a .bak file.
Step 3:Restore the backup to the new database in the New SQL Server.
Step 4: Invoke ChangeDBServer.bat under [Service Desk-Home]\bin folder.
Step 5: 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.
Note : if you are not able to change the database name , edit the mssql-ds.xml under [ServiceDesk-HOME]\server\default\deploy and change the database name.But after that dont save the changedbserver.bat settings.
Step 6: Start the ServiceDesk Plus server.
Krishna Bharat