Restore fails : Cannot insert duplicate key in object dbo.so
Trying to move from MYSQL -> MYSQL i've followed the documentation (6012 btw) when trying to restore my db i get :
0-----------------------50------------------------100(%)
=======================================QUERY = INSERT INTO softwarelist (SOFTWAR
EID,SOFTWARENAME,FILEVENDOR,FILEVERSION,PRODUCTNAME,PRODUCTVERSION,COMPANYNAME,S
OFTWARETYPEID,CURRENTLYMETERED,DESCRIPTION) VALUES(4229, N'M┬�╔�┬�', N'', N'', N
'-', N'-', N'-', 1, 0, N'-');
java.sql.BatchUpdateException: Violation of UNIQUE KEY constraint 'SoftwareList_
UK1'. Cannot insert duplicate key in object 'dbo.softwarelist'.
at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.ja
va:901)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(Rest
oreSDBackup.java:293)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(Resto
reSDBackup.java:124)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.
java:84)
at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.jav
a:184)
at java.lang.Thread.run(Unknown Source)
Unable to restore database : Violation of UNIQUE KEY constraint 'SoftwareList_UK
1'. Cannot insert duplicate key in object 'dbo.softwarelist'.
C:\AdventNet\ME\ServiceDesk\bin>
------
Made several backups they all generate this error. I called support their solution isn't acceptable it means uploading my db to them (Which with the pitiful slow link they have takes about 5 hours) then they have to fix it who knows how long, then 5 hours back down, minimum full day. Can't be down that long we run 24/7/365 and the helpdesk is an integral part of our business operations. Anyone have another solution ??
New to ADSelfService Plus?