Softpedia >Windows >Internet >Servers >Database Utils >SQL Manager Lite for MySQL >  Changelog

SQL Manager Lite for MySQL Changelog

What's new in SQL Manager Lite for MySQL 5.7.1 Build 51495

Jul 18, 2018
  • Improved support of high-DPI monitors and large-scale fonts.
  • Some improvements in dark color scheme implemented.
  • SSL connection without keys and certificates was not established. Fixed now.
  • Datetime fields were not displayed in Export data wziard. Fixed now.
  • Search of objects has been fixed.
  • Extract of functions and procedures with REPEAT loop has been fixed.
  • The error of using views in Query Builder has been fixed.
  • Text is now replaced correctly in SQL editors.
  • SQL Editor was not restored on re-openning the program. Fixed now.
  • Transactions for data were not disabled in some cases. Fixed now.
  • The error on printing diagrams in Visual Database Designer has been fixed.
  • Many other improvements and bug-fixes.

New in SQL Manager Lite for MySQL 5.7.0 Build 50823 (Mar 1, 2018)

  • New icons introduced. Support of dark visual scheme added.
  • Support of Unicode added for object names.
  • Support of Access 2016 files implemented in Import data and Export data wizards.
  • Export as PHP wizard. PHP Data Objects interface supported now.
  • BLOB data and binary data are exported as Base64 and HEX strings for text formats.
  • Duplicate wizard didn't copy data in some cases. Fixed now.
  • Fixes for syntax highlighting in procedures and functions.
  • Fixes in autocompletion of keywords.
  • Displaying of time in Greek locale has been fixed.
  • Many other improvements and bugfixes.

New in SQL Manager Lite for MySQL 5.6.1 Build 47667 (Aug 17, 2016)

  • Support of latest OpenSSH versions implemented.
  • Added shortcut for finding objects in DB Explorer tree.
  • The "SELECT command denied" error occured on creating a new procedure. Fixed now.
  • The error on exporting Decimal values to MS Excel files has been fixed.
  • The EXPLAIN command did not work for selected text. Fixed now.
  • The Access Violation error on database comparison occured in some cases. Fixed now.
  • Export of autoincrement fields with custom sorting has been fixed.
  • The default shortcut for "Set to Null" has been changed at the Data tab.
  • Some other improvements and bug-fixes.

New in SQL Manager Lite for MySQL 5.6.0 (Aug 17, 2016)

  • JSON type support added.
  • Multiple result sets are now supported in SQL Editor.
  • Timeout settings for connection and metadata lock waiting have been added.
  • Search/replace features have been optimized in SQL editor.
  • Extract Database and Copy Database. Triggers can be selected separately from tables now.
  • Added support of latest OpenSSH versions.
  • Excessive connect/disconnt operations when connecting to a database have been eliminated.
  • Wrong applying of default database charset has been fixed.
  • Data displaying errors in BLOB Editor have been fixed.
  • Tabs were not renamed in Visual Database Designer. Fixed now.
  • ENUM type was implemented incorrectly as function return type. Fixed now.
  • Fixed the error of assigning permissions to objects having the '.' (dot) in their names.
  • The function text was incorrectly formatted. Fixed now.
  • The null date was copied to clipboard incorrectly. Fixed now.
  • Many other improvements and bug-fixes.

New in SQL Manager Lite for MySQL 5.5.3 (Aug 17, 2016)

  • Fixed the critical error occured while applying the filter in grid.
  • There was an error when opening the 'Print Preview' dialog in Query Builder. Fixed now.
  • The behavior of the Code Completion window appearing was enhanced.
  • Sorting of fields in Table Editor has been fixed.
  • On connection to the database using SSH the passphrase was requested twice. Fixed now.
  • Fixed the child windows saving in the 'Floating Windows' mode.
  • Duplicating of the table data using SSH-tunnel was incorrect. Fixed now.
  • There were errors executing some queries containing specific date-functions. Fixed now.
  • The constraints were not considered while exporting the data from SQL Editor. Fixed now.
  • The 'Print Metadata' report name was added to support some PDF-printers.
  • Lots of other improvements and bug-fixes.

New in SQL Manager Lite for MySQL 5.5.2 (Aug 17, 2016)

  • Generating of the table definition (DDL) has been fixed for tables having the dot (".") in their names
  • Opening of procedures for the users with restricted rigths has been fixed
  • There was a critical error when launching the program on the specific versions of Windows. Fixed now
  • The print preview window for the view was not opened. Fixed now
  • The size of the wizard windows has been fixed for the specific font sizes (DPI)
  • The order of scripts addind fields to a table was incorrect. Fixed now
  • Displaying of dependencies in the Procedure Editor has been fixed
  • The cursor positioning in tab-delimited text has been fixed
  • Comparing of the AUTO_INCREMENT property for the tables is excluded now
  • Initialization of the DateTime parameters in the Procedure Debugger has been fixed
  • When transactions were enabled the data changes within procedures were not applied. Fixed now
  • The indices comparison has been fixed in Database Comparer
  • The import of unicode data from Excel (.xlsx) files has been fixed
  • Lots of other improvements and bug-fixes

