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

Two Way Sync Modifying Non Specified Columns ?

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Two Way Sync Modifying Non Specified Columns ?

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • June 5, 2007 at 1:45 pm #24092
      peterlaursen
      Participant

      You do not understand what the specification is for.

      Please refer to:

      http://webyog.com/en/whitepapers/Using_SQL…L_Databases.pdf

      SQLyog/SJA data sync will always sync complete rows.  The  specification is used to specify which columns are used for generating checksums.  For instance if you have a unique column (more than the PK) you can specify that column alone and achieve a major performace improvement.  Also avoiding BLOB columns for the checksum generation can speed up things a lot!

    • June 5, 2007 at 3:44 pm #24093
      Arun
      Member

      Thank you very much for giving clarification….. Is there a way to exclude one particular column from a table , being sync ?

      /arun

    • June 5, 2007 at 3:57 pm #24094
      peterlaursen
      Participant

      i am sorry but there is no way with SJA sync!

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