MYSQL to MSSQL - RestoreDB does not restore the requests???
Hi,
Just had to move my ServiceDesk onto a new machine so thought I would go MSSQL while I was at it.
So far I have done the following:
1) Did a bakup from old MYSQL server
2) Did fresh install of exact same version of SD on my new server (7015)
3) Set it up for MSSQL - it tests connection okay and has built database all looks good.
4) Started SD - Started Okay
5) Logged on and added license file - all went okay.
6) Stopped SD
7) Copied my backup file across and ran a restoreDB
8) It comes up with an error
I can still start it and log on and all the config and assetts etc... are all there but the requests are not!?
This is the error the restore spits out:
Unable to restore database : Violation of PRIMARY KEY constraint 'WO_PK'. Cannot
insert duplicate key in object 'dbo.wordoccurrences'.
Please help, I need to get it moved before Sunday - Thanks in advance for your prompt reply.
New to ADSelfService Plus?