Visual Data Comparison is an interactive implementation of Data Synchronization. Internally the two use the same code, but Visual Data Comparision is intended to be run in attended mode where…
SQLyog’s Schema Synchronization Tool, is a visual comparison/synchronization tool designed for developers who work between different MySQL servers or need to keep databases between two MySQL servers in sync. This…
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…
If you selected the option Save Configuration file at the previous wizard page, you will be provided with a page where you can specify the file name to save you sync session…
Selecting Synchronize Now… in the dialog shown above will start the synchronizing process. SQLyog starts up SJA as a child process to sync the databases. The complete detail of the sync process…
In Direct synchronization type, option will sync immediately as the sync tools finds differences in the table. Alternatively, you can generate SQL sync scirpt for later execution or both options…
The “Synch all tables in The database” always synchs all the tables present in the database at any given time. If new tables are added to the database at a…
In One-way synchronization, no modification is done in the source database. The extra rows present in the target database are deleted if you keep the checkbox “Don’t delete extra row(s)…
You can start Database Synchronization with SJA by using the Wizards available with SQLyog or running SJA from the command line. Linux users can only use the command prompt option. Start…
SQLyog Job Agent (SJA) is a high-performance, multithreaded application to automate and schedule synchronization of Data between two MySQL hosts. SJA can also be used as a command line tool that accepts…
