error when migrating database
good morning
I am currently migrating the database servicedesk the migration is from postgresql to sql server during the process I generate the following error:
Please wait ! Restoring in Progress...................
Error Tables : wordmap,wordoccurrences,errorlog
0-----------------------50------------------------100(%)
================QUERY = INSERT INTO DepartmentDefinition (deptid,deptname,depthe
adid,phoneno,fax,siteid,deptdesc,isdeleted,ciid) VALUES(36024, N'BANCA DE EMPRES
AS', NULL, NULL, NULL, 4201, N'', '1', 223624);
java.sql.BatchUpdateException: Violation of UNIQUE KEY constraint 'DepartmentDef
inition_UK'. Cannot insert duplicate key in object 'dbo.DepartmentDefinition'. T
he duplicate key value is (Administracion, <NULL>).
at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.ja
va:901)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(Rest
oreSDBackup.java:728)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(Resto
reSDBackup.java:391)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.
java:116)
at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.jav
a:188)
at java.lang.Thread.run(Unknown Source)
Unable to restore database : Violation of UNIQUE KEY constraint 'DepartmentDefin
ition_UK'. Cannot insert duplicate key in object 'dbo.DepartmentDefinition'. The
duplicate key value is (Administracion, <NULL>).
Violation of UNIQUE KEY constraint 'DepartmentDefinition_UK'. Cannot insert dupl
icate key in object 'dbo.DepartmentDefinition'. The duplicate key value is (Admi
nistracion, <NULL>).
curent version : 9318
curent data base: postgresql
database to migrate: SQL Server
could guide me to determine what is the problem
New to ADSelfService Plus?