Changes (as compared to RC 2) include:

Bug Fixes:
* Previous 8.5 RC’s failed to run when installed as a fresh install. No problem if installed as an upgrade.

Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php

Comments(0)

Changes (as compared to first RC) include:

Features:
* Files can now be drag’n'dropped into the program window and file will be opened in a new Query/Schema Designer/Query Builder tab depending on file type (like ‘file .. open’ menu). Same is implemented in SJA wizards where a file can be opened.
* Improvements to the tabbed connections interface. The active tab is now more clearly distinguishable.
* In connections manager the color code for a connection is now indicated.

Bug Fixes:
* Fixed some small  bugs with filter in RESULT tab.
* The upgrade check dialog popped up on top of other running applications.

Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php

Comments(0)

Changes (as compared to 8.5 beta3) include:

Features:
* Improved the speed of  (csv, html, xml, excelxml and sql) -exports from RESULT tab.

Bug Fixes:
* The grid control in Manage Index dialog did not resize properly with some monitor resolutions.
* Small bugfixes with new features added in 8.5 betas like the tabbed connections interface and filtering.

Miscellaneous:
* The option in ‘preferences’ to ‘Add keywords in UPPERCASE’ is removed.  It was redundant since introduction of  the ‘auto-capitalization’ feature.
* Dialog fonts are now default system font.
* In order to save space Query Builder and Schema Designer tabs will now show the filename without (‘.queryxml ‘and ‘.schemaxml’) extensions.
* Installers will now have two numbers after the numbers identifying the version no. (identical to common naming conventions for RPM installers for Linux). This in order to ensure that every installer we build has a unique name. Various proxy systems would sometimes cache and provide the old file on download request.

Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php

Comments(0)

Changes (as compared to 8.5 beta2) include:

Features:
* Option to ‘duplicate row’ was added to RESULT tab like already implemented in DATA tab in previous betas.
* Added a menu option to ‘Find Next’ in ‘edit’ menu and query editor context menu.
* Find/replace settings are now persistent within the session.

Bug Fixes:
* Fixed a rare issue where the SQLyog configuration file (SQLyog.ini ) could be corrupted – and even deleted – if multiple program instances using same .ini instance were running simultaneously. Scenarios include the situation where user by mistake (double)clicked the program icon twice.
* The warning indicator for GRID operations introduced in beta 1 did not handle multiple RESULT tabs from multiple queries properly.
* Autocomplete could fail to select the items from the listbox (popup window) display after typing “.” if a ‘_’ (underscore) character was present with list box items. Technically this was an incompability between sorting in SQLite, Scintilla and standard C functions. We have added our own code to handle this. But note that for performance reasons it is not handled perfectly with Ctrl+Space and Ctrl+Enter where it can be necessary to use arrow-keys for selection in such case.
* Several small fixes with ‘Find Next’ in editor and Blob Viewer.
* SJA wizards would sometimes fail to specify the correct jobfile path to the Windows Task Scheduler.

Miscellaneous:
* The PLINK shipped with SQLyog was updated. This solves rare connection problems with specific SSH configurations. Mostly connections to very recent Linux distributions were affected.
* Also the SQLite library within SQLyog has been upgraded to the latest version. The new version of SQLite improves stability as compared to the previous version where a possible journal file corruption was not handled.
* SJA wizards: if user does not specify a file extension for the jobfile the wizard will add the standard extension ‘.xml’

Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php

Comments(0)

Changes (as compared to 3.76) include:

Features:
* Added a new interface for customizing counters/advisors requiring less knowledge of javascript than what was the case before.
* When upgrading an installation with customized counters a ‘conflict resolver’ will now guide user to either migrate his old changes to the updated version or discard them.
* All cache hit rate related monitors/advisors have been changed to display cache miss rate information as it is more relevant when tuning databases. Also the advisor text for these monitors/advisors has been improved.

Miscellaneous :
* With the above changes parts of the MONyog database has been reorganized, what also means that the Monitors/Advisors and Dashboard pages will load much faster. Note however that with this beta the documentation on the ‘MONyog database schema’ is not fully updated.
* The SQLite library within MONyog has been upgraded to the latest version. The new version of SQLite improves stability as compared to the previous version where a possible journal file corruption was not handled.

Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php

Comments(0)

Changes (as compared to 8.5 beta1) include:

Features:

• In RESULT tab data can now be filtered at client side which is already possible in Table Data. Also added RESET FILTER icon in the toolbar.
• Menu option ‘Paste SQL Statement’ will format the query as per the SQL Formatter Preferences settings.
• Tabs can now be closed with the click of middle mouse button (mouse wheel).
• Keyboard shortcut F3 for ‘Find Next’ in Query Editor and Result/Table Data tab in Text mode. Note: Not implemented in BLOB-viewer.
• Shift+click can be used to select/deselect multiple objects in tree-view control of Copy Database, Export, etc.

