A Powerful MySQL Development and Administration Solution
SQLyog enables database developers, administrators, and architects to visually compare, optimize, and document schemas.
Power Tools
Automatically Synchronize Data
SQLyog includes a power tool to automate and schedule the synchronization of data between two MySQL hosts. Create the job definition file using the interactive wizard. The tool does not require any installation on the MySQL hosts. You can use any host to run the tool.
SQLyog includes a power tool to interactively synchronize data. Run the tool in attended mode to compare data from source and target before taking action. Using the intuitive display, compare data on source and target for every row to decide whether it should be synchronized in which direction.
Visually Compare and Synchronize Schema
SQLyog includes a power tool to interactively compare and synchronize schema. View the differences between tables, indexes, columns, and routines of two databases. The tool generates the correct scripts to synchronize the schema.
Import External Data
SQLyog includes a power tool to import external data to transfer data from any ODBC compliant data source to MySQL. Use its interactive wizard to define its parameters. The import mechanism provides powerful and effective features, such as incremental import, and store and schedule import sessions.
Schedule Backups
SQLyog includes a power tool to schedule the exporting of databases as SQL scripts for backup. The tool saves selected objects into a single file or multiple files. You can export schema only, or schema and data. The session establishes all required connections during the operation execution.
Schedule and Report on Queries
SQLyog includes a power tool to schedule SQL queries. The tool generates, formats, and sends personalized emails with results returned from a scheduled query. You can also use this tool to execute maintenance queries. The interactive wizard validates queries before scheduling.
Profile Queries
SQLyog includes a tool to profile executed SELECT queries. The tool displays:
Query performance and how indexes were used
The rewritten query from MySQL’s Optimizer
Warnings from the query execution
The change of status variables due to the query execution
Detailed information of all internal operations for the query execution
SQLyog is the best database management tool I have ever used. It’s easy to use, backups are easy and fast. The query builder makes life much easier.
TJ Jones
Class.com
SQLyog really is the best breed of all the SQL administrators out there. It's feature rich. Works well, does what it's supposed to do, and doesn't cost a lot.
Eddie Rosenthal
Higher Source Sites
One of the nice things about this product is excellent technical support! A great product, I highly recommend it.