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

sja <column> tag isn't used sometimes

forums forums SQLyog Sync tools, Migration, Scheduled Backup and Notifications sja <column> tag isn't used sometimes

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • #8288
      gmabey
      Member

      I have two identical tables on different machines.

      I perform an “empty” (truncate) operation on the TARGET machine and then run my sja script.

      Then, the target machine contains all of the fields from the SOURCE server, not just the ones listed with the tag.

      Regards,

      Glen Mabey

    • #15380
      Ritesh
      Member

      You can configure SJA to detect changes only for specific columns. However, the structure of source and target tables should be identical.

Viewing 1 reply thread
  • You must be logged in to reply to this topic.