Error while Migrating DB from PostgreSQL to MY SQL 2012
Hello Team,
I just moved on SDP
9120 build and having inbuilt PostgreSQL DB.
I am trying to move my DB from PostgreSQL to MY SQL.
I have followed all the process but at last I am end up with an error. Below is the error for your reference.
*************************************************************.\backup_info.xml
Backpup data : Wed Jan 20 16:40:02 GMT 2016
Database name : servicedesk
Total Tables : 1376
Database Server : postgres
Build Number : 9120
*************************************************************
Active DB Server = mssql
Database connectionProp : null
Database started
Please wait ! Deleting table data in Progress..
0-----------------------50------------------------100(%)
===================================================
Error Tables : wordmap,wordoccurrences
0-----------------------50------------------------100(%)
Please wait ! Restoring in Progress...................
Error Tables : wordmap,wordoccurrences
0-----------------------50------------------------100(%)
=======================QUERY = INSERT INTO SoftwareManufacturer (swmanufacturerid,name,createdby,supportdeflicensetypes,description,logo) VALUESnull
Unable to restore database : Violation of UNIQUE KEY constraint 'SoftwareManufacturer_UK1'. Cannot insert duplicate key in object 'dbo.SoftwareManufacturer'. The duplicate key value is (Canon Inc.).
Violation of UNIQUE KEY constraint 'SoftwareManufacturer_UK1'. Cannot insert duplicate key in object 'dbo.SoftwareManufacturer'. The duplicate key value is (Canon Inc.).
Can you please help me to sort this out? I am attaching my resoreData.bat file in text format for your reference.