Webyog SQLyog 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. Webyog SQLyog software 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, Webyog 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 9.5 (December 2011):
Features
* All CREATE TABLE and ALTER TABLE GUI functionalities will now open in a non-modal tabbed interface. The new tab appears in the SQL area (alongside QUERY tabs etc.). With the new interface some minor bugs with the old interface have been fixed as well. Also the SQL generated is cleaner as regards formatting and redundancy. Note that in this beta the old dialogs are still used by Schema Designer.
* HISTORY and INFO tabs will now also appear in the SQL Area. The rationale is that those are not related to a specific (set of) query(ies). We plan to move the DATA tab up there as well for same reason.
* When SQLyog opens, the SQL Area will new open the HISTORY tab, INFO tab, and a single QUERY tab. Other tabs belonging in this area can be opened on demand. HISTORY and INFO tab display are persisitent across session (ie. if one is closed when SQLyog closes down it will not diplay when SQLyog is opened next time – but may be opened by user, of course).
* Search is now possible in INFO tab/text mode and in HISTORY tab. CTRL+F will open the ‘Find’ dialog.
* Foreign Key lookup now works across databases.
Bug Fixes
* The BIT datatype was not supported properly in text-mode.
* On COMMUNITY if the SQL Area was increased to fill all vertical space, the divider could not be dragged back.
* In ‘Execute SQL-script’ it is now optional if the complete script should abort or not if an error was encountered. Before it always aborted. The fix does not apply to HTTP tunnel where we will still ‘abort on error’ always.
* Copying to clipboard could erroneously raise an ‘out of memory’ error. This was a miscalculation.
* ‘Import External Data’ wizard now supports SHIFT+CLICK selection of objects.
* The connection manager GUI’s of the SJA wizards did not handle SSL certicates properly (the main program window did not suffer from this).
* If an ENUM/SET column was returned using an alias the drop-down combo in the RESULT GRID did not display.
* Underscores were not handled properly by Autocomplete.
* Syntax highlighting is now not used in INFO tab. It made sense for the CREATE statement only and was disturbing in other contexts.
* A default for a BIT datatype could not be specified properly. Now b’..’ and x’..’ notation may be used when specifying column defaults.
* When connected to pre-4.1 servers non-ASCII characters could garble.
* Closing a query tab with multiple result sets could cause a memory peak and raise an out of memory error.
* Duplicate table failed to copy spatial indexes.
Homepage – http://www.webyog.com
Size: 15.3 MB
Download Trial
0 Comments