Webyog SQLyog 7 with HTTP/ HTTPS/ SSH Tunneling is a easy to use, compact and very fast graphical tool to manage your MySQL database anywhere in the world. SQLyog was developed keep in mind the necessities of all who use MySQL as their preferred RDBMS. Whether you enjoy the control of handwritten SQL or prefer to work in a visual environment, SQLyog makes it easy for you get started and provides you with tools to enhance your MySQL experience.

SQLyog MySQL GUI is the most powerful MySQL manager and admin tool, combining the features of MySQL Query Browser, Administrator, phpMyAdmin and various other MySQL Front Ends and MySQL clients in a single intuitive interface.

Enhanced Connectivity Options:
- HTTP/HTTPs Tunneling
- SSH Tunneling

Migration Tools:
- Wizard Driven Migration Toolkit
- Import task can be scheduled for transferring data at regular intervals

Synchronization Tools:
- Structure Synchronization
- Checksum based Network Efficient Data Synchronization
- Data Synchronization can be scheduled

Other Power Tools:
- Scheduled Backups
- Notification Services
- Job Manager

Developer / User Productivity:
- HTML Schema Documentation
- Shortcuts to quickly generate SQL statements and paste object names
- Learn MySQL by looking at the SQL generated by SQLyog
- Multi-tab Query Editor and Result-set Editor
- Multiple Query Execution
- Multi-threaded Query execution with option to stop long running queries
- SQL Templates
Excel-style grid interface to view/update resultsets
- Multi-format Blob editor
- View data in Grid/Text Mode
- ResultSet/Data Export to CSV/XML/HTML
- Full Support from 3.23.38 to the latest 5.x
- Support for all MySQL table handlers
- Excel friendly resultsets/table-data export to clipboard/file
- Dialogless table and resultset editor

DBA Productivity:
- Restoring / Importing large SQL dumps
- MySQL 5.x objects support
- User Management
- Managing hosted MySQL
- Connection Manager
- Index Management
- Relationship/Foreign Key Manager
- Reorder Columns
- Copy objects to another Host with single click
- Table diagnostics
- Flush Tools
- Object Browser
- Creating/dropping database
- Optimized for managing Hosted MySQL
- Profiling
- Multiple database connections

Technology:
- Turbo Speed MySQL Management. Uses native MySQL C API – the fastest way to communicate with MySQL server
- 100% keyboard friendly
- Small compact binary
- Minimal use of Registry – easy migration of User Preferences by dragging and dropping config files.
- Non-cluttered look and feel, ability to show/hide panes

Changes in SQLyog 7.14:
Bug fixes:
* Schema Sync did not distinguish “default NULL” and “default ” (empty string)” for string types.
* When multiple connections were open in one program instance and one connection was in wait-state (for instance due to a TABLE LOCK), the whole program could become non-responding.
* If a server thread running a query sent by SQLyog was killed, SQLyog would not always detect it. The connection window associated with that thread would then stay in wait-state forever. Due to the ‘multiple connections issue’ as described just above also the whole program could be affected.
* With MySQL servers 4.0 and before and when connecting with HTTP-tunnel, SQLyog could send an invalid SET SQL_MODE statement when copying large amounts of data. The copy operation would then abort. This bug was introduced in 7.12.
* Reconnecting while populating Object Browser could crash SQLyog.
* Fixed 2 rare crashes in Schema Sync and DATA tab (reported internally).
* Fixed a bug with ‘replace’ in editor. ‘replace’ took effect *after* cursor position not *from* cursor position, so if cursor was positioned inside the string to be replaced that particular instance would not replace.
* Refreshing the GRID moved the cursor to ‘home’ position.
* Fixed a bug in Autocomplete transaction handling (introduced in 7.13) that could cause a crash at statup.
* Migration Tool could fail to find rows when migrating from SQL server 2008.

Homepage – http://www.webyog.com

Size: 10.2 MB

Download