Skip Columns During Synchronization?

[peterlaursen]

There is an WHERE option for each table. It selects rows that should be considered further in the process. So using the WHERE condition 

Code:

not like '%@%'

… for that email column should do the trick in my understanding. All rows with a '@' in that column will be skipped. And this

Code:

not like '%'

.. will skip every row. All strings satisfy  like '%' and thus no strings satisfy not like '%'

But be aware of this (Release notes for 8.0): 

“The SQL_WHERE option in Data Sync is changed so that WHERE-condition is evaluated againstonly (before it was bothand (logically OR'ed)).”

[navyashree.r]

Hey John,

Also, can you please confirm which SQLyog version you are using?

And please try with the latest 8.22 SQLyog version and confirm whether this is reproducible or not?

8.22 SQLyog from our DOWNLOADS page,

http://www.webyog.com/en/downloads.php

Please help in nailing down this issue.

Regards,

Navya

[Author]

Posts