A Powerful MySQL Development and Administration Solution
SQLyog Ultimate enables database developers, administrators, and architects to visually compare, optimize, and document schemas.
Automatically Synchronize Data
SQLyog Ultimate 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.
Visually Compare Data
SQLyog Ultimate includes a power tool to interactively synchronize data. Run the tool in attended mode to compare data from source andbefore taking action. Using the intuitive display, compare data on source andfor every row to decide whether it should be synchronized in which direction.
Visually Compare and Synchronize Schema
SQLyog Ultimate 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 Ultimate 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 Ultimate 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 Ultimate 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 Ultimate 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