Database Synchronization

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 a Job Definition file encoded in XML as one of the parameters. You can either create the Job Definition file manually or use one of the wizards included with SQLyog. If you use SQLyog to create your job files, you don't need to have any knowledge about XML or the Job Definition schema.

SJA does not require any installation at hosts running the MySQL server. You can use any host to run the SJA. For example - you can use SJA to keep your production database (probably hosted with an ISP) in complete sync with your test database located in your PC or LAN.

SJA uses an efficient algorithm to generate checksums to find out the changes. Therefore only those rows that have been inserted, updated or deleted since the last sync are transferred between the hosts.

On Windows, it is available with SQLyog. The Linux version of SJA is FREE and can be downloaded from Here.

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