Changes (as compared to 8.6 ) include:

Features:
* INFO tab/HTML mode now displays a count of each type of database objects.

Bug fixes:
* Fixed a crash on Vista+ with ALTER TABLE. It happened due to changing compiler to Visual Studio 2010 in 8.6. The older Visual Studio version used handled this bug in our code without crashing.
* Fixed a buffer overrun issue with long column headers that also could cause SQLyog to crash. Also this was a similar issue due to upgrading the build environment in 8.6.
* SQL formatter inserted garbage value if query contained ‘%’.
* “Parenthesis’es highlighting” is now disabled inside MySQL-comments. Before an unmatched parenthesis in a comment would cause ‘mis-matching’ of parenthesis’es in the executable SQL outside comments.
* Fixed some incorrect MySQL API calls in the HTTP-tunneler. This issue was reported internally only.
* The RESULT tab in text mode was showing incomplete data with multi-line strings.
* Import external data now always uses UPPERCASE for keywords in queries sent to the ODBC-source as some ODBC-sources require this.
* Table Data tab was unable to perform custom filter when there was an escape character in the filter text..
* SQLyog was hanging while showing filter tooltip with more than 80 charecters in Table Data tab.

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

Comments(0)

We are pleased to announce the release of SQLyog – MySQL GUI 8.6 GA. This release adds functionalities requested by users for some time, and fixes a number of bugs. Most important enhancements:

User management has been updated with a brand-new interface, has been completely rewritten and also now fully communicates with the MySQL server the recommended way using GRANT and REVOKE syntax. We believe that with this release we have provided the best available ever GUI for MySQL User Management.

For users that prefer to work in a spreadsheet-like interface when filtering and sorting data the options to do this have been enhanced: There is now a ‘custom filter’ option to be used when filtering on a value that does not exist in the result set displayed – or even is not stored in the table at all. Additionally you may now define the substring to be filtered on in more flexible ways than before.

In the editor we added “parenthesis’es matching”. With complex statements (JOINs on derived tables, SUBQUERIES, statements with nested functions and similar) this will make it much easier to identify the structure of the statement. Just position the cursor after a parenthesis and the actual parenthesis and its match will highlight.

We have improved performance by optimizing code in code segments executed most frequently. Additionally we have deployed more debugging and performance measuring tools. This includes – but is not restricted to – moving our build environment to latest Visual Studio environment (2010 edition).

Note that with this release we have stopped supporting Windows 2000. It has for some time been increasingly difficult to continue this support. It is actually quite hard to find a recent system where Windows 2000 will run without errors and we have over the few last years spent quite a lot of effort fixing issues occurring only on this variant of Windows. We believe that the effort is better used ensuring optimal performance on recent and still supported Windows variants – not at least Windows 7, what fastly is taking the position of the dominating Windows variant. The move to Visual Studio 2010 shall be seen in this context. But of course XP, Vista (and the same generations of Windows server variants: 2003 and 2008) are still supported as well as Wine.

Links to Beta/RC release blogs with detailed information.
* http://www.webyog.com/blog/2010/08/17/sqlyog-mysql-gui-8-6-rc3-released/
* http://www.webyog.com/blog/2010/08/06/sqlyog-mysql-gui-8-6-rc2-released/
* http://www.webyog.com/blog/2010/08/06/sqlyog-mysql-gui-8-6-rc-released/
* http://www.webyog.com/blog/2010/08/03/sqlyog-mysql-gui-8-6-beta3-released/
* http://www.webyog.com/blog/2010/07/22/sqlyog-mysql-gui-8-6-beta2-released/
* http://www.webyog.com/blog/2010/07/20/sqlyog-mysql-gui-8-6-beta1-released/

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

Comments(0)

Changes (as compared to 8.6 RC2 ) include:

Miscellaneous:
* With this build we have changed our build environment from Visual Studio 2003 to 2010.
* Windows 2000 is no longer supported.

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

Comments(0)

This release contains a single bug fix for a bug introduced in 8.6 RC released earlier today: updating data from RESULT tab failed as a SQL-statement generated contained an empty tablename.  The issue occurred when a RESULT tab was populated from ‘execute’ (F9/F5) and not from ‘execute for update’ (F8).

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

Comments(0)

Changes (as compared to 8.6 beta 3) include:

Features:
* Added support for “parenthesis’es matching” in the editor. In the editor you may find what parenthesis/bracket matches another one by simply positioning the cursor after a bracket. The actual bracket and its match will highlight. Note that this feature will work with any string – whether valid SQL or not. Both plain parenthesis’es, square brackets and curly braces are supported (independently of each others).
* If “save password” is checked for a connection, then focus in Connection Manager will be on the connection name – else it will be on the password. Before focus was always on password when Connection Manager was opened.
* User Management now fully supports MySQL ‘anonymous users’. Actually SQLyog never did before and the 8.6 betas crashed when trying to manage such (versions before 8.6 could not create such users but did not crash when managing them). Now both username and hostname may be left as an empty string. A confirmation popup will appear, though.
* Improved performance by optimizing code when SQLyog was internally performing string comparisons (what it does a lot).

