dbForge Studio for MySQL Express Changelog

What's new in dbForge Studio for MySQL Express 10.0.225

Mar 28, 2024

Fixed the issue of losing encoding for string values in the Edit Parameters dialog (D137643)
Resolved the problem with auto-formatting of the SET keyword (D146817, D146945)
Fixed a syntax error that occurred when using the MEMBER alias (D145758)
Fixed a MySQL server connection error that occurred when using the SSL Cipher List parameter (D44734)
Fixed the issue that prevented table editing for queries involving JOIN operations in the Data Editor (D142512)
Resolved an issue that occurred when attempting to open a connection to the server while editing script parameters in the SQL Document (D143370)
Fixed the Lost connection to MySQL server during query error in the stored procedure editor (D140829, D142484)
Improved the behavior of retrieving metadata about database objects under restricted privilege conditions (D124636, D146241)
Fixed an error that occurred during script parsing in the SQL document (D148387, D144939)
Fixed errors that occurred during query editing in Query Builder (D146447, D145795, D148954, D144365)
Fixed an issue with unnecessary quotation marks being added to values when copying data from the Data Editor (D146052)
Fixed an issue related to computing the insertion position for elements from the Member List (D144939)
Added support for the Mroonga engine in the syntax checking (D144399)
Significantly improved the performance of parsing queries containing a large number of JOIN operations (D143714)
Fixed an issue that occurred when applying the decimal separator during the export of floating-point numbers (D141328, D57700)
Improved the behavior of the Execute Current Statement and Execute To Cursor commands during script parsing when it's not possible to evaluate the script fragment for execution. Now, users will be notified when executing the command is not possible (D137430, D138188, D138189)

New in dbForge Studio for MySQL Express 10.0.150 (Jan 18, 2024)

Code Completion & Syntax Check:
Added support for START, STOP, SHOW and RESET REPLICA statements
Added full support for FLUSH command
DDL generator:
Added option Include triggers to DDL generator
Added Include DEFINER clause and Include SQL SECURITY clause options instead of Exclude DEFINER and SQL SECURITY clauses option
Others:
Added connectivity support for MariaDB 11.4
Upgraded from legacy chart designer to advanced new version
New Alt + Up/Down Arrow shortcuts for navigating script differences in the lower comparison pane in Schema Compare
User-reported and internal bug fixes:
Fixed an issue with ANSI_QUOTES that occurred during the compilation of procedures for debugging
Fixed issues that occurred during the synchronization of schemas into project files
Fixed syntax check issues that caused various malfunctions and improved the diagnostics of such issues
Fixed an issue that occurred when comparing object scripts to display differences
Fixed an issue with the execution of Commit and Get Latest from the shortcut menu of Database Explorer
Implemented the restoration of tables being edited in Data Editor in case of the execution of multiple SELECT queries
Fixed an issue in Object Search that occurred when searching for objects whose names contain the underscore character
Improved the object renaming functionality for users with limited permissions
Fixed an issue with editing string values in columns in Data Editor
Fixed an issue with displaying empty values in Data Editor
Fixed an issue that occurred when retrieving table metadata in Data Editor
Fixed an issue that occurred during the repeated execution of a SELECT query in Data Editor
Improved the selection of server connection in Object Editor when navigating between objects by name from SQL Document
Fixed an issue that occurred during the repeated execution of a query in SQL Document
Fixed an issue that occurred when pasting multiline text into a grid cell in Data Editor
Fixed an issue that occurred when opening the Tables node in Database Explorer with the 'Allow uncommitted objects discovery' option enabled
Fixed a syntax error in queries that join subqueries
Fixed an issue that occurred when running a comparison after saving a .scomp document
Fixed an issue that occurred when opening and editing documents in a project
Fixed an issue that occurred when changing a column name in Table Editor
Implemented the recovery of triggers when rebuilding a table in the editor
Fixed an issue with the generation of package DDL
Improved error diagnostics in Document Outline
Fixed the incorrect restoration of open documents
Fixed an issue that occurred when opening a project
Fixed an issue with applying the 'Use cached update mode by default' option
Fixed an issue with reading LOB
Fixed an issue with launching the application via CrossOver

New in dbForge Studio for MySQL Express 10.0.60 (Nov 20, 2023)

New in dbForge Studio for MySQL Express 9.2.128 (Sep 14, 2023)

New in dbForge Studio for MySQL Express 9.2.105 (Aug 17, 2023)

New in dbForge Studio for MySQL Express 9.2.5 (Apr 19, 2023)

Connectivity:
Added support for MariaDB v11.3 (D113571, D114332, D115079, D115266, D115522, D115532)
Added support for Support for Aiven Cloud
Added support for SHA-256/512
Text Editor:
Enhanced code completion for application-period temporal tables
Added support for a broader range of optimizer hints
Added support for the VALUES ... ORDER BY ... LIMIT statements
Added support for the TABLE statement
Added support for the EXCEPT and INTERSECT statements
Added support for spatial functions ST_LineInterpolatePoint, ST_LineInterpolatePoints, ST_PointAtDistance and ST_Collect (D116307)
Added the ability to show/hide the additional view in SQL Document using the Ctrl+R shortcut (p172754)
Query Builder:
Added support for sequence tables in Query Builder (D106459)
Other Improvements:
Added support for the UUID Data Type (D86002, D104539, D113090)
Added support for the INET6 Data Type
Added support for MySQL functional indexes (D91702, D104198, D116539, D116539, D106204)
Added the ability to save and load filters in Database Explorer
Improved the charset comparison behavior in Schema Compare
Added quoting of function names being used as table names
User-reported and internal bug fixes:
Fixed metadata retrieval for MariaDB 10.6 and higher versions, and also removed the temporary workaround of setting the session system variable OLD_MODE to UTF8_IS_UTF8MB3 (D73426)
Fixed an error with incorrect server-side conversion of object names to lowercase (D106061)
Fixed an error that occurred when opening the Object Privileges tab in Security Manager (D117760)
Fixed an issue with saving formatting options to the registry (D108023)
Fixed an error that occurred when establishing the plink connection (D109982)
Fixed an issue with displaying object privileges in Security Manager (D110260)
Fixed an issue with saving SSH parameters in the Database Connection Properties window (D108759)
Fixed an error that occurred when establishing a connection in Security Manager (D109871, D110106)
Fixed an issue with retrieving the list of the unique keys columns in Database Explorer (D117975)
Fixed an issue with creating data reports via the command line (D106881)
Fixed an error that occurred with retrieving metadata for the procedure parameters (D105124, D105127)
Fixed an error that occurred when switching between the Grid View and Card View modes in Data Editor (D111269)
Supported the precision value outside the range for the TINYINT type in Schema Compare (D114677)
Fixed an error with opening a connection when repeatedly executing queries in SQL Document (D76206)
Fixed the Query Builder error (D99166, D105438)
Fixed the behavior of setting the Empty String value to a grid cell in Data Editor (D98979)
Fixed an issue with establishing a connection (D92507)
Fixed an issue with retrieving the list of database objects for the object tree in Backup Wizard (D95727)
Fixed an error that occurred when opening the SSH connection (D96538)
Fixed an issue with retrieving table data and closing the connection when working with Data Export (D96301)
Fixed an issue with retrieving metadata that occurred when using the Database Refactoring functionality (D92324, D108224, D108223)
Fixed a project build error that could occur when using window functions in scripts (D105388)
Fixed an error that occurred when generating the procedure script (D105550)
Fixed an error that occurred when generating a partitioned table script (D103972)
Resolved an issue where a part of the script could be mistakenly included in the comment while formatting (D103836)
Resolved an issue with formatting Boolean literals (D102810)
Fixed the Query Builder error that could occur when using the IN operator (D99248, D100896, D102812, D103890, D105776, D105818, D106453, D107239, D108230, D110776, D110775, D110796, D113188, D113187, D113186, D113417, D114489)
Fixed an issue where unnecessary users were created when building the project (D97627)
Fixed the comparison of default column values (D105686)
Added support for COLLATE and CHARSET in the RETURN expression in the function declaration (D97571)
Fixed a project build error that occurred when using CHARSET expressions in scripts (D96804, D97515)
Fixed a describe table error that could occur when using indexes (D100451, D100735, D108017)
Improved error diagnostics in Schema Compare (D88802, D108657, D112371)
Fixed an error for geometric data types (D117182)
Resolved an issue with application freezing that occurred when formatting complex view scripts (D114045)
Fixed an index describe error on older server versions (D112402, D113474)
Fixed an error that could occur when closing documents (D111897)
Fixed the generation of trigger scripts on computers with non-English locales (D106873)
Fixed the generation of table scripts (D105686)
Added support for the 'omit anti-spoofing prompt after authentication' option for the plink connections (D102896)
Fixed an error that occurred when opening SQL Editor during script generation in Data Generator (D113530)
Improved the security of username display (D112569)
Fixed an error that occurred when closing the application (D110505)
Fixed an error that occurred when synchronizing MEDIUMTEXT data in Data Compare (D104903)
Improved the behavior of editing procedures and functions (D102644, D102841, D103971)
Fixed the behavior of managing connections in the SQL document (D103386)
Fixed synchronization of auto_increment columns (D102972)
Fixed an error that occurred when starting the application (D102869)
Fixed an issue with document recovery after reopening the application (D105620)
Fixed an error that occurred when creating a procedure with a temporary sequence (D99696)
Resolved an issue with access to the license file (D98720, D100518, D100517, D103220, D103362, D103806)
Improved the application startup performance (D91185, D96141, D88553, D91620, D91185)
Fixed a system error in the graphics subsystem (D97919, D106437)
Fixed an error that occurred when displaying the tooltip window in the Text Editor (D95396, D101253, D103675, D112759)
Resolved an issue with opening the Table Editor in Crossover (D96371, D98198, D101222, D102631, D102835, D102960, D103223, D103463, D103991, D104676, D104979, D110176, D115237, D117447, D117964, D118316)
Fixed an error that occurred when creating database documentation (D96911)
Fixed an error that occurred when saving documents for recovery (D95381, D97151, D96859, D96530, D97355, D110731, D99726, D108097, D114007, D117825)
Improved the behavior of executing procedures for users with limited privileges (D93314)
Fixed an error that could occur when dragging and dropping objects onto the database diagram (D51650, D82417, D110806)
Fixed an error that occurred when editing check constraints (D115614)
Resolved issues with parsing scripts containing hieroglyphs (D113661, D113644)
Fixed an error that occurred when debugging stored routines with error handlers that call the FOUND_ROWS function (D111281)
Fixed a freezing issue that could occur when working with Documenter - Studio, Documenter (D111195)
Fixed syntax checking errors (D109833, D11056, D103967, D78508)
Fixed an error that occurred when working with Query Builder (D105645, D113594)
Fixed an issue with exporting data to an Excel table (D107416, D98748)
Improved the algorithm for converting object names to their original case during formatting (D103470, D91820)
Fixed an error that occurred when executing queries that call the JSON_TABLE function (D100370)
Resolved an issue with processing paths to project files (D91703)
Fixed an error that occurred when importing data from JSON files (D93929, D104253)

