特色

架構和數據同步
在從測試轉移到生產的同時，直觀地應用模式和數據更改。使用我們基於超快校驗和的算法，以預定的時間間隔定期復制數據。

SQLyog SSH和HTTP隧道
直接訪問MySQL被阻止？強迫使用笨重的phpMyAdmin？SQLyog讓你滿意。

SQLyog預定備份
功能強大的備份嚮導，具有一鍵備份選項，可輕鬆安排備份。

SQLyog導入外部數據
簡化從任何ODBC兼容數據源到MySQL的數據傳輸/遷移。

功能

• Create/Drop/Alter Tables, Stored Procedures, Functions, Views, Triggers and Events.
• HTTP and SSH Tunneling - smartly manage your MySQL server even if the MySQL port is blocked or remote access to MySQL is disallowed!
• Protect your data with SSL encryption.
• Smart AutoComplete.
• Formats SQL statements.
• Proactive Query Profiler.
• Favorite Manager to neatly organize your favorite SQL statements.
• Very fast retrieval of data.
• Advanced GUI Query Builder. Supports JOINs, aggregate as well as 'common' functions, sorting (ORDER BY) and filtering (WHERE and HAVING) and ALIAS.
• SQLyog Import External Data wizard - use the GUI or specify a query.
• Schema and Data synchronization tools.
• Powerful compressed Scheduled Backup with email notification.
• Schedule various jobs.
• SQL Scheduler and Reporting Tool - execute unattended queries for database maintenance of data verification with flexible email option.
• Full support for Virtual Columns of both Oracle/MySQL and MariaDB
• GUI transactions support
• Transparent LDAP/PAM support for connection to both Oracle/MySQL and MariaDB. No settings are required
• Update result returned from query - also supports queries with JOINs. No dialogues - just edit!
• Manage foreign key relationships.
• Fully InnoDB compliant.
• Supports MySQL pluggable storage engines architecture.
• Multi-threaded query execution with option to allow multiple query execution simultaneously.
• View your results in GRID/TEXT mode.
• Filter data and resultsets directly form the context menu of a displayed value.
• Execute (very large) SQL-scripts as batch files.
• Execute multiple queries returning more than 1000s of rows per resultset. Its very efficient in memory.
• Very compact binary.
• Written entirely in C/C++/Win32 APIs using native MySQL C APIs. No wrapper classes used.
• Connection manager.
• Tabbed interface to create/alter tables.
• View and edit advanced table-properties, such as Comment, Key_Length etc.
• Do table-diagnostics (check, optimize, repair, analyze)
• Duplicate tables to new table-names.
• Excel like grid interface to edit data with support for Enum/Set.
• Create/Drop databases.
• Manage indexes.
• Comprehensive user/security manager. Control every available privilege on what level you like (server/database/table/column).
• Reorder columns of table.
• Copy database between two MySQL hosts.
• Drop all tables of a database with a single click.
• Edit BLOBs in TEXT or GRAPICHS mode. All common (non-proprioritary) graphics format (including 'high-resolution' TIFFs and PNGs) supported.
• Export table-structure and data into SQL-dumps.
• Direct export to Microsoft Excel.
• Export/import data in/from CSV files.
• Export database schema in HTML.
• Log all queries for a session.
• Syntax-highlighting.
• Save resultset in CSV, HTML and XML.
• Copy your result as CSV to clipboard.
• Is very keyboard friendly. You can work with 99% features of SQLyog with keyboard.
• View and kill other user-processes.
• Flush Host/Logs/Privileges/Tables.
• Quick access to processlist, status, variables etc.

• Runs on all Windows version from Vista/2008 and higher as well as "Windows Server" systems of same generations (Windows Server 2008 and higher).
• Works with MySQL servers from 4.1 and higher and all MariaDB servers.