Unable to migrate to MSSQL

Unable to migrate to MSSQL

Morning 

I am trying to migrate our database from Postgres to MSSQL, with limited success.


Step 1: Stop ManageEngine ServiceDesk Plus service.
Step 2: Take a backup of the existing data 
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.
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. 
Step 7: Start ManageEngine ServiceDesk Plus service once the restore process is complete.

I successfully get to Step 5, but when I start the server it fails. Using the GUI the splash screen will show and stall (at what I now know to be 89%) and just sit there forever. When I use run.bat I notice the following:

This copy is licensed to Cornwall College

ServerContainer                                   [CREATED]
AdventNetCC                                       [CREATED]
AdventNetServiceDesk                              [FAILED]
ServerContainer                                   [STARTED]
AdventNetCC                                       [STARTED]
Failed to start the server. Please refer logs for more details
AdventNetCC                                       [STOPPED]
ServerContainer                                   [STOPPED]
AdventNetCC                                       [DESTROYED]
ServerContainer                                   [DESTROYED]
I can see the system creating new tables in the database - so the connection is working.

I have found various things online trying
  • Collation of database is correct
  • Deleted applications/extracted folder so it recreates
  • Reinitialized the database and re-ran the run.bat

I have also tried restoring the data from my Postgres backup but this fails as well (but that is probably a different issue which I will attack once this works)...

You're help would be much appreciated.

                  New to ADSelfService Plus?