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 Why Additional extra views have been created in target database when converting from SQL database to MySQL? Trigger-based database synchronization What is Database synchronization? Autodetection of potential migration issues. Errors and Warnings DBConvert, DBSync, Studio tools: what are the general differences? Comments 0 comments Please sign in to leave a comment.