New in SQL Manager Lite for MySQL 5.5.1 (Aug 17, 2016)

  • Code completion window did not appear in some cases. Fixed now.
  • Saving/restoring size of editors was fixed.
  • The error occurred when objects were refreshed for the user with restricted permissions. Fixed now.
  • Drawing of controls was incorrect when large fonts DPI was set. Fixed now.
  • Some mutually exclusive options were applied. Fixed now.
  • There were errors when saved grid levels were restored. Fixed now.
  • Export of the 'date' fields to XLS was fixed.
  • Incorrect logging of queries execution in SQL Editor was fixed.
  • When the specific illegal dates were displayed the errors occurred. Fixed now.
  • Some errors occurred when the program was launched in the 'Floating Windows' mode. Fixed now.
  • The error occurred when the query was executed second time in modal Query Builder. Fixed now.
  • Other improvements and bug-fixes.

New in SQL Manager Lite for MySQL 5.5.0 (Aug 17, 2016)

  • Added the possibility to restore databases from dump files using wizard
  • Added support of microseconds for TIME, DATETIME and TIMESTAMP data types in type editors and data grid
  • Data Export. Large amount of records is now exported without errors
  • Working with database with large amount of objects is significantly improved
  • Added the possibility to rename tables, procedures and functions directly in object editors
  • Added the possibility to set the defaults as CURRENT_TIMESTAMP and ON UPDATE CURRENT_TIMESTAMP for the DATETIME type in the editor
  • ALTER TABLE ... RENAME INDEX statements are now used for renaming index instead DROP/CREATE (for MySQL version 5.7 and higher)
  • Visual Database Designer. Page borders are now displayed on the diagram
  • SQL Editor. ‘Save and restore layout’ option did not work in the result grid in SQL Editor. Fixed now
  • Save settings wizard. SQL Editor queries were exported incorrectly. Fixed now
  • SQL Script. Script highlighting did not work properly for large scripts. Fixed now
  • Data Grid. Now transaction does not begin if it is not supported by a table which prevents the metadata from lock
  • Lots of other improvements and bug-fixes

New in SQL Manager Lite for MySQL 5.4.0 (Sep 24, 2013)

  • The possibility to backup database with mysqldump appeared.
  • Now the table editor for MariaDB servers supports such storage engines as PBXT, Aria, SphinxSE.
  • Such privileges as TRIGGER, CREATE VIEW, SHOW VIEW were added to tables Grant manager.
  • The data export speed increased.
  • In Floating windows mode Visual Database Designer was not opened. Fixed now.
  • The locale formats use for the table representation of data is fixed.
  • When getting the trigger dependencies, the error occurred. Fixed now.
  • When clearing the table, the freeze occurred. Fixed now.
  • When editing scripts with long comments, the errors occurred. Fixed now.
  • At times files from Excel, Access and CSV were imported incorrectly. Fixed now.
  • The representation of large values of BIGINT type in grid view is fixed.
  • Extract Database. Tiriggers are extracted at the end of the script now.
  • When exporting data to Excel files, invalid characters appeared instead of spaces. Fixed now.
  • The input of special Spanish characters is fixed.
  • The support of increased system font appeared in table editor.
  • When restricted users edited the procedures, error occurred. Fixed now.
  • The results of queries with comments at the end were not represented. Fixed now.
  • Lots of other improvements and bug-fixes.

New in SQL Manager Lite for MySQL 5.3.0.2 (May 19, 2012)

  • Added the possibility to update and edit procedures with limited rights to the mysql.proc table
  • Database Comparer tool. Implemented the comparison of all index properties
  • SQL Monitor. The “Log SQL Monitor events to file” option did not work. Fixed now
  • Tables on Unix-servers with different registers were displayed incorrectly. Fixed now
  • Indices Editor:
  • The comment of an existing index could not be changed. Fixed now
  • When trying to change the primary index, an error occurred. Fixed now
  • Opening Instance Manager in the German localization caused the error. Fixed now
  • Field Editor. On some server versions when trying to remove the "Primary key" option, the field change script was generated incorrectly. Fixed now
  • Some other improvements and bugfixes

