Database Synchronization Exception

[Whipples]

Has anyone had any success using sqlyog’s synchronization tool to keep two databases in sync for everything except one column?

We are using it to keep a products database synced up between four different locations, but do not want it to overwrite the quantity field. That way we can have all price and description changes pushed out every night, while still keeping the quantity on hand separate for each location. Is this something we can do with sqlyog’s synchronization too?

[Sibin A S]

Hi,

 

SQLyog performs the sync between all the columns between the tables. There is no option to exclude a specific column from being synced.

 

In SQLyog, there is an option to select specific columns to be compared to determine the updates to be done in the target. But, it does not mean that only the selected columns are synchronised. Irrespective of the columns selected to perform the checksum calculation, SQLyog would sync all the columns in a table. 

 

For more information, please refer the doc >> http://sqlyogkb.webyog.com/article/294-selecting-tables

 

Regards,

Sibin

[Whipples]

Just wanted to leave the solution we ended up using in case anyone else having this problem and wants to do something similar.

Rather than do a direct sync, we setup a scheduled task that saves the sql file. We created an internal webpage that reads the sql file into coldfusion (We are using coldfusion for this, but I’m sure this can be made to work lots of ways). We parse out the file removing the `feild_no_update`=’value’. The inserts are trickier, but similar thing. After that, you just schedule to execute the modified query and it works great.

 

Being able to sync only part of a database would be a really nice feature to have. Till something like that is added this worked for us.

[Author]

Posts