SQLyog enables database developers, administrators, and architects to visually compare, optimize, and document schemas.
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.
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.
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.
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.
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.
SQLyog includes a tool to profile executed SELECT queries. The tool displays: