Topics : Database Administration,Database Change Management,Database Development,Database Performance,

Products : SQLyog,

Key points to remember while using SQLyog – Power tools edition

SQLyog has many options that sometimes remain unseen during a free trial. For example, SQLyog’s Ultimate edition provides the following valuable power tools:

  • Synchronize data: Automate and schedule the synchronization of data between two MySQL hosts.
  • Compare data: Compare data from the source and target to decide whether to synchronize and in which direction.
  • Compare and synchronize schema: Compare and synchronize the tables, indexes, columns, and routines of two databases.
  • Import external data: Import external data to transfer data from any ODBC compliant data source to MySQL.
  • Schedule backups​: Schedule the exporting of database schema (and optionally data) as SQL scripts for backup.
  • Schedule and report on queries: Validate SQL queries before scheduling, schedule queries, and send emails with query results.
  • Profile queries: Profile executed SELECT queries, and display query performance and detailed query information.

Watch this video to better understand how SQLyog helps users and how to navigate some of the uncharted territories of MySQL database management. Learn how SQLyog’s Power Tools can help you with your MySQL databases.

Next steps

SQLyog is as versatile as it is powerful. With SQLyog, you can use a single tool to manage MySQL across physical, virtual, and cloud environments.

Learn More

Contact IDERA: