Moving physical server - different database - won't restore

Hello,

I need to move SC+ to a different physical server. I have upgraded the current install to the latest version and downloaded the same versions installer to the new server and installed it. However first problem is that Manageengine now fail to supply MySQL as an installation option for the database.

Anyway I backup the existing data and transfer the file to the new server. Now SC+ on the new box has been installed with PostgreSQL. It has been started and everything works like a brand new unconfigured install. I then stop the new server running and attempt to restore the data - it fails.

So I thought I need to get the database the same between the servers so I manually install MySQL on the new server and then use the changedbserver.bat wizard to change the database server. It connects to MySQL and installs the database etc. so MySQL is NOT the problem here.

I then try to start SC+ but it fails. Java32.exe gets to about 100Mb of RAM use and then just quits!!

I can only get SC+ to start if using PostgreSQL. Trying to restore the database to a "blank" MySQL database fails as well.

I don't care what database SC+ is using but it must, without fail, restore the data between databases.

Can someone shed any light or provide a solution since if I can't get this working then SC is dead and un-useable.

Here is the data from the Restore window:

You chose to open this file: C:\Users\Administrator\Downloads\SCPlus\backup_supp
ortcenter_7917_fullbackup_04_13_2013_17_11.data
File name is : C:\Users\Administrator\Downloads\SCPlus\backup_supportcenter_791
7_fullbackup_04_13_2013_17_11.data
13-Apr-2013 20:14:40 com.adventnet.servicedesk.server.utils.SDClientUtil isServe
rAlreadyRunning
INFO: requestScheme is http
13-Apr-2013 20:14:54 com.adventnet.servicedesk.server.utils.SDDataManager <init>

INFO: rootDir :: C:\SupportCenter\..\
Exception while forming the url: null and getting the stream. C:\SupportCenter\.
.\server\default\conf\buildInfo.xml (The system cannot find the path specified)
java.io.FileNotFoundException: C:\SupportCenter\..\server\default\conf\buildInfo
.xml (The system cannot find the path specified)
        at java.io.FileInputStream.open(Native Method)
        at java.io.FileInputStream.<init>(Unknown Source)
        at java.io.FileInputStream.<init>(Unknown Source)
        at sun.net.www.protocol.file.FileURLConnection.connect(Unknown Source)
        at sun.net.www.protocol.file.FileURLConnection.getInputStream(Unknown So
urce)
        at java.net.URL.openStream(Unknown Source)
        at com.adventnet.nms.util.XMLDataReader.load(XMLDataReader.java:260)
        at com.adventnet.nms.util.XMLDataReader.load(XMLDataReader.java:306)
        at com.adventnet.nms.util.XMLDataReader.<init>(XMLDataReader.java:67)
        at com.adventnet.servicedesk.server.utils.CommonUtil.getNode(CommonUtil.
java:24)
        at com.adventnet.servicedesk.server.utils.SDDataManager.readBuildData(SD
DataManager.java:82)
        at com.adventnet.servicedesk.server.utils.SDDataManager.<init>(SDDataMan
ager.java:56)
        at com.adventnet.servicedesk.server.utils.SDDataManager.getInstance(SDDa
taManager.java:71)
        at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(Resto
reSDBackup.java:246)
        at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.
java:118)
        at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.jav
a:184)
        at java.lang.Thread.run(Unknown Source)
C:\SupportCenter\..\server\default\conf\buildInfo.xml (The system cannot find th
e path specified)
java.lang.NullPointerException
        at com.adventnet.servicedesk.server.utils.CommonUtil.getNode(CommonUtil.
java:36)
        at com.adventnet.servicedesk.server.utils.CommonUtil.getNode(CommonUtil.
java:25)
        at com.adventnet.servicedesk.server.utils.SDDataManager.readBuildData(SD
DataManager.java:82)
        at com.adventnet.servicedesk.server.utils.SDDataManager.<init>(SDDataMan
ager.java:56)
        at com.adventnet.servicedesk.server.utils.SDDataManager.getInstance(SDDa
taManager.java:71)
        at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(Resto
reSDBackup.java:246)
        at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.
java:118)
        at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.jav
a:184)
        at java.lang.Thread.run(Unknown Source)
java.lang.NullPointerException
        at com.adventnet.servicedesk.server.utils.CommonUtil.getNodeAsHash(Commo
nUtil.java:65)
        at com.adventnet.servicedesk.server.utils.SDDataManager.readBuildData(SD
DataManager.java:83)
        at com.adventnet.servicedesk.server.utils.SDDataManager.<init>(SDDataMan
ager.java:56)
        at com.adventnet.servicedesk.server.utils.SDDataManager.getInstance(SDDa
taManager.java:71)
        at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(Resto
reSDBackup.java:246)
        at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.
java:118)
        at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.jav
a:184)
        at java.lang.Thread.run(Unknown Source)
Unable to restore database : null
13-Apr-2013 20:14:54 com.adventnet.updatemgr.util.ConfUtils stopDB
INFO: dbadapter :: [null], startDBServer :: [false], dbProp :: null
Press any key to continue . . .