New in dbForge Studio for MySQL Express 9.1.21 (Aug 30, 2022)

New in dbForge Studio for MySQL Express 9.1.8 (Aug 12, 2022)

General:
Added support for Linux and macOS via CrossOver
Added connectivity support for MariaDB 10.9
SQL Document:
Added support for RETURNING in JSON_VALUE statements
Added formatting options for CREATE EVENT and ALTER EVENT
Database Explorer:
Added the editing of PACKAGE, PACKAGE BODY in SQL documents
Schema Compare:
Improved the comparison and synchronization of integer datatypes on MySQL 8.0 and Percona 8.0
Object Editor:
Added support for ASC and DESC sorting of index columns
Improvements:
Added custom configuration for toolbars and fixed an issue with the loss of custom toolbar settings (D89306)
Improved bulk data insert in the Cached Updates mode in Data Editor (D89926)
Improved the behavior that saves the list of connections after they get renamed or relocated in Database Explorer (D86092)
Improved the behavior of editing data in tables with INVISIBLE columns in Data Editor
Improved the behavior of the connection timeout error processing (D76206)
Improved the loading of connections and connection categories (D78267)
User-reported and internal bug fixes:
Fixed an issue that occurred when creating a new user under insufficient privileges in Security Manager (D91676)
Fixed an issue that occurred when opening the view editor in Database Diagrams (D89225)
Fixed an issue that occurred when pasting text to a SQL document in the Studio running under Remote Desktop (D88338, D91066, D91132, D92284, D93637)
Fixed an issue that occurred when switching to Card View in Data Editor (D84099)
Fixed an issue that occurred when opening a new connection (D92551)
Fixed the restoration of the parameter values of stored procedures and functions for repeated execution in Object Editor (D87205)
Fixed an issue with the incorrect ordering of stored procedure and function parameters in Object Editor
Fixed the 'Unable to cast COM object' issue for the Microsoft Access data format in data import (D80180)
Fixed the behavior of the data comparison module (D90322)
Fixed an issue with switching to the standby mode when moving columns in the query editor (D73681, D92084)
Fixed a column comparison issue that occurred when comparing data (D80383, D86934, D86933)
Fixed an issue that occurred when exporting Execution History to the CSV format
Fixed the behavior of inserting text to SQL Editor (D88338, D91066, D91132, D92284, D93637)
Fixed an issue that occurred when canceling export to the Excel format (D88791, D91693)
Fixed the behavior of saving custom toolbars (D89306)
Fixed an issue that occurred when displaying a Query Builder diagram upon opening a saved .design file
Fixed an issue that made it impossible to save changes in the procedure editor if there was an INSERT statement in the script (D92002)
Fixed a syntax issue with the IN operator (D92224)
Fixed a syntax issue that occurred when using the SET_VAR hint (D88968)
Fixed a search issue in Data Editor (D89218)
Fixed an issue with generating an invalid default value for columns of the date datatype (D88182, D88713, D88906)
Fixed an issue with using JSON functions in Query Builder (D87240, D90007)
Fixed an issue with Query Builder that occurred when adding columns to GROUP BY while using aggregate functions (D85500)
Fixed an issue that occurred when comparing two tables containing foreign keys (D82524, D87457, D94403)
Fixed an issue that occurred when opening the table editor (D81815)
Fixed an issue that occurred when closing the Studio (D81853)
Fixed an issue that occurred when opening a synchronization script (D81958, D91562)
Fixed an issue that occurred when opening an invalid .rdb file
Fixed an issue that occurred when debugging a script
Fixed an issue that occurred when renaming objects in Database Explorer (D72868)
Fixed an issue that occurred when working with long aliases in Query Builder (D89333, D89332, D90070, D91692, D91733, D91736, D91751, D92339, D92536, D93315, D94205)
Fixed a data import issue (D91481)
Fixed the behavior of hints on servers with the 'lower_case_table_names = 2' setting
Fixed Debugger behavior issues (D89193, D89031, D91528, D91985, D91988)
Fixed issues that occurred when scripting objects whose names match the names of preinstalled server functions (D89363, D77752)
Fixed issues that occurred when working with Query Builder (D89333, D89332, D90070, D91692, D91733, D91736, D91751, D92339, D92536, D93315, D94205, D88217, D88554, D88315)
Fixed an issue that occurred when formatting a script in a document
Fixed an issue that occurred when working in Documenter (D82145, D90977)
Fixed an issue that occurred when mapping columns in the data import wizard (D79295)
Optimized the data update process during the repeated execution of queries in Data Editor (D88407)

New in dbForge Studio for MySQL Express 9.0.897 (May 20, 2022)

New in dbForge Studio for MySQL Express 9.0.894 (May 18, 2022)

New in dbForge Studio for MySQL Express 9.0.890 (May 12, 2022)