Bug Fixes:

• ‘No Database Selected’ error during a reconnect is avoided by prefixing data-sync queries with database name.
• Shortcut for copying ‘Ctrl+Insert’ was not preserving the letter case.
• GUI and flickering issues with tabbed interface for multiple connections has been fixed.

Enhancements:

• Keyboard shortcut Ctrl+9 for selecting last connection tab.
• In Result/Table Data Tab all Copy related options are grouped together.
• Minimized the number of pop-ups while creating a Table.

Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php

Comments(0)

Changes (as compared to 8.4) include:

Features:

* This version introduces a tabbed interface for connections.  Tabs will be colored (if chosen) like the Object Browser. Note that the meaning of shortcuts Ctrl+number have changed: they will now shift between connection tabs. The old Ctrl+number shortcuts have been changed to Ctrl+Shift+number.
* Added an option to ‘duplicate row’ from DATA tab GRID context menu. Tables with auto_increment columns are handled. Note that handling all other CONSTRAINTs is user’s responsibility.
* When a GRID operation returns a warning there is now a clickable link for SHOW WARNINGS. Note: this is not implemented for HTTP tunneling.

Bug Fixes:
* It was not possible to enter a value higher than 999,999 for OFFSET and LIMIT in DATA and RESULT tabs. Now up to 15 digits are allowed.

Miscellaneous :
* Use of  ’compressed protocol’ is now default for new connections. Our test tell that the positive effect of using it can be huge when it should be used and the negative effect when using it, when it should not, is very small.

Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php

Comments(0)

Hi,

SQLyog 8.4 happens to be a fairly major release with good number of features & enhancements. Listed below are some worth noting.

• May it be Query Profiler or Datatype Optimizer, SQLyog has grown beyond the definition of a GUI with these features with intelligence. One such feature that is being unveiled with this release is an option to find redundant indexes. You can find the redundant indexes in a Table with just a click of a button. If found, a ready query is generated to drop the redundant indexes. As you know eliminating redundant indexes improves INSERTs & UPDATEs and also saves hard-disk space.
• Scheduled Backups can be compressed.
• If you are one of those users who deal with databases having thousands of objects (tables, columns etc.) this release will definitely add to your productivity as auto-complete has been drastically improved for such databases.
• You can sort the data of Result set. The sorting is very fast as it is done at the client side unlike Table Data where a query is fired to server for every sort action.

Redundant Index Finder

This release also contains following enhancements:

• A file can be loaded to the tab from context menu.
• Added menu items (for exports and ‘copy to other..’) at table-level in Object Browser.
• Save dialog when closing a connection now has ’Yes to All’ and ‘No to All’ options.
• Added an option to send a mail alert if an error occurs while executing a ‘maintenance query’ from Notifications Services.

SQLyog customers can download the latest installer from Webyog’s Customer Portal.
To evaluate SQLyog, please download the 30-day trial.

We are very excited about this release, and hope that you will like it. We would love to hear from you.

Cheers,
Team SQLyog

PS: Redundant Index Finder is a feature of SQLyog Ultimate only.

Comments(2)

Bug Fixes:
* On un-checking ‘save password’ option in connection window, SQLyog was not deleting password in ini file.
*  Schema Designer was prompting table out-of sync if there was a difference in table’s AUTO_INCREMENT ‘value’ or if extra spaces were present between identifiers.
* On executing SELECT statements having clauses like PROCEDURE, INTO FILE, FOR UPDATE, etc,  was adding LIMIT clause if result tab paging option is enabled.
* Program now has common option in preferences to “Prompt if a tab with unsaved changes is closed”. Earlier it was separate for query editor, Schema Designer and Query Builder tabs.

Downloads: http://webyog.com/en/downloads.php

Purchase: http://webyog.com/en/buy.php

Comments(0)

Changes (as compared to 3.74) include the bug fixes:

* Failure to open the SQLite resource DB located in MONyog’s installation directory could result in a crash. This crash has been fixed, but note however that MONyog is unable to function without this resource DB and will log an error message and perform a graceful exit.
* The Monitor/Advisor “Binary Log” –> “Transactions that got saved in temporary file” displayed “NaN” (JavaScript for Not-a-Number) for non-zero values of the associated MySQL counter.

Miscellaneous :

* Internet Explorer 6.2800 on Windows 2000 may hang when trying to display MONyog’s interface. This behavior is not seen in the next iteration of IE6.

Comments(0)