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

Database Synchronisation Wizard

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Database Synchronisation Wizard

  • This topic is empty.
Viewing 4 reply threads
  • Author
    Posts
    • April 5, 2005 at 11:39 am #8892
      zzapper
      Member

      I generally use “Export Data as Batch Scripts” to backup and transfer my databases, however i've also used the powertool “Database Syncronisation Wizard”.

      However I've noticed that once or twice it's entirely ignored some tables (Ie left them empty)

      to quote the help files:

      >>>SQLyog checks for similarity in the structure and Primary Keys for both the tables. If they are not same

      >>>SQLyog will skip the table during the sync process.

      I shall pay better attention next time, but does it also “skip” tables with no PK?

    • April 5, 2005 at 11:43 am #17357
      Ritesh
      Member

      Yes.

      The most important thing in Database Sync is the PK.

    • April 5, 2005 at 12:55 pm #17358
      zzapper
      Member

      Ritesh,

      Does that mean it's hard luck for tables with no PK?

    • April 5, 2005 at 1:07 pm #17359
      Ritesh
      Member

      Yes.

      We plan to overcome this issue in v4.1.

    • April 5, 2005 at 1:07 pm #17360
      Ritesh
      Member

      The simplest way to sync a table without PK would be to add an Auto_increment column to it.

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