Improvements:
Improved the behavior of determining the dimension of numeric types for the parameters of procedures and functions (D73292)
Improved the tab activation behavior when executing queries in a SQL Document (D76851)
Improved the SSH Protocol configuration form to display the Local port option (D75981)
Improved the behavior of the Studio to work around a server error using hyphenation in procedure and function comments (D75638)
User-reported and internal bug fixes:
Added a query timestamp in the General output window (D75287, D78442)
Changed the opening behavior of the trigger editor and implemented the capability to view the script from SHOW CREATE TRIGGER (D78463)
Enhanced the execution performance of metadata queries and improved the support for object names with different cases for Unix systems (D73426, D73485)
The compiler now factors in the ANSI_QUOTES mode when saving a procedure compiled for debugging (D85538, D85537, D85664, D85665)
Fixed an unexpected exception that occurred when generating data for the foreign key columns (D61140)
Fixed an unexpected exception that occurred when describing data for Schema Compare (D76988)
Fixed an unexpected exception that occurred when creating a script in the Data Report Wizard
Fixed an unexpected exception that occurred after selecting the Use Regular Expression option in the Data Compare Wizard (D54972)
Fixed file error that occurred after exporting data to the .xlsx format (D65759)
Fixed an unexpected exception that occurred when importing data from a text file with no content (D71358, D71359)
Fixed an unexpected exception that occurred when exporting data with nullable values â€‹â€‹via ODBC provider (D75249, D75475, D75640)
Fixed an unexpected exception that occurred when closing a SQL document during query profiling
Fixed an issue that occurred when starting the application (D54073)
Fixed an unexpected exception that occurred when opening the application options editor window (D66452, T315964, T317130)
Fixed a bug where after renaming a table column in Database Explorer, no changes were displayed in the table editor (p200130)
Fixed an unexpected exception that occurred when launching the Data Generation wizard (D72307)
Fixed an unexpected exception that occurred when loading the Data Report file
Fixed an unexpected exception that occurred when generating the Tooltip for the connection node
Fixed an issue with the Next and Previous keywords in the trigger script (D82957)
Fixed an issue in the text editor on Windows builds 22567 and higher (D81729, D81730)
Fixed an error that occurred when renaming a procedure with a long name (D76977)
Fixed an issue with the Splash window (T321527)
Fixed an error that occurred when saving a SQL Document to a network drive (D76829)
Fixed the control rendering error 'Arithmetic operation resulted in an overflow' (D83365, D83094, D82790, D75641, D76700, D79304, D79299, D79284, D79391, D79513, D79538, D79647, D79795, D80052, D82265, D82390, D82645, D83232, D83328, D83354, D83415, D83488, D83488, D83553, D83806, D83978, D84261, D84261, D84309, D84497, D84597, D84630, D84633, D84904)
Fixed an issue with getting the procedures and functions metadata (D74780, D74782, D74781, D74783, D74806, D75289, D75805, D76493, D77598, D777791, D78100, D81817, D81893, D81960, D82277, D83125, D83300, D835900, D836V)
Fixed the generation of scripts with BULK INSERT (D73106)
Fixed an error that occurred when opening the context menu (D67415)
Fixed the comparison and synchronization of foreign keys and indexes associated with foreign keys
Fixed an issue with the tool's windows activation (T309559, T310394, T309631)
Fixed an issue with closing the application (D72911)
Fixed an error that occurred when executing the query containing the '/' symbol (D63962)
Fixed an error that occurred when opening the Style menu in Documenter (D54079)
Fixed the connection opening error in a SQL Document (D69979, D83775)
Fixed an error that occurred when selecting a connection in the Project Explorer window
Fixed an error that occurred when executing a request (D65909)
Fixed an issue with calling the object editing window from the Search window (D70832, D66412)
Fixed a bug that could occur when switching between pages in the comparison wizard
Fixed an error that occurred when working with permissions in database projects (D77870)
Fixed an error that occurred when working with the procedure parameters (D75638)
Fixed an issue with the synchronization of objects with the enabled NO_ZERO_DATE, NO_ZERO_IN_DATE options (D80408)
Fixed a bug that could occur when closing the application (D80352)
Fixed a critical application error (D58203)
Fixed the behavior of index synchronization (D70389)
Fixed schema comparison behavior (D76098, D73000, D76098)
Fixed an error that could occur when comparing a database with a script folder (D74083)
Fixed an issue with object script generation (D75427)
Fixed a bug that could occur when setting a breakpoint
Fixed issues caused by false syntax errors (T325249, D72828, D56047, D73574, D73593, D74726, D76485, D77098, D75695, D76420, D82654, D84159, D84851)
Fixed the suggestion of types for the CAST function
Fixed errors that could occur when specifying a list of view columns for schema comparison (D71544)
Fixed critical bugs related to the parsing of long calculated expressions and multiple unions (D74042, D82634, D83823, D83997, D76586, p206266, D76612, D74042, D83997, d82635, d76612)
Fixed an issue with renaming objects in a script (D75618)
Fixed the loss of procedure parameter values â€‹â€‹between debug sessions (D77708)
Fixed an error that could occur when debugging a procedure with the LONG type parameter (D78488)
Fixed the loss of breakpoints during procedure debugging (D75638, D76971, D77193)
Fixed an issue with saving changes in database object editors (D76029)
Fixed an issue with exporting VARBINARY data type to Google Sheets (p205834)
Fixed an issue with handling queries containing syntax errors in Query Builder (D77579, D84159)
Fixed a text editor bug on Windows builds 22567 and higher (D81675, D81730, D81712, D81713, D81699, D81463, D81105, D81428, D81674, D80821, D81556, D81203, D81193, D81500, D81199, D81213, D81214, D81106, D81200, D81209 , D81916, D82123, D81292, D82633)
Fixed docking error when working on 4k monitors (D81179)

New in dbForge Studio for MySQL Express 9.0.791 (Dec 9, 2021)

New in dbForge Studio for MySQL Express 9.0.782 (Dec 1, 2021)

Improvements:
Added support for the following syntax constructs: ARRAY, MEMBER OF, JSON_TABLE, JSON_ARRAYAGG
User-reported and internal bug fixes:
Fixed an unexpected exception during the operation of the code completion module (Z54288)
Added the analysis of the BOM (Byte Order Markers) availability when opening files with a suggestion to normalize such files (Z61421)
Fixed an issue with data export to an Excel file that occurred when the dataset exceeded 66,000 lines
Fixed an issue that occurred during data import due to incorrect initialization of the charset and collations for a new table (Z56315)
Fixed an issue that occurred during data import from a JSON file (Z52978)
Fixed an unexpected exception that occurred when updating the caret position in the document editor (Z66260)
Fixed the incorrect behavior of the "Hide unmodified columns" option in the Data Comparison document (Z61620)
Fixed a data presentation format issue that occurred during data export
Fixed an issue that occurred when connecting under a user with limited permissions (Z57726)
Fixed an unexpected exception that occurred during data export from ODBC due to data type incompatibility (Z54558)
Fixed a product activation error that occurred during a delayed response of the activation server (Z63688)
Fixed a primary key synchronization issue (Z61421, Z64728)
Fixed an issue that occurred during data import via a template (T318611)
Fixed a synchronization issue for a table with PARTITION BY RANGE COLUMN (Z61090, Z65799)
Fixed a procedure script generation issue (Z57488)
Fixed an issue that occurred when creating a project (T321191, Z55142)
Fixed memory leaks that occurred during data import (Z50446)
Fixed a product activation issue that involved Arabic characters
Fixed a synchronization issue for a table with partitioning (Z69398, Z69399)
Fixed the behavior of the Limit Bulk Size option in Data Compare (Z63729)
Implemented the display and editing of the original object text in the procedure and function editor
Fixed an issue that occurred when using data filtering in Data Editor (Z66370)
Fixed an issue with the repeated execution of a query in Data Editor (Z66775)
Fixed an issue that occurred when canceling query execution in a SQL document (Z49158)
Fixed an issue with the paginal mode in Data Editor (T320575, Z53989)
Fixed an issue with connection to a database in a SQL document (T317258)
Fixed selection criteria in queries that retrieve metadata for security objects (Z52448)
Fixed an issue that occurred when retrieving a charset in the view editor (T322504)
Fixed the behavior of setting up user permissions in Security Manager (Z56370, Z61740)
Improved the behavior of saving the database connections list when using the Studio repeatedly (Z58499, Z70053)
Fixed the background color application error that occurred during data export to the Excel format (Z54552)
Fixed an issue that occurred when launching the application and accessing the Object Viewer (Z64176, Z71606)
Fixed an issue that occurred when processing scripts containing syntax in versioned comments (T308096)
Fixed an issue with the partial loss of expressions during formatting (Z54833, Z54833)
Fixed the inclusion of a false error to the log (Z53187)
Variable parsing now complies with the documentation (Z61624)
Added support for the varcharacter[(n)] data type when parsing scripts with the MariaDB syntax (Z61496)
Fixed the behavior of change markers in SQL Editor (Z61421)
Fixed the selection of encoding when writing synchronization scripts to a file (Z61421)
Fixed an issue with the syntax check for SELECT expressions with multiple UNION operators (Z61421)
Fixed an issue that occurred when closing the Studio (Z53013, Z54226)
Fixed an issue that occurred when retrieving a list of view columns (T316141, T316833, Z71544)
Fixed an issue that occurred when using a drop-down list (Member List)
Fixed a false syntax check that hindered the compilation of stored procedures for debugging (Z69005)
Fixed the behavior of the view editor during detection of syntax errors (Z70532)
Fixed a false syntax check that hindered the comparison of views
Improved the behavior of query execution using the utf8mb3 charset for MariaDB 10.6 (Z71703)

