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

Forums | Webyog

Tools to manage and monitor MySQL databases

Two Way Sync Modifying Non Specified Columns ?

This topic is empty.

Viewing 3 reply threads

Author

Posts
- June 5, 2007 at 12:56 pm #10361
  
  Arun
  Member
  
  Hi,
  
  I am using sja for replicating a tables in two different databases…. and have told xml file to make two way replication for certain columns .. And when i modify a non-specified column (column which is not specified in xml file) in the target database every thing was working as expected,it doesnt make any unnecessary changes in source database .. But when make changes for some specified columns in source database it overwrite the value for the non specified column in target db.. I couldnt figure out how this happend 🙁 …. It is not supposed to modify the non-specified columns isn't it?
  
  Thanks…
- 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 3 reply threads

You must be logged in to reply to this topic.