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

Syncing Tables without a Primary Key

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Syncing Tables without a Primary Key

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • January 11, 2004 at 10:03 pm #15388
      Shadow
      Member

      SQLyog has always been picky on PKs. It won't let you edit a table via its GUI if the table does not have a PK defined.

      In the sync case, however, I perfectly understand why SQLyog does not sync tables without PK: it would need to compare the whole content of the desired table to determine which rows differ and that would put heavy load on the machine(s) with the dbs and SQLyog. If you do can create those PKs then go ahead and creat them!

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