Skip Columns During Synchronization?

[John Cokos]

Is there a way to skip columns from having data updated during synchronization?

Our situation and need is pretty simple:

We have a development database and a live/production database that we need to keep in sync. SQLyog does an awesome job at this, with one exception …

We have one table that has a column into which we store a list of email addresses. We use this when submitting a form from the website. Everyone in the list gets a copy of the confirmation email that gets sent. During development, when we're killing that form, the list of people that get that email is different from when we go live … but everything else is the same.

So, when we 'go live', we need to have the Sync tool update all of the data in that table EXCEPT for that one column, so that we can keep it different on the servers. Sure we can manually fix it after the fact, but once that table gets more than 10 rows in it, the task becomes too time consuming.

By unchecking the appropriate column box in the sync tool, we can take those columns out of the mix as far as the checksum goes, I get that, but I'd also like a way to specify skipping those columns in the update process as well, if possible.

Thoughts ? Ideas ?

Thanks,

John Cokos

[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