New in dbForge Studio for MySQL Express 9.0.689 (Oct 20, 2021)

New in dbForge Studio for MySQL Express 9.0.688 (Sep 8, 2021)

New in dbForge Studio for MySQL Express 9.0.665 (Aug 5, 2021)

New in dbForge Studio for MySQL Express 9.0.660 (Jul 28, 2021)

New in dbForge Studio for MySQL Express 9.0.636 (Jul 8, 2021)

New in dbForge Studio for MySQL Express 9.0.597 (May 25, 2021)

New in dbForge Studio for MySQL Express 9.0.567 (Apr 22, 2021)

Improvements:
New commands added to Data Viewer (Z50371)
Behavior of grouping, sorting, and filtering data in Data Editor (T321143)
Informational message added instead of an unexpected exception when importing data from invalid Excel files (T316195)
Supported processing of FOR and END FOR constructions (Z47250)
Optimized synchronization of changes in virtual columns (T324676)
User-reported and internal bug fixes:
Issue related to Drag & Drop of nodes in Database Explorer (Z53086, Z53076)
Error when retrieving data in Data Editor (T316866)
Error in Database Diagram (T316167)
Error when opening Object Editor (T315817)
Bug when renaming an object with refactoring (T320870)
Issue related to MS Access database in Data Import (T321264)
Error when opening the Database Diagram document (T322224)
Issue with a warning about unique keys in Data Editor (z50892)
Issue with a connection to Azure MySQL when using Azure Active Directory (Z48896)
Freeze issue in Data Editor (T323805)
Issue with displaying the DEFAULT values of functions in Table Editor (T323858)
Issue related to ANSI_QUOTES when generating DDL objects
Issue related to renaming objects with refactoring without full privileges (Z48669)
Incorrect behavior when importing data: now the default value for table columns when generating a script is taken into account (Z50193)
Incorrect behavior when exporting data: float data export as a string (Z49439, T322185) (T322420)
Unexpected exception while generating data (T322529)
Error when exporting data to the Excel format (T318221)
Incorrect highlighting for changes preview nodes when renaming (T321735)
Issue with floating point types (float, real, double) incorrectly handled by the code parser in certain cases (T325803)
Issue with a possible application crash during status bar updates (T312009)
Failure to detect caret position when suggesting code snippets due to fatal error (T317401, T324642, T318869, Z52386, T320328, T324088)
Number of exceptional cases when renaming objects (T317567)
Possible errors when parsing queries due to the incorrect handling of built-in date and time functions (T322366)
Possible unrecoverable error when trying to get hardware info for analytics (T323703, T323745)
Issue with possible compilation failure for specific procedures due to critical error (T325068, T324902)
Possible application freeze when scrolling through large scripts (Z49867)
Incorrect code parser behavior when handling specific subqueries (Z50521)
Application failure with critical error after renaming the table added to Query Builder (Z51168)
Critical error when searching through any Data Report document (T322171)
Possible errors after calculating context for code completion suggestions (Z51364, Z53055, Z53362, Z51262)
Issue with currently active document window not being focused after closing the Find and Replace panel (Z51941)
Possible application crash when caching document content for restoring (Z51925)
Error when comparing stored procedures (T324195)
Issue with a request to server metadata (Z52448)
Error in ignoring spaces through the command line when working with options (Z50899)
Error in finding dependencies when working with quoted object names (Z50238)
Error in reading table partitioning settings (T272704, Z48568)
Critical error when quitting the application (T310099, T310273, T310370)
Critical error when processing versioned comments (T308096)

New in dbForge Studio for MySQL Express 9.0.505 (Feb 8, 2021)

Improvements:
More informative error outputting in Restore Database Wizard
UI with notification text when refactoring objects is enhanced (T317956)
Improved display of tags for source objects in Documenter (T318901, T325153)
The mechanism of reading metadata for events and triggers containing underscore in names on MariaDB Server is modified (T321493)
Support for the utf8mb4_0900_ai_ci coding is added (T321580)
User-reported and internal bug fixes:
Issue with freezing in the foreign keys editor (T321088)
Behavior with formatting the procedure body when refactoring objects
Issue with unclosed connection to MySQL server in SQL document (T320522)
Error when inserting the DATETIME value into Data Editor
Error when inputting an incorrect value on the Security tab of Connection Manager (T320462)
Connection to MariaDB Server via the PAM authentication (T320376)
Error when opening a document in Database Diagram (T319872, Ð¢323510, Ð¢324250)
Error when switching to the Read-only mode in Data Editor (T315627, T319005)
Application was unable to profile queries when connected to Percona Server for MySQL 8.0.21 (T322314)
Syntax Checker reported errors for parameters and variables that started with numbers (T321364)
Possible critical errors when preparing quick info for items from the completion list (T320678)
Syntax Checker failed to process union syntax in specific cases (T319796)
Code Formatter did not work for certain queries that contained object names that match keywords
Issue with the import date: "When importing, there is no way to assign a default value for a column." (T321686)
Issue with the import date: "When importing a CSV into an existing table, the program creates a MySQL error in the query it generates." (T322420)
Throwing an unhandled exception when importing some types of the .xlsx files (T314153)
Reading metadata when working with users and roles (T310432)
Incorrect script generation when working with an auto-increment column (T320632)
Critical error when analyzing the required order of columns (T316340)
User formatting is taken into account when synchronizing the function parameters (T317375)
Loss of foreign keys without names during synchronization (T320929)
Critical error when generating comparison report (T320848)
Error occurred when closing comparison wizard is fixed (T324719)

New in dbForge Studio for MySQL Express 9.0.470 (Nov 26, 2020)

New in dbForge Studio for MySQL Express 9.0.435 (Oct 9, 2020)

