How to get rid of “Error 1062 Duplicate entry '1' for key 1”? August 30, 2014 05:27 "Insert sync" and "Update sync" options should be activated for all tables. At least, one unique primary key field per synchronizing table should be specified. Otherwise, the synchronization is not performed properly. Related articles How to configure MySQL server for DBConvert? Can I convert primary keys, foreign keys and indexes? Why Additional extra views have been created in target database when converting from SQL database to MySQL? Migration speed Index and Foreign Keys Options. Comments 0 comments Please sign in to leave a comment.