Skip navigation links

MySQL Forums :: MySQL Workbench - Database Migration :: duplicate entry error on primary key?


Advanced Search

duplicate entry error on primary key?
Posted by: Brian Dominick ()
Date: February 02, 2008 04:26PM

I'm trying to convert an MS SQL 2000 database to my newly beloved MySQL using the Migration Toolkit (also beloved). It's a huge and complex database, so I've had a few expected snags with data types and such, but now I'm hitting one I find utterly puzzling.

From the Migration Completed Report:

`pnw_main_dbo`.`AppPubItems`
----------------------------
Duplicate entry '18' for key 1
Duplicate entry '208' for key 1
Duplicate entry '559' for key 1
Duplicate entry '821' for key 1
Duplicate entry '1028' for key 1
Duplicate entry '1222' for key 1
Duplicate entry '1395' for key 1
[... rows deleted ...]
Duplicate entry '4408' for key 1
0 row(s) transfered.

This is only happening for one table, AppPubItems, which just happens to be the most critical table in the db.

Key 1 is, I assume, the primary key, in this case an integer column called ItemID. But when I look at the database, unsurprisingly, there are no duplicate entries for those rows at all.

Why does the migration wizard seem to think there are? Does anyone know a way to address this? I can't find the term "duplicate entry" in this forum, so I'm a bit nervous...

Options: ReplyQuote


Subject Written By Posted
duplicate entry error on primary key? Brian Dominick 02/02/2008 04:26PM
Re: duplicate entry error on primary key? Brian Dominick 02/03/2008 01:14PM
duplicate entry error on primary key? 2 Peter Hesen 05/08/2008 04:54AM
Re: duplicate entry error on primary key? further investigation Peter Hesen 05/08/2008 09:50AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.