Data Sync And Table Changes

[Junk1958]

Hi – A colleague and I use SQLyog to do a data sync every hour. I send him six tables of data each time. In each case, the sync sends the entire table with no conditions or where clauses or anything special like that. I am always the sender; he never sends data to me.

Here are some questions:

If I add a column to one of the tables that is sent in the datasync, and if he hasn't made a corresponding change on his side, we are curious what will happen. Will the entire datasync fail? Or will it succeed on all but the one table that has been altered?

And regarding the modified table, will the sync fail on that table? Or will sqlyog sync the existing columns and just throw away the extra column? Or will the table on his end be modified by the change in the table on my end? Or something else?

He doesn't need the extra column, so we don't actually care if he gets the new data, just concerned whether the rest of the data will still sync okay or not, or if he needs to modify his table to match.

We are both running SQLyog Ultimate 8.2 with MySQL 5.1.x. I am on Win2008 R2, he is on either Win2008 or Win2003. Thanks kindly.

Update: I see now that this probably should have gone under the sync tools section, but can't see how to move it, so please feel free to move it and please accept my apologies for any inconvenience.

[Mahesh]

If I add a column to one of the tables that is sent in the datasync, and if he hasn't made a corresponding change on his side, we are curious what will happen. Will the entire datasync fail? Or will it succeed on all but the one table that has been altered?

— Entire Datasync will not fail, it will fail only for a particular table for which “field count does not match”.

And regarding the modified table, will the sync fail on that table? Or will sqlyog sync the existing columns and just throw away the extra column? Or will the table on his end be modified by the change in the table on my end? Or something else?

— Sync will fail as field count varies, also remember one thing to perform database synchronization table structure should be same.

He doesn't need the extra column, so we don't actually care if he gets the new data, just concerned whether the rest of the data will still sync okay or not, or if he needs to modify his table to match.

— It is not possible to sync data if there is a difference in table structure, he should modify his table to match.

I suggest if there is any change in source OR target table structure you should perform Schema synchronization operation first then perform Database synchronization operation.

In this way table structure and data both will be in sync.

[Junk1958]

thanks for the speedy and helpful answer.

[Author]

Posts