columns all=no don't work

This topic is empty.

Viewing 7 reply threads

Author

Posts
- July 25, 2005 at 11:05 pm #9129
  
  jmhoms
  Member
  
  Hello,
  
  i'm trying to execute the following job file :
  
  localhost
  
  intranet
  intranet 3306
  intranet
  
  localhost
  
  extranet
  extranet 3306
  extranet
  
  `users`
  “user_id“ “user_contact“
  
  with sja, all seems to work fine, but on dest db all fields of “users” are copied.
  
  I've tried with sja 4.0 and 4.1.
  
  Any hints ? i followed the sintaxis of the examples in
  
  http://www.webyog.com/sqlyog/sjaschema.html
  
  Thank you !
  
  Josep M Homs
- July 26, 2005 at 6:42 am #18739
  
  Ritesh
  Member
  
  The behavior is correct.
  
  Specifying column names tells SJA to use those particular columns for generation of checksums. Checksums from source and target tables are then compared to identify a unique row.
  
  Once a unique row has been found, complete row data would be copied from source to target.
  
  Currently there is no way to copy selected columns from source to target.
- July 26, 2005 at 6:46 am #18740
  
  Ritesh
  Member
  
  http://www.webyog.com/forums/index.php?showtopic=1507
  
  HTH
- July 27, 2005 at 4:56 am #18741
  
  sdozono
  Member
  
  What about if you change
  “user_id“ “user_contact“
  to
  `user_id` `user_contact`
  ?
- July 27, 2005 at 5:59 am #18742
  
  Ritesh
  Member
  
  It will be same as SJA checks for extra ` and strips them out.
  
  SJA will always copy whole row from source to target.
- November 21, 2006 at 12:12 pm #18743
  
  Razvan
  Member
  
  Ritesh wrote on Jul 26 2005, 10:42 AM:
  
  Once a unique row has been found, complete row data would be copied from source to target.
  
  Currently there is no way to copy selected columns from source to target.
  
  Hello,
  
  Is there any way to copy a set of selected columns from source to target as we speak?
  
  Thanks
- November 21, 2006 at 1:15 pm #18744
  
  peterlaursen
  Participant
  
  no way to do that with SJA. We do not plan to implement 'exchanging column data between corresponding rows' either.
  
  What we are considering is a 'row based sync' where some rows can be sync in one direction and others in the other. But still complete rows will be transferred.
- November 21, 2006 at 2:26 pm #18745
  
  Razvan
  Member
  
  Thank you for your quick answer
Author

Posts