Points To Remember

In Database Synchronization the Primary Key of every table is used to uniquely identify rows. When creating a sync job one database is defined as 'source' and the other as 'target'. Therefore, if both tables have a row with same Primary key value, the rule is that "source will overwrite target". A two-way sync is simply a one-way sync from source to target, followed by a sync from target to source. If data is to be inserted on both servers the PK must be defined in such a way that the same value for the PK will not be created on both servers.

Note:This feature is available in SQLyog Enterprise and Ultimate.