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

Compare Before Syncing

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Compare Before Syncing

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • July 3, 2009 at 4:40 pm #11578
      IamAlive
      Member

      Hi

      Having just obtained this impresive tool, I suspect that I didn't understand what it does – not surprising as I know am no database hero!

      What I want/need to do;

      • I have two databases, with the same structure, but different data.

      • I want to first of all find out what is different, by running some kind of comparison query

      • Then I want to chose which data I take from the master and copy to the second database on a table by table basis.

      How do I do this?

      Thanks for help – please, formulated for an idiot!

    • July 3, 2009 at 5:19 pm #29308
      peterlaursen
      Participant

      There is no tool in SQLyog doing this. The closest is the 'import external data tool' what you may use with the WHERE-clause option.

    • July 3, 2009 at 6:02 pm #29309
      IamAlive
      Member
      peterlaursen wrote on Jul 3 2009, 07:19 PM:
      There is no tool in SQLyog doing this. The closest is the 'import external data tool' what you may use with the WHERE-clause option.

      That is sad news as this is the primary function I need. I guess I have to write it off as another tool I don't need or can't use.

      Maybe someone can point me in the right direction of an appropriate tool?

      Thanks for the information, though, Peter.

      Regards

      David

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