A Powerful MySQL Development and Administration Solution

SQLyog enables database developers, administrators, and architects to visually compare, optimize, and document schemas.

Power Tools

SQLyog’s power tool to automate and synchronize data for MySQL

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.

Visually Compare Data​

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’s power tool to interactively synchronize data for MySQL
SQLyog’s power tool to interactively compare and synchronize schema for MySQL

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.

SQLyog’s power tool to interactively import external data to MySQL
SQLyog’s power tool to schedule database backups for MySQL

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.

SQLyog’s power tool to schedule and report on SQL queries for MySQL

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

WORKS WITH

Trusted by 2.5 million users around the world.
  • Quote
    Justin Hubbard
     
    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.
  • Quote
    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.
  • Quote
    Eddie Rosenthal
    Higher Source Sites
    One of the nice things about this product is excellent technical support! A great product, I highly recommend it.
sqlyog-companies
sqlyog-companies---tab
sqlyog-companies----mobile

Try it for free

Only available for Windows