Wednesday, February 20, 2013

Webyog SQLyog 11.0.1




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 11.0 (February 2013):
Features
* Now SQLyog (including SJA for both Windows and Linux) is available as both 32 and 64 bit binaries. Obviously the 64 bit version will require a 64 bit Windows. 32 bit version will install to ‘Program Files (x86)’ and 64 bit to ‘Program Files’ on 64 bit systems.
* Autocomplete is now context-aware. The keyword before any type of autocomplete popup/dialog will be used for filtering and displaying only object types relevant in the context.
Bug fixes
* Copy to clipboard from GRID could in rare cases truncate the last row away. This bug was introduced in version 9.51.
* Fixed a bug in import external data where clicking on “select all” would select tables even when no data was returned from the source. This could cause a crash while executing the job. This was introduced in 10.1.
* If there was no default database selected in the main dialog of SQLyog, changing the database from the dropdown in ‘backup as SQL dump’ dialog would cause SQLyog to hang. Introduced in version 10.5.
* When using drag and drop to create a Foreign Key constraint in Schema Designer, the ALTER TABLE pop-up dialog would have the view scrolled to the right, resulting in the leftmost two columns being hidden. This issue was introduced in 9.6.,/li>
* The position from where the ‘Themes’ folder was read did not honor a specified -dir startup switch. It will now read from a ‘Themes’ subfolder to the folder specified with -dir if exists.
* Schema Sync could attempt to DROP and CREATE a Foreign Key in one ALTER TABLE statement in cases where a Foreign Key existed on both source and target specified on same columns but details for ON UPDATE and/or ON DELETE were different. This will not work and now two statements are generated.
Miscellaneous
* Explain Extended (executed by Query Profiler) now pops up an error dialog instead of logging to MESSAGES tab if an error occurs with the statement.
Size: 9.81 MB

0 comments:

Post a Comment