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

Data Synchronization tool

forums forums SQLyog Using SQLyog Data Synchronization tool

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • #7863
      dfi
      Member

      Very new to MySQL and SQLyog. I was hoping someone could help me understand the concept of synchronization as well as the execution of it. My understanding is that I can compare tables for changes made to the data. My hope was I could use this as a means of checking for changes made to a table of data and updating a copy of that table with the changes across all of the fields. Does this make sense? Am I correct, can the synchronization tool be used for this practice? If so, how? Can I provide any other information to make this clearer?

      DFI

    • #14134
      CalEvans
      Member

      DFI,

      No, the database sync tool is for syncing the STRUCTURES of databases, not data.

      There are tools that will do this. Check http://www.freshmeat.net and search for mysql. Should be able to come up with what you need.

      =C=

    • #14135
      dfi
      Member

      Thanks for your quick response. I spent the last couple of hours looking at the freshmeat.com site and found a lot of cool stuff. In my earlier message I used the term data synchronization incorrectly, would you have a term that I could use to narrow my search on freshmeat.com to find a tool that will help me compare the actual data from 2 different MySQL tables for differences.

      dfi

Viewing 2 reply threads
  • You must be logged in to reply to this topic.