Moving DB from Test Server to Production SQL Server
I would like to move our SD database currently residing on a test server to SQL Server production server.
Will this step take care of it or should I move the database within SQL and point it to the database from SD? Which is the best way to go about?
Take a backup of servicedesk using backupdata.bat
Stop the SD application.
Run ChangeDBserver.bat from SDP-home/bin folder.
Provide new MSSQL server details in the GUI & save the settings.
Start and stop the SD application (this creates the MSSQL database)
Restore the database using restoredata.bat from the SDP-home/bin folder
Once the restore is complete, start the SD application.