Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Database Synchronization Exception

forums › forums › SQLyog › Using SQLyog › Database Synchronization Exception

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • February 18, 2016 at 9:27 am #35656
      Sibin A S
      Moderator

      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

    • March 1, 2016 at 4:26 pm #35657
      Whipples
      Member

      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
Viewing 1 reply thread
  • You must be logged in to reply to this topic.