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

Improved data sync with foreign keys

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Improved data sync with foreign keys

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • November 1, 2003 at 6:28 am #15187
      Ritesh
      Member

      To ignore foreign key constraints during data sync check Set FOREIGN_KEY_CHECKS=0 for Target in the Select table(s) that you want to synchronize page of the wizard.

      After the sync is over SQLyog will automatically issue the SQL command – Set FOREIGN_KEY_CHECKS=0

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