MYSQL to MSSQL - RestoreDB does not restore the requests???

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?