New in SQL Manager Lite for MySQL 5.1.0.2 (Nov 30, 2011)

  • Added the possibility to register a new database automatically after copying it with the Copy Database Wizard.
  • User Manager. Added the possibility to filter by types of privileges.
  • Dependency tree now parses the dependencies of the whole server.
  • Added the possibility to clear the history of the input parameters.
  • Server Properties. When viewing a list of processes, now it is possible to process a query associated with this process.
  • Some other improvements and bugfixes.

New in SQL Manager Lite for MySQL 4.4.2.1 (Apr 17, 2009)

  • Table Editor.
  • Data filtration is now available when connecting through HTTP tunneling.
  • Unicode is now displayed properly in the DB Explorer.
  • Partial support of OpenGIS fields is implemented.
  • Disabling the 'Use dimension' option in fields of the Double type used to be ignored. Fixed now.
  • Copy Database. Comment length restrictions for tables and fields are now taken into consideration when copying a database whose source and destination server versions differ.
  • Extract Database.
  • With both Add DELIMITER and Generate DROP IF EXISTS statements for objects options enabled, the program used to generate an erroneous result script because of the wrong placement of the DROP statement delimiter. Fixed now.
  • Database structure containing circular table dependencies used to be extracted improperly. Fixed now.
  • If the Record in block option value was “1”, comments were added before each extracted record. Fixed now.
  • If the Client Charset was set at “Windows Charset”, the SET NAMES statement used to get wrong charset. Fixed now.
  • Duplicate View. A view’s name remained unchanged in the result script. Fixed now.
  • Data Export. An attempt to open a file exported to the Excel 2007 format failed with the “Excel found unreadable content in libri.xlsx” error. Fixed now.
  • Trigger Editor. If a user didn’t have the SELECT FROM permission for the mysql.user table then an attempt to edit a trigger failed with an error. Fixed now.
  • Procedure Editor.
  • The procedure used to be edited improperly if its body contained the marker
  • main: Begin
  • …
  • END main
  • Fixed now.
  • The OUT parameter values used to be displayed as NULL when executing a procedure. Fixed now.
  • SQL Editor. Sometimes Ctrl+C and Ctrl+V shortcuts stopped working. Fixed now.
  • In some cases the “Restore Desktop on connection” option did not work. Fixed now.
  • Other minor improvements and bug-fixes.

New in SQL Manager Lite for MySQL 4.2.0.1 (Nov 2, 2007)

  • The Code Completion feature improved
  • Russian and Polish localizations added
  • other improvements

New in SQL Manager Lite for MySQL 4.1.2.1 (Jul 31, 2007)

  • SQL Editor: added a hint listing parameters for added procedures and functions. The hint can be called manually by using Ctrl Shift Space shortcut.
  • Procedure Editor, Function Editor: now it is possible to maximize SQL definition editor window.
  • BLOB Editor now allows one to browse TEXT fields.
  • Extract Database tool runtime has been considerably shortened.
  • All wizards updated: now confirmation prompts pop up when pressing the Finish button repeatedly.
  • In case of HTTP tunneling connection to a database, there was an error in data representation in Table Editor at the Data tab. Now fixed.
  • Fixed the "Illegal mix of collation" error that occurred upon execution of some SQL commands on MySQL 4.1 - 5.0.
  • Print metadata: an error used to occur on attempt to print metadata with �Letter� paper size specified. Now fixed.
  • SQL Script: execution of a sequence of statements like
  • OPTIMIZE TABLE table1, table2;
  • FLUSH TABLES;
  • caused the "out of sync" error. Now fixed.
  • Services | Optimize tables: an error used to occur on attempt to optimize InnoDB tables on MySQL 5.0. Now fixed.
  • Extract database: with the "Login prompt before connection" option set, an error used to occur on attempt to extract data. Now fixed.
  • Program registration behavior corrected: registration information of the older version (SQL Manager 2005) is no longer erased upon SQL Manager 2007 registration.
  • Fixed a bug when SQL Manager Direct feature could not be activated in the Lite version of the program.
  • SQL Editor: quotation marks could not be typed with "USA-International" and "DA - Danish" keyboard layout used. Now fixed.
  • SQL Editor: an opened file was not saved upon clicking "Save to file". Now fixed.
  • SQL Editor: in some cases the fields list did not appear for table alias. Now fixed.
  • A new shortcut Ctrl W has been added to close the active window.
  • Several minor improvements and bug-fixes implemented.

New in SQL Manager Lite for MySQL 3.6.5 (Apr 21, 2006)

  • SQL Editor. Key Mapping is implemented to set the shortcuts for various commands/operations according to your needs.
  • Create Table. Added comment support for tables.
  • Other improvements and bugfixes.