SQLyog makes MySQL Data Replication and Migration Easy
Newsletters older than 6 months may have links that are out of date. Please use the Search to check for updated links.
Webyog has released SQLyog 3.61 - which includes SQLyog Job Agent (SJA) that enables "Zero Install" MySQL Data Replication.
SJA is a high-performance, multi-threaded, multi-platform application to automate and schedule Synchronization of Data between two MySQL hosts. On Windows, it is included with SQLyog 3.61- the latest version of the award winning MySQL Client. The Linux version of SJA is FREE and can be downloaded from http://www.webyog.com.
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 databases (probably hosted with an ISP) in complete synchrony 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 synchronization are transferred between the hosts.
Additionally, you can configure SJA to detect changes only for specific rows and columns. For example you can exclude BLOB columns or include only those rows that fulfill a WHERE clause. This makes it an ideal tool to synchronize data even if there is limited bandwidth.
SJA is a command line tool that accepts a Job Definition file encoded in XML as one of its 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.
On Windows platforms, SQLyog uses the Task Scheduler services to schedule your jobs. On other platforms you can use the respective OS scheduling services, e.g on Linux, you can use cron to schedule jobs.
Apart from regular administration tools, SQLyog also contains the following features:
- ODBC Import: Migrate ORACLE, MS SQL, Sybase, DB2, Access, Excel, etc to MySQL with a powerful wizard based interface! SQLyog ODBC Import has specially been designed for correct datatype mapping(s) between ODBC datasources and MySQL.
- Schema Synchronization Tool: Automatically generate scripts to bring the table structures of two databases in sync.
- Relationship Manager: Intuitive interface to create and manage relationships.
SQLyog, SJA are available at http://www.webyog.com
© 2010, Oracle Corporation and/or its affiliates