Bug fixes:
* Fixed a GDI leak occurring when switching between TABS in the GUI (editor TABS or connection TABS).

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

Comments(0)

Changes (as compared to 8.6 beta2) include:

Features:
* The new User Management dialog (introduced in beta1) is now resizable.
* Added options to filter on ‘%value’ and ‘value%’ in both the ‘Filter’ menus and ‘Custom Filter’ dialogs.
* All TIME datatypes (also (YEAR(2)) are now fully supported with sorting and filtering in RESULT tab. Year(2) will sort like 70..99..00..69 (like the server itself does).
* CTRL+INS and SHIFT+INS keyboard shortcuts will now copy and paste (like CTRL+C and CTRL+V) in GRIDS.

Bug fixes:
* When opening a ANSI-encoded file with non-ASCII characters the encoding would not be detected correctly, and the content would garble (no issue with UTF8 and (Windows) UTF16-encoded files).  This bug was introduced in 8.3.
* SQL exports added redundant Unix-linebreaks, what would cause some editors to display an empty line.  This bug was introduced in 8.4.
* Fixed some minor bugs with custom filter in RESULT tab.
* The Windows Explorer dialog for selecting files to be opened could display garbage characters at the beginning with non-English locales. The reason was SPACE characters incorrectly added by SQLyog.
* SQLyog could crash when connecting from ‘import external data’ wizard to a source database with a huge number of tables in it.

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

Comments(0)

This release ports a single critical bug fix from the newly released 8.55 release to the current 8.6 beta/development tree:  If user edited data in RESULT-tab GRID and changed from Edit Mode to Read Only mode without saving, the UPDATE statement would omit the proper WHERE-clause. As a consequence all rows would be updated. This bug was introduced in 8.4. All users using 8.4 or higher should upgrade due to this serious bug.

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

Comments(2)

Changes (as compared to 8.54) include:

Bug Fixes:
* If user edited data in RESULT-tab GRID and changed from Edit Mode to Read Only mode without saving, the UPDATE statement would omit the proper WHERE-clause. As a consequence all rows would be updated. This bug was introduced in 8.4. All users using 8.4 or higher should upgrade due to this serious bug..
* Sorting and filtering on YEAR-type columns in RESULT tab did not work.  Now it works with YEAR(4), but with YEAR(2) it still does not with this release.
* A connection tab/window can now be closed even if there is only one connection (this fix is backported from 8.6 beta release).
* Fixed an issue with Schema Sync when source and target differed in both columns and Foreign Keys. Sometimes the ALTER script would only specify the FK-changes to target (also this fix is backported from 8.6 beta release).

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

Comments(0)

Changes (as compared to 8.54) include:

Features:
*User Management is completely redesigned and rewritten. Now privileges on all levels – as well adding/deleting/renaming users and changing passwords – are managed from the same interface – an expandable tree view. Also GRANT and REVOKE syntax is now used (before the MySQL privileges tables were manipulated directly).
* Added a ‘custom filter’ option in DATA and RESULT tab GRIDs. With this option, user can filter on any value from any cell.
* A connection tab/window can now be closed even if there is only one connection

Bug fixes:
*In text-mode, columns in DATA and RESULT tab would not align properly with non-ASCII characters. We were basically counting bytes – not characters. This is now fixed. But note that alignment issues may still happen in special cases with some non-western scripts in cases where the font itself prints more characters with the width of a single character.
* Fixed an issue with Schema Sync when source and target differed in both columns and Foreign Keys. Sometimes the ALTER script would only specify the FK-changes to target.
* Fixed some bugs when migrating default values from SQL server using Import External Data. Issues were occurring with specific default values and datatypes.
* Terminating a job from SJA wizards was not killing the PLINK process used for SSH-tunneled connection.
* The dialog for defining ENUM/SET properties only appeared after clicking the ‘length’ cell from CREATE/ALTER TABLE. Now it pops up as soon as user has selected the ENUM/SET type.
*The output in the MESSAGES tab is restructured to make the output more readable when multiple queries are executed.
* Other small GUI fixes.

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

Comments(4)

Changes (as compared to 8.53) include:

Bug fixes:
* With many servers/connections registered in SQLyog the drop-down list in the connections dialog would flicker. The flickering was introduced in 8.5.
* Query Formatter was not handling queries of size greater than 2 KB. Now the size is increased to 8 KB. The 2 KB limitation was introduced in 8.18.
* Import of data from .xlsx files from Excel 2007+ was failing with double-precision datatypes.
* Update-check failed if SQLyog was running behind a HTTP-proxy.  The settings will now be detected.  However proxies requiring authentication are not handled with this release.

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

Comments(0)