Forums | Webyog
Tools to manage and monitor MySQL databases
forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › sja <column> tag isn't used sometimes
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
You can configure SJA to detect changes only for specific columns. However, the structure of source and target tables should be identical.