Improvements:
Behavior of metadata retrieving when dragging and dropping a table in Query Builder (T314046)
Behavior of displaying empty values for the JSON data types in Data Editor
Behavior of incorrect retrieving of constraints in Data Editor (T314423)
Behavior of modifying the comment text when changing the letter case (T314767)
Behavior of identifying unique keys when changing the editable table in Data Editor (T315797)
Behavior of displaying object lists in Object Viewer (T314050)
Behavior of the Not Null tag of a column in Table Editor (T312215)
Behavior of renaming a query in Data Report
User-reported and internal bug fixes:
Error in Database Diagram when opening a .dbd file
Error in the View editor after closing a document
Error with displaying the Search (Find Objects) window when Database Explorer was absent (T312512)
Error with copy-pasting in Data Editor
Error with formatting the DATETIME value in Data Editor (T312665, T315522)
Error with rendering values in Data Editor (T313623)
Error with the progress tab of Restore Ð¸ Execute Large Script Wizard (T313785)
Error with selecting an editable table in Data Editor
Error with updating objects in Query Builder (T314231)
Error with the undoing operations for linked tables in Query Builder (T310715)
Working with column types for Turkish encoding (T316473)
Error with displaying the context menu of an object in Database Diagram (T315113)
Work of Data Import for Google Spread Sheets (T314984)
Error with saving a procedure in Database Diagram (T313856)
Error with reading the Google Sheets data in Data Import (T314178)
Error of overflow when executing a SELECT query with LIMIT OFFSET
Bug when generating data for tables with foreign keys (T312605)
Issue with using the documentation on case sensitive operating systems (T317028)
Error with opening text dictionary in Data Generator
Error when generating a SQL Profiler document and closing Studio
Displaying warnings as an error in Data Generator
Incorrect generation of table columns if their names coincided with the reserved words in CRUD
Incorrect error processing in Database Project (T315373)
Error when analyzing index dependencies (T318093)
Notification on possible data loss in certain cases of comparing the TINYINT types
Missed calls of user scripts when assembling a database project (T318011)
Critical error during syntax check of CREATE ROLE (T318011)
Incorrect reading of the DEFAULT values if it was not specified as CURRENT_TIMESTAMP () (T317941)
Incorrect reading of the DEFAULT values for the JSON type (T310136)
The â™ character was inserted instead of the ` character when typing Alt+96 in the SQL editor (T317183)
Incorrect behavior of syntax check feature for MODIFY keywords within the ALTER TABLE clause (T318406)
The application failed with a fatal error when trying to compile procedures containing identifiers with digital prefixes for debugging (T317744, T316666)
Possibly incorrect scrip generation within Query Builder for queries containing date and time functions
The 'AS NEW()' syntax was treated as invalid within INSERT statements (T314777)
Incorrect CRUD and SELECT scripts generation for tables containing columns with names matching words that are reserved

New in dbForge Studio for MySQL Express 9.0.391 (Aug 17, 2020)

New in dbForge Studio for MySQL Express 9.0.338 (Aug 17, 2020)

New in dbForge Studio for MySQL Express 9.0.304 (May 15, 2020)

Connectivity:
Connectivity support for MariaDB 10.5 is added.
Display of server type in the Property window for MySQL, MariaDB, Percona, Amazon, Alibaba Cloud, and Tencent Cloud is added.
Display of server type in the Connections section of the System window for MySQL, MariaDB, Percona, Amazon, Alibaba Cloud, and Tencent Cloud is added.
Database Connection Properties and Test Connection windows are redesigned.
Connectivity support for SkySQL is added.
New features and improvements:
Database Design
The Find Invalid Objects feature is implemented.
Support for new objects
Working with the Packages and Sequences established in MariaDB 10.3 is supported.
SQL Document
nowarn and -- endnowarn tags have been added to the Execution warnings functionality.
Exporting execution history in the CSV file format is added.
Code Completion
Code completion is available in the body of triggers and events.
Data Editor
Cached Updates mode is implemented.
Schema Compare
Scripts Folder comparison is added.
Object Filter is implemented.
Schema Comparison Report window is redesigned.
HTML reports are redesigned.
Pre and post script execution during data synchronization
Ignore DEFINER and SQL SECURITY clauses option is modified.
Ignore row format table option is added.
Ignore AUTO_INCREMENT option is added.
DDL Diff control is redesigned.
Data Compare
Scripts Folder comparison is added.
Data Compare control is redesigned.
Data Comparison Report window is redesigned.
Pre and post script execution during data synchronization
Option to append timestamp to the name of the data sync script file is added to Data Synchronization Wizard.
Option to set default values is added to Data Synchronization Wizard.
Data Generator
Pre and post script execution during data population.
Database Backup
Option to disable reference tables from the backup is added.
Data Export and Import
Output tab is added to Data Import Wizard and Data Export Wizard.
Data Export, CSV tab is added to the Options window.
Display of selected data export format is added to all tabs of Data Export Wizard.
Other Improvements:
Command line prompt is expanded with a full list of available exit codes.
Activation of the tool via the command-line interface is implemented.
User-reported bug fixes:
Problem with precision for Update Timestamp on MariaDB 10.3 is fixed (T308074)
Problem with generating CREATE script 'curdate()' with quotes is fixed (T291580)
Problem with generating null is fixed (T305946)
Problem with error on backup is fixed (T306368)
Problem with increment update is fixed (T305660)
Problem with displaying multi-line comments is fixed (T302702)
Problem with scrolling fields is fixed (T306452)
Problem with error exporting .rdb report to DOCX is fixed (T297220)
Problem with options editing format is fixed (T303784)
Problem with Restore running is fixed (T286122)
Problem with "find and replace" window is fixed (T276631)
Problem with comparing projects and databases is fixed (T275714)
Problem with displaying warnings in Output is fixed (T274188)
Problem with displaying property AUTO_INCREMENT is fixed (T274234)
Problem with completion list in case of using JOIN is fixed (T267254)
Problem with highlighting error is fixed (T168164)
Problem with displaying of controls for 4K monitors is fixed (T170777, T178589, T179019, T179922, T181573, T200641)
Problem with generating backup scripts is fixed (T262371, T289756)
Other user reported bugs are fixed (T304700, T303372, T304446, T303784, T303489, T303493, T298032, T287765, T292618, T294439, T293607, T286741, T293282, T307549, T290262, T289774, T281791, T281405, T281405, T283707, T283443, T282407, T286087, T276599, T110356, T307583, T272555, T274127, T268888, T284077, T269644, T269389, T294286, T268112, T262328, T304183, T267421, T266303, T266092, T219152, T215877, T205999, T228108, T252627, T252936, T257937, T260282, T198222, T279106, T302623, T256317, T262169, T260727, T308878, T286087, T309067)
8.2.23 05-Aug-19

New in dbForge Studio for MySQL Express 8.2.23 (Aug 5, 2019)

New in dbForge Studio for MySQL Express 8.2.21 (Jul 30, 2019)

New in dbForge Studio for MySQL Express 8.1.45 (May 7, 2019)

New in dbForge Studio for MySQL Express 8.1.22 (Jan 15, 2019)

New in dbForge Studio for MySQL Express 8.0.124 (Nov 21, 2018)

New in dbForge Studio for MySQL Express 8.0.108 (Oct 18, 2018)

New in dbForge Studio for MySQL Express 8.0.80 (Aug 13, 2018)

New in dbForge Studio for MySQL Express 8.0.40 (Jun 21, 2018)

New in dbForge Studio for MySQL Express 7.4.201 (Apr 4, 2018)

New in dbForge Studio for MySQL Express 7.4.184 (Mar 27, 2018)

SQL Document:
Transaction Reminder
Execution notications
Сolor effect of current code line
Code Completion:
Code folding for BEGIN … END for IF
Prompting Percona Server variables (CL, QI and Parameter Info)
Prompting MySQL Server variables
Prompting variables for MariaDB Server
Prompting Optimizer Hints
Prompting Geographic Functions
Prompting Extended JSON Functions
Prompting values for TABLE_TYPE
Prompting Multiple-Clustering-Indexes for TokuDB Engine
Prompting Cast(… AS JSON)
Prompting CHANGE MASTER TO
Prompting CHANGE REPLICATION FILTER
Prompting ALTER INSTANCE
Prompting ALTER USER CURRENT_USER
Prompting SHOW CREATE USER
Prompting RESET MASTER
Prompting CREATE [OR REPLACE] … [IF NOT EXISTS]
Prompting Spatial Reference systems
Prompting Compound Statements Outside Of Stored Programs
Prompting SET DEFAULT ROLE … FOR
Prompting VIR virtual table type for CONNECT engine
Prompting SET ROLE
Prompting CONNECT engine supports
Prompting SPIDER ENGINE
Prompting START TRANSACTION
Prompting RELEASE_ALL_LOCKS() and ANY_VALUE()
Prompting CREATE TABLE
Prompting Ngram and mecab Full-Text Parser
Query Builder:
Reorganized aggregate functions
Data Viewer:
Improved Spatial Viewer
Corrected Data Types in the Data Editor Columns Header
Data Export and Import:
Export to Google Sheets and Import from Google Sheets
Data Export to SQL with Bulk Option
Schema Compare:
New Schema Comparison and Synchronization Engine
Formatting of DDL objects in Diff View of Schema Comparison Document
A lot of new Schema Comparison Options are added
Redesigned Schema Synchronization Wizard
A lot of new Schema Synchronization Options are added
Improved comparison and synchronization progress
Data Compare:
Some new Data Comparison Options are added
Some new Data Synchronization Options are added
Improved comparison and synchronization progress
Data Generator:
New Data Population Options
Copy Database:
Finished Copying Notification
Command-Line Interface
Other Improvements:
Improved Product Update Manager
Digital signature for the installation file
Support for SHA256 Authentication when connecting to MySQL
User reported bugs fixed:
Partitions synchronization issue is fixed (T37187)
json_value in views issue is fixed (T251390)
Unexpected dialog issue is fixed (T248969)
Trigger code issue is fixed (T251193)
Index was out of range issues are fixed (T179124, T209927, T249509, T250308, T251726)
Find and replace issue is fixed (T216441)
Code Debugger issue is fixed (T128109)
Ignore Partitions option is added (T244105)
Date format in Data Viewer issues are fixed (T242075, T248157)
The third level in popup menu is added (T245734)
Background Check for update issues are fixed (T245437, T245444, T245751)
Problems with hint in Data Editor are fixed (T213935, T241687, T242762, T244935)
Some PowerShell issues are fixed (T246378)
Some High DPI and 4k resolution issues are fixed (T204521, T213237, T214526, T217767, T224612, T228109, T228108, T236831, T243911, T216585)
JSON functions are supported (T198906)
Data lookup by foreign key in Data Editor issue is fixed (T245498)
Problem in dependences between View in database backup and restore is fixed (T242295)
Problems with incorrect datatypes view in data grid caption are fixed (T178729, T185938, T233868)
Problem with Icon of an open Connection is fixed (T241441)
Application hang issues are fixed (T241836, T242227, T242948, T244495)
Problem with JSON is fixed (T246035)
Problems with parsing in Query Builder are fixed (T216731, T218093, T219285)
TIMESTAMP NULL DEFAULT for MariaDB 10.1 is supported (T240135)
Problem in Restore Database Wizard is fixed (T243901)
Problem in database backup is fixed (T246361)
Foreign Key in Generate Script issue is fixed (T98876)
Option Ignore Foreign Key Rule is added (T224980)
Option Ignore Character Set and Collation is added (T234555)
Lost privilege after synchronization issue is fixed (T147793)
Table size in Database Explorer checkbox is added to application options (T231700)
Begin Transaction, Commit, Rollback buttons are added to the Database Explorer Toolbar (T241593, T248009)
Other user reported bugs are fixed (T243136, T154742, T220501, T250553, T244211, T244105, T249182, T249522, T249169, T224304, T177762, T244315, T245071, T185498, T241776, T244493, T227930, T240768, T245060, T236565, T242124, T250992)

New in dbForge Studio for MySQL Express 7.3.148 (Feb 20, 2018)

New in dbForge Studio for MySQL Express 7.3.137 (Jan 15, 2018)

New in dbForge Studio for MySQL Express 7.3.131 (Dec 7, 2017)

Enterprise Edition with several exclusive features is introduced:
Data Generator allows generating test data and instantly populating your database with it
Database Documenter is a tool for generation of database documentation in HTML, PDF, and Markdown file formats
With Copy Database, you can copy a set of databases by generating and running a script
Connectivity:
Support for MariaDB 10.1
Support for MariaDB 10.2
Support for MariaDB Galera Cluster 10.0 Series
Support for Google Cloud Platform
Support for Alibaba Cloud
Support for Azure MySQL
Server version is displayed when testing a connection
New Table Engines:
Support for TokuDB
Support for RockDB
Support for NDB Cluster
Data Export/Import
Support for JSON data:
Redesigned XML data import/export
Preview of the generated UPDATE script in the Data Import wizard
Detection of column type when importing data from the Excel format
SQL Document:
CTRL+W shortcut for closing current tab
Opening new tabs next to current one
CTRL+N shortcut for opening new SQL window with inherited server and database of the current window
Display the connection coloring in the status bar
Now every document creates its own connection
The Close All Unmodified Tabs command
Format Document (CTRL+K+D) command in the shortcut menu of SQL document
Closing of connection to MySQL Server when it is not being used
Query navigation
Improved query text parsing
Redesigned query execution history
Data and Schema Comparison:
Support for data conversions allows performing more complete and precise data comparison
Ignore 'n' and 'rn' during schema compariion option is added
Script Generation:
Ability to generate script as CRUD
Database Backup and Data Export:
Database Backup Wizard and Data Export Wizard allow encrypting data with AES256
Other Improvements:
Trial product activation
Greatly improved visual style of the application with high DPI support
Support for PowerShell
Specific exit codes for command-line are added
Compliance with the Federal Information Processing Standard (FIPS)
Redesigned Generate Script As option
Optional exclusion of databases from the completion list
User reported bugs fixed
Schema Compare issues are fixed (T211159, T211618, T211834, T213946, T214003, T216161, T217109, T217721, T221073, T92338, T235991, T233606, T227836, T223945, T216586, T214246, T211159, T211618, T211834, T213946, T214003, T216161, T217109, T217721, T221073, T92338, T204440, T225748, T230878, T235758, T204440, T225748, T230878, T235758)
Data Compare issues are fixed (T236415, T223708, T229629, T117849)
Code Completion issues are fixed (T238337, T239559, T239741, T237925, T237915, T228024, T230117, T230831, T228412, T230869, T234742, T234904, T235072, T239763, T164191, T221981)
Code Debugger issues are fixed (T236120, T235902, T214399, T212838, T212301, T204922)
Data ExportImport issues are fixed (T239286, T226800, T135692)
Data Generator issues are fixed (T218965, T214247, T213706, T197645, T167476, T173058)
Database BackupRestore issues are fixed (T234658, T232324, T222373)
Database Explorer issues are fixed (T227392, T213250, T118647)
Database Projects issues are fixed (T235904, T208306)
Object Editors issues are fixed (T164191, T206503, T171092, T197524, T139859)
SQL Formatter issues are fixed (T234395, T234069, T214757, T221420)
SQL Document issues are fixed (T205625, T205863, T208070, T211882, T214195, T220634, T225261, T226528, T232048, T227151, T201634)
Database Diagram issues are fixed (T233868, T226710)
Other user reported bugs are fixed (T239425, T238504, T237777, T228466,T230554, T233637, T228809, T231420, T226776, T225688, T220809, T219610, T219695, T215895, T227785, T213746, T168536, T179285, T211050, T208307, T212740, T198231,T237891, T239438, T204727, T203459, T199339, T217167, T197430, T196345, T215388, T230995, T170314, T162951, T167185, T168353, T168603, T168706, T168963, T148024, T136477, T121314, T196712, T228464, T199288)

New in dbForge Studio for MySQL Express 7.2.78 (Jul 27, 2017)

New in dbForge Studio for MySQL Express 7.2.76 (Jul 22, 2017)

New in dbForge Studio for MySQL Express 7.2.58 (Apr 6, 2017)

New in dbForge Studio for MySQL Express 7.2.53 30-Nov-16 (Dec 27, 2016)

New in dbForge Studio for MySQL Express 7.2.50 29-Nov-16 (Dec 27, 2016)

New in dbForge Studio for MySQL Express 7.2.34 10-Nov-16 (Dec 27, 2016)

New features and improvements:
The Database Search tool has been completely redesigned for optimal search of both objects and data
Visual Object Editors have been totally redesigned
Redesigned Table Maintenance wizard
Improved SQL document parser performance
Connection through Named Pipe implemented
Improved XML View and new JSON View for Data Editor and Viewer Window
Additional SQL statements are supported (T187713)
Syntax Check supports new MariaDB 10.0 - 10.1 statements
Styled icons are used by default
User reported bugs fixed:
SQL Document issues are fixed (T172883, T170496, T170657, T170658, T171035, T171119, T171171, T171358, T172047, T172177, T172347, T172491, T172529, T172813, T172819, T172860, T173321, T173388, T173541, T173902, T174088, T174189, T174361, T174501, T174735, T174849, T175163, T175361, T175410, T175607, T176062, T176333, T176695, T177759, T178102, T178126, T178142, T178249, T179232, T179847, T180034, T180154, T180158, T181197, T181512, T182119, T182210, T184208, T184503, T184558, T184679, T184814, T185168, T185192, T185218, T186194, T186233, T187174, T187362, T187744, T187984, T187984, T179770, T168373, T170778, T188130)
Query Builder issues are fixed (T165625, T166837, T167884, T171061, T171232, T178390, T179850)
Code Completion issues are fixed (T188385, T187713, T177066)
Code Debugger issue is fixed (T186674)
Data Compare issue is fixed (T188721)
Data Editor and Viewer issues are fixed (T182362, T187164, T175105, T173068, T178729, T185938, T165924, T160960)
Data ExportImport issues are fixed (T192786, T191551, T179580)
Database BackupRestore issues are fixed (T182854, T182133, T120273)
Database Projects issues are fixed (T187982, T187819)
Object Editors issues are fixed (T164191, T169663, T169343, T174613)
Schema Compare issues are fixed (T194500, T117290, T184623, T169662)
Session Manager issues are fixed (T177351, T181276)
SQL Formatter issues are fixed (T179386, T170714)
Syntax Check issue is fixed (T187713)
SSH connection issue is fixed (T118405)
Layout issues are fixed (T174813, T177477)
Other user reported bugs are fixed (T130092, T164459, T170444, T174440, T189057, T182066, T180592, T180074, T180087, T181842, T181843, T182529, T183680, T183744, T182854, T184159, T184448, T185377, T186515, T186668)

New in dbForge Studio for MySQL Express 7.1.31 30-Sep-16 (Dec 27, 2016)

New in dbForge Studio for MySQL Express 7.1.30 27-Sep-16 (Dec 27, 2016)

New in dbForge Studio for MySQL Express 7.1.29 23-Sep-16 (Dec 27, 2016)

New in dbForge Studio for MySQL Express 7.1.26 19-Sep-16 (Dec 27, 2016)

New in dbForge Studio for MySQL Express 7.1.20 13-Sep-16 (Dec 27, 2016)

New in dbForge Studio for MySQL Express 7.1.13 27-Apr-16 (Dec 27, 2016)

New in dbForge Studio for MySQL Express 7.0.54 23-Mar-16 (Dec 27, 2016)

New in dbForge Studio for MySQL Express 7.0.52 14-Mar-16 (Dec 27, 2016)

New in dbForge Studio for MySQL Express 7.0.49 29-Feb-16 (Dec 27, 2016)

New in dbForge Studio for MySQL Express 7.0.46 26-Feb-16 (Dec 27, 2016)

Support for MySQL 5.7:
Support for the PASSWORD EXPIRE option in Security Manager
Support for computed columns
Support for the JSON Data Type
Support for Spatial Indexes
Other features and improvements:
Support Percona PAM authentication
Support for the Amazon Aurora connection
User reported bug fixes:
Issue with viewing data comparison details is fixed (T123743)
Issue with Generate Script As for table is fixed (T123977)
Issue with saving 'Look In' option in Find and Replace window is fixed (T122242)
NullReferenceException while executing Report template through CLI with parameters is fixed (T126198)
Issue with report generation trough command line is fixed (T128900)
Issue with copying columns from one table to another is fixed
Some issues with debugger are fixed
Issue with connection via SSH is fixed (T133379, T133780, T135203, T144325, T156321, T157597)
IndexOutOfRangeException while opening SecurityManager on MySQL 5.7.x is fixed (T138146, T141443, T141640, T151208, T154251, T157386, T157580, T158368, T158801, T157480)
Issue with text replacement using regular expression is fixed
'Current Document' is selected by default in Find and Replace window
Issues with Session Manager are fixed (T148676)
Issue with saving Snippets Folder is fixed (T138878)
ArgumentException during data comparison is fixed (T140016)
ArgumentException while trying to unlock removed connection is fixed (T140709, T145293)
Sending data report via CLI to several email addresses is supported (T140722)
NullReferenceException while creating a database is fixed (T141444, T145727)
Issue with query profiling is fixed
Issue with ignoring foreign key during schema comparison is fixed (T130146)
NullReferenceException when browsing to the last rows on the data view in Express edition is fixed (T146205)
Exception while executing a query is fixed (T148670)
Issues with connection to MySQL 5.7.x is fixed (T152158, T152648, T152709, T153183, T153489, T154109, T158606, T159165, T159384, T159417, T159468, T159601)
Issue with Save Changes button in Security Manager is fixed (T151866)
COLUMN_GET expressions are recognized correctly (T152603)
ArgumentException while lost connection is fixed (T140016)
NullReferenceException while saving database objects is fixed (T153915, T156551)
Bug when using CAST or CONVERT in stored procedure is fixed (T154606)
Viewing functions in GROUP BY are correct (T155234)
InvalidOperationException while debugging is fixed (T157468)
SQL compile error is fixed (T157498)
Text of the message while renaming a columns is correct (T158492)
Default path for log is changed
Exception while importing databases or trying to backup them is fixed (T159255)
Minor issues are fixed (T159322, T150989, T150361, T154089, T146978, T138878)

New in dbForge Studio for MySQL Express 6.3.358 03-Jun-15 (Dec 27, 2016)

New in dbForge Studio for MySQL Express 6.3.341 30-Jan-15 (Dec 27, 2016)

New in dbForge Studio for MySQL Express 6.3.339 23-Jan-15 (Dec 27, 2016)

New in dbForge Studio for MySQL Express 6.3.337 5-Jan-15 (Dec 27, 2016)

New in dbForge Studio for MySQL Express 6.3.330 25-Dec-14 (Dec 27, 2016)

New in dbForge Studio for MySQL Express 6.3.325 19-Dec-14 (Dec 27, 2016)

New in dbForge Studio for MySQL Express 6.3.323 (Dec 10, 2014)

New in dbForge Studio for MySQL Express 6.2.277 (Dec 10, 2014)

New in dbForge Studio for MySQL Express 6.2.234 (Dec 10, 2014)

New in dbForge Studio for MySQL Express 6.1.166 (Dec 10, 2014)

New in dbForge Studio for MySQL Express 6.1.164 (Dec 10, 2014)

New in dbForge Studio for MySQL Express 6.1.154 (Dec 10, 2014)

New in dbForge Studio for MySQL Express 6.1.142 (Dec 10, 2014)

New in dbForge Studio for MySQL Express 6.1.137 (Dec 10, 2014)

New in dbForge Studio for MySQL Express 6.0.622 (Dec 10, 2014)

New in dbForge Studio for MySQL Express 6.0.568 (Dec 10, 2014)

New in dbForge Studio for MySQL Express 5.0.97 (Jul 24, 2012)

New in dbForge Studio for MySQL Express 5.0.82 (Jun 15, 2012)

New in dbForge Studio for MySQL Express 5.0.76 (May 22, 2012)

New in dbForge Studio for MySQL Express 5.0.72 (Apr 30, 2012)

New in dbForge Studio for MySQL Express 5.0.67 (Mar 1, 2012)

New in dbForge Studio for MySQL Express 5.0.63 (Jan 13, 2012)

New in dbForge Studio for MySQL Express 5.0.60 (Dec 6, 2011)

New in dbForge Studio for MySQL Express 5.0.54 (Nov 9, 2011)

New in dbForge Studio for MySQL Express 5.0.50 (Nov 3, 2011)

New in dbForge Studio for MySQL Express 5.0.48 (Nov 3, 2011)

New in dbForge Studio for MySQL Express 5.0.40 (Nov 3, 2011)

New in dbForge Studio for MySQL Express 5.0.37 (Nov 3, 2011)

New in dbForge Studio for MySQL Express 5.0.36 (Nov 3, 2011)

New in dbForge Studio for MySQL Express 5.0.33 (Nov 3, 2011)

Extra spaces on formatting SQL statements are fixed (T28282)
The default value for TIMESTAMP columns is CURRENT_TIMESTAMP now (T28536)
Problems with formatting CASE clauses are fixed (S12776963)
ArgumentException on trying to compile tables, views, triggers, or events is fixed (T28355, T28365, T28836)
ObjectDisposedException on working with autohidden tool windows is fixed (T28329)
IndexOutOfRangeException on minimizing and restoring the appilication is fixed (T28344)
Lost connection on executing SLEEP function in SELECT statements is fixed (S12783291)
Application hanging on working with unresponsable server is fixed (S12782055)
ExternalException on operating clilbpoard operation in LOB Editor is fixed (T28373)
ArgumentOutOfRangeException on displaying view in Object Viewer is fixed (S12791783)
Automatic diagram layout on its openning is fixed (S12828929)
The problem with changing configuration in database project is fixed (S13035917)
"Object doesn't exist in the current context" message on synchronizing or building a project is fixed (S13037877)
Incorrect object describing with ANSI server mode is fixed (T28591)
The problem with synchronization timeout on debugging procedures is fixed (T28388)
FormatException on exporting data to CSV with custom DATE delimiters is fixed (S13040337)
NullReferenceException on showing data in Data Editor is fixed (T28478, T28837)
InvalidOperationException on synchronizating schema of some procedures is fixed (T28615)
The problem with exporting data from DECIMAL columns is fixed (T28367)
NotImplementedException on refreshing triggers collection in Database Explorer is fixed (T28363)
The problem with bad handshake on connecting to a server is fixed (T28747)
FormatException on exporting decimal column to CSV is fixed (S13043575)
ArgumentOutOfRangeException on importing data from MS Excel is fixed (T28755)
Application hanging on openning a big SQL file with enormous count of JOIN clauses is fixed (T28716)
The problem with showing Code Completion window for SUM() function is fixed (S12744935)
Incorrect detection of default table engine on some MySQL server versions is fixed (R124)

New in dbForge Studio for MySQL Express 5.0.30 (Nov 3, 2011)

New in dbForge Studio for MySQL Express 5.0.28 (Nov 3, 2011)

Support for MySQL server 5.5
Our product is fully compatible with MySQL server version 5.5
New features were added and obsolete clauses removed in the Syntax check functionality
New encodings were added to the encoding list in the Connection Properties dialog
New kinds of partitioning are supported in the table editor
Master-detail Browser
Explore and analyze master-detail data in a convenient browser with the following features:
Design view allows building relations between tables with setting where condition and fetch limit, choosing fields for output, and sorting them by default
Data of the parent table/view is shown in the upper part of the Data view to allow analyzing data of child tables/views without extra navigation.
The document allows saving and loading data and diagram for future use
Sorting and filtering data in the Data view
Ability to analyze self-referencing tables
Object dependency tree - unique feature
Easily explore object's references and dependants in Database Explorer.
Compilation of dependants for debugging is now also available through the object's context menu.
Enhanced Data Editor
Newly added features and a few totally redesigned ones provide even more freedom when working with data.
Foreign Key lookup editor added
Server-side sorting and filtering implemented to avoid retrieving all data from the table and enhance work in Paginal Mode
A few indications added to inform user about Data Editor's state
Editing of tables in join statements is enabled now
Option for numbering records added
Copy data with header functionality added
Ability to build graphical representation of your data with fully functional wizard added
Improved Security Manager
Ability to edit permissions for several users added
Virtual roles for users were added to allow granting a definite set of permissions to selected users
Grouping by hosts in the users list tree added
Editing users and working with Security Manager window simplified
Data Export and Import improvements
Ability to export data from several tables at once added
Exporting data from command line added
Importing data from command line added
Object Viewer - a simple way to view object's details
Object Viewer (formerly known as Summary Window) was totally redesigned to provide an easier way for analyzing objects and their structure:
There are three views to display properties, DDL (text), and data of the selected object
Inner navigation through object hierarchy
History with previously viewed objects
More information about each object is displayed in the Properties view now
Brand new start page
New functional start page providing the easiest way to learn the product's features and to run the most frequently used ones added.
New state-of-the-art skins
Four new UI skins added to improve the application appearance.
Other improvements
Ability to view internal SQL queries that are sent to the server with parameter's values added
A few UI improvements in Database Explorer were made
Options to ignore clauses during the comparison of events added to the Schema Comparison wizard
Highlighting of differences on comparing SQL profiling results added
More informative progress during Schema and Data comparison

New in dbForge Studio for MySQL Express 4.50.348 (Apr 4, 2011)

New in dbForge Studio for MySQL Express 4.50.342 (Mar 17, 2011)

New in dbForge Studio for MySQL Express 4.50.339 (Mar 3, 2011)

New in dbForge Studio for MySQL Express 4.50.335 (Feb 19, 2011)

New in dbForge Studio for MySQL Express 4.50.334 (Feb 17, 2011)

New in dbForge Studio for MySQL Express 4.50.331 (Feb 14, 2011)

New in dbForge Studio for MySQL Express 4.50.321 (Jan 20, 2011)

New in dbForge Studio for MySQL Express 4.50.316 (Jan 5, 2011)

New in dbForge Studio for MySQL Express 4.50.315 (Dec 23, 2010)

New in dbForge Studio for MySQL Express 4.50.313 (Dec 9, 2010)

New in dbForge Studio for MySQL Express 4.50.311 (Oct 28, 2010)

New in dbForge Studio for MySQL Express 4.50.308 (Oct 21, 2010)

New in dbForge Studio for MySQL Express 4.50.306 (Oct 21, 2010)

New in dbForge Studio for MySQL Express 4.50.303 (Aug 17, 2010)

New in dbForge Studio for MySQL Express 4.50.300 (Aug 17, 2010)

New Features:
Product Tour has been totally redesigned to provide more flexible navigation to topics.
User reported bug fixes:
T12461 incorrect results of Code Refactoring in database project
T20514 Stopping Code Debugger do not stop it
CR53409 Problem with updating view after saving
CR53449 Query Profiler must show date of profiling result in local format
CR53463 Cannot delete primary key on a column with autoincrement from Database Explorer
CR53472 Disable changing project configuration when building project
CR53497 Problem with backing up through the command line after lost connection
CR53501 InvalidOperationException on executing script in SQL document
CR53573 Unavailable documentation in Schema Compare wizard
T16516 Persistent modification marker in trigger editor after trigger saving
T16516 Problem with temporary procedure on procedure editing
CR53593 NullReferenceException after clearing all in the Where editor in Query Builder
T20339 All routines run twice after session killing
CR53640,CR53641,CR53643,CR53645 Problems with database projects
CR53644 NullReferenceException on getting new results in Query Profiler if the document was opened with the loaded database project
CR53646 Why the Refresh button is disabled after reopen SQL document?
T20888 NullReferenceException on refreshing data in Data Editor
CR53678 Hide password in log file on backing up database
CR53709,CR53719 Problems with navigating to result of data search
CR53720 Do not save opened document views in SQL document
T21284 Display System.Byte[] instead of default values of table columns on MySQL 4.1.x
T10942 Add option to ignore query cache on query profiling
CR53767 Problems with query profiling on MySQL 4.1.x
CR53792 Support relative path of log file in Database Backup Wizard
T21587 When exporting a table or backing up a database, date column is improperly exported/created
CR53843 Current statement marker hides on breakpoint removing
CR53852,53859 Breakpoint in code editor doesn't synchronize with Breakpoints window
CR53853 Problem with code debugger on procedure renaming

New in dbForge Studio for MySQL Express 4.00.300 (Jul 27, 2010)

New Features:
Product Tour has been totally redesigned to provide more flexible navigation to topics.
User reported bug fixes:
T12461 incorrect results of Code Refactoring in database project
T20514 Stopping Code Debugger do not stop it
CR53409 Problem with updating view after saving
CR53449 Query Profiler must show date of profiling result in local format
CR53463 Cannot delete primary key on a column with autoincrement from Database Explorer
CR53472 Disable changing project configuration when building project
CR53497 Problem with backing up through the command line after lost connection
CR53501 InvalidOperationException on executing script in SQL document
CR53573 Unavailable documentation in Schema Compare wizard
T16516 Persistent modification marker in trigger editor after trigger saving
T16516 Problem with temporary procedure on procedure editing
CR53593 NullReferenceException after clearing all in the Where editor in Query Builder
T20339 All routines run twice after session killing
CR53640,CR53641,CR53643,CR53645 Problems with database projects
CR53644 NullReferenceException on getting new results in Query Profiler if the document was opened with the loaded database project
CR53646 Why the Refresh button is disabled after reopen SQL document?
T20888 NullReferenceException on refreshing data in Data Editor
CR53678 Hide password in log file on backing up database
CR53709,CR53719 Problems with navigating to result of data search
CR53720 Do not save opened document views in SQL document
T21284 Display System.Byte[] instead of default values of table columns on MySQL 4.1.x
T10942 Add option to ignore query cache on query profiling
CR53767 Problems with query profiling on MySQL 4.1.x
CR53792 Support relative path of log file in Database Backup Wizard
T21587 When exporting a table or backing up a database, date column is improperly exported/created
CR53843 Current statement marker hides on breakpoint removing
CR53852,53859 Breakpoint in code editor doesn't synchronize with Breakpoints window
CR53853 Problem with code debugger on procedure renaming