Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Syncing Tables : Source Always Overwrites Target

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Syncing Tables : Source Always Overwrites Target

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • September 27, 2007 at 8:54 am #25030
      peterlaursen
      Participant

      “The trial version allows me to choose only one table at the time” no .. TWO!

      “The result is that the source db overwrites the target db” This is by design!.

      Please search a little! This has been asked 100 times and replied to 100 times as well!

      Short answer: there is NO WAY a computer can tell which row is the correct one if two rows with the same PK_value exists on both hosts, it needs a 'rule' defined by a human. The only 'rule' supported at a time is “overwrites ” We plan a more advanced 'conflict resolver' for users to define their own rules.

      Also read this article:

      http://webyog.com/en/whitepapers/Using_SQL…L_Databases.pdf

  • Author
    Posts
Viewing 0 reply threads
  • You must be logged in to reply to this topic.