[ANN] Tool for

[Karam Chand]

Webyog has released SQLyog 3.61 - which includes
SQLyog Job Agent ( SJA ) that enables MySQL Data Synchronization.

SJA  is a high-performance, multithreaded, 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 SJA. For
example databases ( 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. 

Additionally, you can configure SJA to detect changes
only for specific rows and columns. For example can exclude blob columns or include only those rows
that fulfill a WHERE clause. This makes it an ideal
tool to sync 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 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 donJob 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

Apart from regular administration tools, SQLyog also
contains the following features:-

- ODBC Import - Migrate ORACLE, MS SQL, Sybase, DB2,
Access, etc to MySQL with a powerful wizard based
interface!
- 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.


__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com