I am wanting to update my ServiceDesk Installation from MySQL to MSSQL.
I had completed the update to the most current build and performed a full backup of the database followed by running the change database script in the bin folder which successfully makes a connection to the SQL 2012 Server and creates the database along with the tables after the restart of the ServiceDesk Application.
I then start the restore which is where problems start occuring.
I run the restoredata.bat file and point it to my backup that I took previously. It will extract the backup file and start to process and then will exit as it is unable to find a table. "Cannot find the object "Application Status" because it does not exist or your do not have permissions"
I have manually added approximately 30+ of these tables (NetworkCredentials, MObileOSType, ModeDefinition, ApplicationStatus) to name a few. And it will continually come up with another one upon a restore attempt.
My question is this. Did I miss a step someplace along the lines, did my database schema not update someplace along the lines, how can I fix this as I would like to move to MSSQL. (The upgrade path I followed on the test server I am performing this is as follows... 8121 to 8200 to 8201 to 8212 to 8214 to 8217)
Regards,
Jason Stuart