- Added a query timestamp in the General output window (#75287, #78442)
- Changed the opening behavior of the trigger editor and implemented the capability to view the script from SHOW CREATE TRIGGER (#78463)
- Enhanced the execution performance of metadata queries and improved the support for object names with different cases for Unix systems (#73426, #73485)
- The compiler now factors in the ANSI_QUOTES mode when saving a procedure compiled for debugging (#85538, #85537, #85664, #85665)
- Fixed an unexpected exception that occurred when generating data for the foreign key columns (#61140)
- Fixed an unexpected exception that occurred when describing data for Schema Compare (#76988)
- 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 (#54972)
- Fixed file error that occurred after exporting data to the .xlsx format (#65759)
- Fixed an unexpected exception that occurred when importing data from a text file with no content (#71358, #71359)
- Fixed an unexpected exception that occurred when exporting data with nullable values via ODBC provider (#75249, #75475, #75640)
- Fixed an unexpected exception that occurred when closing a SQL document during query profiling
- Fixed an issue that occurred when starting the application (#54073)
- Fixed an unexpected exception that occurred when opening the application options editor window (#66452, 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 (#72307)
- 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 (#82957)
- Fixed an issue in the text editor on Windows builds 22567 and higher (#81729, #81730)
- Fixed an error that occurred when renaming a procedure with a long name (#76977)
- Fixed an issue with the Splash window (T321527)
- Fixed an error that occurred when saving a SQL Document to a network drive (#76829)
- Fixed the control rendering error 'Arithmetic operation resulted in an overflow' (#83365, #83094, #82790, #75641, #76700, #79304, #79299, #79284, #79391, #79513, #79538, #79647, #79795, #80052, #82265, #82390, #82645, #83232, #83328, #83354, #83415, #83488, #83488, #83553, #83806, #83978, #84261, #84261, #84309, #84497, #84597, #84630, #84633, #84904)
- Fixed an issue with getting the procedures and functions metadata (#74780, #74782, #74781, #74783, #74806, #75289, #75805, #76493, #77598, #777791, #78100, #81817, #81893, #81960, #82277, #83125, #83300, #835900, #836V)
- Fixed the generation of scripts with BULK INSERT (#73106)
- Fixed an error that occurred when opening the context menu (#67415)
- 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 (#72911)
- Fixed an error that occurred when executing the query containing the '/' symbol (#63962)
- Fixed an error that occurred when opening the Style menu in Documenter (#54079)
- Fixed the connection opening error in a SQL Document (#69979, #83775)
- Fixed an error that occurred when selecting a connection in the Project Explorer window
- Fixed an error that occurred when executing a request (#65909)
- Fixed an issue with calling the object editing window from the Search window (#70832, #66412)
- 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 (#77870)
- Fixed an error that occurred when working with the procedure parameters (#75638)
- Fixed an issue with the synchronization of objects with the enabled NO_ZERO_DATE, NO_ZERO_IN_DATE options (#80408)
- Fixed a bug that could occur when closing the application (#80352)
- Fixed a critical application error (#58203)
- Fixed the behavior of index synchronization (#70389)
- Fixed an error that could occur when comparing a database with a script folder (#74083)
- Fixed an issue with object script generation (#75427)
- Fixed a bug that could occur when setting a breakpoint
- Fixed issues caused by false syntax errors (T325249, #72828, #56047, #73574, #73593, #74726, #76485, #77098, #75695, #76420, #82654, #84159, #84851)
- Fixed the suggestion of types for the CAST function
- Fixed errors that could occur when specifying a list of view columns for schema comparison (#71544)
- Fixed critical bugs related to the parsing of long calculated expressions and multiple unions (#74042, #82634, #83823, #83997, #76586, p206266, #76612, #74042, #83997, #82635, #76612)
- Fixed an issue with renaming objects in a script (#75618)
- Fixed the loss of procedure parameter values between debug sessions (#77708)
- Fixed an error that could occur when debugging a procedure with the LONG type parameter (#78488)
- Fixed the loss of breakpoints during procedure debugging (#75638, #76971, #77193)
- Fixed an issue with saving changes in database object editors (#76029)
- Fixed an issue with exporting VARBINARY data type to Google Sheets (p205834)
- Fixed an issue with handling queries containing syntax errors in Query Builder (#77579, #84159)
- Fixed a text editor bug on Windows builds 22567 and higher (#81675, #81730, #81712, #81713, #81699, #81463, #81105, #81428, #81674, #80821, #81556, #81203, #81193, #81500, #81199, #81213, #81214, #81106, #81200, #81209 , #81916, #82123, #81292, #82633)
- Fixed docking error when working on 4k monitors (#81179)
9.0.791 09-Dec-21
User-reported and internal bug fixes
- Added support for new privileges during syntax check (p204158)
- Fixed an issue that occurred when generating scripts for tables
- Fixed an issue with reading table metadata (#73494, #3352)
- Fixed an issue with reading session variables when opening a connection (#72728)
- Improved performance when opening a connection
9.0.782 01-Dec-21
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 (#54288)
- Added the analysis of the BOM (Byte Order Markers) availability when opening files with a suggestion to normalize such files (#61421)
- 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 (#56315)
- Fixed an issue that occurred during data import from a JSON file (#52978)
- Fixed an unexpected exception that occurred when updating the caret position in the document editor (#66260)
- Fixed the incorrect behavior of the "Hide unmodified columns" option in the Data Comparison document (#61620)
- Fixed a data presentation format issue that occurred during data export
- Fixed an issue that occurred when connecting under a user with limited permissions (#57726)
- Fixed an unexpected exception that occurred during data export from ODBC due to data type incompatibility (#54558)
- Fixed a product activation error that occurred during a delayed response of the activation server (#63688)
- Fixed a primary key synchronization issue (#61421, #64728)
- Fixed an issue that occurred during data import via a template (T318611)
- Fixed a synchronization issue for a table with PARTITION BY RANGE COLUMN (#61090, #65799)
- Fixed a procedure script generation issue (#57488)
- Fixed an issue that occurred when creating a project (T321191, #55142)
- Fixed memory leaks that occurred during data import (#50446)
- Fixed a product activation issue that involved Arabic characters
- Fixed a synchronization issue for a table with partitioning (#69398, #69399)
- Fixed the behavior of the Limit Bulk Size option in Data Compare (#63729)
- 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 (#66370)
- Fixed an issue with the repeated execution of a query in Data Editor (#66775)
- Fixed an issue that occurred when canceling query execution in a SQL document (#49158)
- Fixed an issue with the paginal mode in Data Editor (T320575, #53989)
- Fixed an issue with connection to a database in a SQL document (T317258)
- Fixed selection criteria in queries that retrieve metadata for security objects (#52448)
- 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 (#56370, #61740)
- Improved the behavior of saving the database connections list when using the Studio repeatedly (#58499, #70053)
- Fixed the background color application error that occurred during data export to the Excel format (#54552)
- Fixed an issue that occurred when launching the application and accessing the Object Viewer (#64176, #71606)
- 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 (#54833, #54833)
- Fixed the inclusion of a false error to the log (#53187)
- Variable parsing now complies with the documentation (#61624)
- Added support for the varcharacter[(n)] data type when parsing scripts with the MariaDB syntax (#61496)
- Fixed the behavior of change markers in SQL Editor (#61421)
- Fixed the selection of encoding when writing synchronization scripts to a file (#61421)
- Fixed an issue with the syntax check for SELECT expressions with multiple UNION operators (#61421)
- Fixed an issue that occurred when closing the Studio (#53013, #54226)
- Fixed an issue that occurred when retrieving a list of view columns (T316141, T316833, #71544)
- 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 (#69005)
- Fixed the behavior of the view editor during detection of syntax errors (#70532)
- 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 (#71703)
9.0.689 20-Oct-21
User-reported and internal bug fixes
- The application fails with a critical error when trying to create diagram objects after installing the KB5006670, KB5006672 or KB5006674 Windows update
9.0.688 08-Sep-21
User-reported and internal bug fixes
- Fixed an error with reading the default values (#60282)
- Fixed an error with displaying a warning about the absence of unique keys in the Data Editor (#62016, #62008, #62390, #62717, #63023)
9.0.665 05-Aug-21
Improvements
- Connectivity support for MariaDB 10.6
User-reported and internal bug fixes
- Error with quotation of Default values for the ENUM type was fixed (#61960)
9.0.660 28-Jul-21
User-reported and internal bug fixes
- Fixed export of large tables with more than 65536 records for Excel 2003 and 1048576 records for Excel 2007 (#55440, #58608)
- Fixed metadata retrieval for default_role in Documenter (#57797)
- Fixed a problem with comparing a view that calls aggregate function with OVER clause in its query (#58988)
- Resolved an issue that led to multiple row data changes when editing data in a table with a unique key that allows NULL values (#60376)
- Fixed incorrect work with the default TIMESTAMP column (#60282)
- Fixed a problem with generating a script for virtual columns (#61277, #61277)
9.0.636 8-Jul-21
Improvements
- Database Project deployment was improved
User-reported and internal bug fixes
- Fixed debugger behavior in the auto-commit mode = OFF
- Resolved issue with the reserved word LAG in Object Editor (#55887)
- Fixed procedure execution error (#52550)
- Fixed processing of error information output (#51393)
- Fixed an error that occurred in Data Editor in case of deleting a table on the server (#59217)
- Added ability to connect via SSL with different encryption protocols (T263088)
- Fixed a bug with quoting DEFAULT values (#56517)
- Fixed a critical error when parsing procedure parameters (#57488, #58333, #58474, #56979, #59185)
9.0.597 25-May-21
User-reported and internal bug fixes
- Query Builder forces lower case table names (#54035)
- Column persistency settings are incorrectly detected within DDL scripts (#52988)
- A fatal error occurs when trying to generate data for tables that contain NOT NULL check constraints (#54760)
- Error with comparing the DEFAULT value for columns with a BIT(1) data type was fixed (#52988)
- Warning about data type mismatch of the FOREIGN KEY columns was added to Database Project (#52988)
- Error with comparing automatically generated index names was fixed (#52988)
- Error with searching dependencies was fixed (#52988)
9.0.567 22-Apr-21
Improvements
- New commands added to Data Viewer (#50371)
- 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 (#47250)
- Optimized synchronization of changes in virtual columns (T324676)
User-reported and internal bug fixes
- Issue related to Drag & Drop of nodes in Database Explorer (#53086, #53076)
- 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 (#50892)
- Issue with a connection to Azure MySQL when using Azure Active Directory (#48896)
- 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 (#48669)
- Incorrect behavior when importing data: now the default value for table columns when generating a script is taken into account (#50193)
- Incorrect behavior when exporting data: float data export as a string (#49439, 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, #52386, 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 (#49867)
- Incorrect code parser behavior when handling specific subqueries (#50521)
- Application failure with critical error after renaming the table added to Query Builder (#51168)
- Critical error when searching through any Data Report document (T322171)
- Possible errors after calculating context for code completion suggestions (#51364, #53055, #53362, #51262)
- Issue with currently active document window not being focused after closing the Find and Replace panel (#51941)
- Possible application crash when caching document content for restoring (#51925)
- Error when comparing stored procedures (T324195)
- Issue with a request to server metadata (#52448)
- Error in ignoring spaces through the command line when working with options (#50899)
- Error in finding dependencies when working with quoted object names (#50238)
- Error in reading table partitioning settings (T272704, #48568)
- Critical error when quitting the application (T310099, T310273, T310370)
- Critical error when processing versioned comments (T308096)
9.0.505 02-Feb-21
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, T323510, T324250)
- 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)
9.0.470 25-Nov-20
Improvements
- Work of the application when connecting via SSL is improved
User-reported and internal bug fixes
- Issue with connecting to Azure MySQL via SSL (T313516, T319656, T321100)
- Issue with processing Quick Info hints (T314128)
9.0.435 10-Oct-20
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 in 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 incorrect character was inserted instead of the ` character when typing Alt+96 in the SQL editor (T317193)
- 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 script 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
9.0.391 17-Aug-20
Improvements
- The disable animations option was implemented
User-reported and internal bug fixes
-
Incorrect foreign keys comparison in case of cross-database reference (T313064)
-
Add 'lateral' as a reserved keyword (T311236)
-
Error on an attempt to read the non-existing column from the metadata for SYSTEM VERSIONING tables in MariaDB (T313844, T314778, T314779)
-
Error on processing variables with the same name in different scopes (T314318, T314318, T315270)
-
Add schema comparison option to ignore triggers on the target (T314479)
-
Incorrect precision of the TINYINT data type in schema synchronization script (T314157)
- Remove inconsistent escaping chars from columns expressions (T310136)
- Incorrect quotes of DEFAULT values (T313524)
- Save user formatting for procedures and functions parameters
-
Incorrect decimal separator in Data Editor (T313296, T315422)
- Error on copying table data with virtual columns
- Incorrect data formatting in Data Editor (T310401)
- Incorrect shift of visible zone in Database Diagram when drag-and-dropping objects to the container (T312054)
- Parameters applied only to the first query during multiple queries in Data Report (T307560)
-
Incorrect formatting of DATETIME in the Formatting options window for Data Editor (T310931)
- Critical error when loading application (T310150)
- Improved Data Editor behavior in the Filter Editor window (T309337)
- Incorrect export of the date format when exporting from the results grid (T313468, T314591)
- Trace information was added to further fix of the issue with exporting to Xls file (T309909)
- Issues when profiling queries (T310496)
- Showing a valid object as invalid in Find Invalid Objects
- Object duplicates error in object search
9.0.338 23-Jun-20
User-reported bug fixes
- Problem with lost connection after 30 sec is fixed (T310169, T310109, T310443)
- Problems with cache file are fixed (T310122, T310087, T310299, T310274, T310263, T310369)
- Problem with date and time format is fixed (T310125, T310219)
- Problem with loosing DEFINER is fixed (T286087)
-
Other User-reported bugs are fixed (T310323, T310229, T309706, T310166, T310400, T310684, T310136, T310405, T310765,
T310365, T310341, T310203, T310136, T310231, T310216, T310191, T310067, T310292, T310288, T310253, T310267, T310250, T310325,
T310349, T310363, T310151, T310689, T310228, T310118, T310450, T310453, T310163, T310308, T310111, T308483)
9.0.304 15-May-20
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
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
User-reported bug fixes
- Issue with connection to Azure Database for MySQL is fixed (T289434)
8.2.21 30-Jul-19
Improvements
- Support for Check Constraints for MySQL
User-reported bug fixes
- Issue with script generating is fixed (T285683)
- Issue with incorrect foreign key creating is fixed (T285530)
- Issue with procedure debugging is fixed (T272045)
- Problems with data export to Excel is fixed (T253063)
- Other User-reported bugs are fixed (T283737, T282129)
8.1.45 07-May-19
User-reported bug fixes
- Issue with "Set Value To Null" is fixed (T275304)
- Issue with incorrect display of page count is fixed (T274495)
- Issue with incorrect utc_timestamp quotes is fixed (T271475)
- Issue with AUTO_INCREMENT property loosing is fixed (T280893)
- Issue with wrong status message is fixed (T275061)
- Issue with wrong table rebuild is fixed (T274633)
- Issue with date format is fixed (MYS-2799)
- Issue with procedure debugging when lower_case_table_names = 0 is fixed (T279914)
- Issue with smart data generators list is fixed (T280893)
- Other User-reported bugs are fixed (T275774, T271444, T274105, T274625, T275027, T275286, T277418, T277950, T279852, T280261, T277672, T271023)
8.1.22 15-Jan-19
Connectivity
User-reported bug fixes
- "PDF view" mode of Data Viewer issue is fixed (MYS-2038)
- A comparison of objects names with different case issue is fixed (T272640)
- "Spatial view" mode of Data Viewer issue is fixed (MYS-2000)
- Problem in Data Population Wizard is fixed (MYS-1979)
- Problem in SQL Document is fixed (MYS-1758)
- Other User-reported bugs are fixed
8.0.124 20-Nov-18
User-reported bug fixes
- Problems with connection to MySQL Server 8.0 by user with restrict privileges are fixed (T268562, T268491)
- Issue with connection to MySQL Server 5.7 is fixed (T268301)
- Issue with comparing database project and database is fixed (T268301)
- Issue with comparing tables is fixed (T268239)
- Other User-reported bugs are fixed (T267712, T269016)
8.0.108 17-Oct-18
User-reported bug fixes
- Issue with comparison MySQL against MariaDB is fixed (T265204)
- Problems with procedures or functions editing are fixed (T265123, T264037, T263266, T264849, T260237, T252908, T264483, T260571, T262369, T262313, T267110)
- Issue with connection to Sphinx is fixed (T262734)
- Problems with code debugger are fixed (T262328, T257393, T264750, T252714, T252908)
- Issue with foreign key adding is fixed (T260727)
- Issue with formatter options editing is fixed (T261632, T261734)
- Other User-reported bugs are fixed (T264037, T262556, T261734, T262010, T266651)
8.0.80 13-Aug-18
User-reported bug fixes
- Issue with product freeze is fixed (T252723)
- Issue with option Ignore Foreign Key Action is fixed (T260411)
- Issue with saving *.dit file is fixed (T262333)
- Issue with importing data from an excel spreadsheet is fixed (T250128)
- Issue with NRE is fixed (T261504)
- Comparison issue is fixed (T243319)
- Table Editor issue is fixed (T255214, T260649, T261536, T261561, T261755, T262844, T262622)
- Problems with lost connection are fixed (T260489)
- Issue with button in Backup Database Wizard is fixed (T252936)
- Problems with TLS 1.2 connection are fixed (T259976, T262383)
- Issue with wrong function parameters is fixed (T260342)
8.0.40 21-Jun-18
Connectivity
- Support for MySQL 8.0
- Support for MariaDB 10.3
- Support for Tencent Cloud
New features and improvements
Code Completion
- Jump between Syntax Pairs
User-reported bug fixes
- Problems with comments in procedures and functions are fixed (T259831, T257909, T255097)
- Issue with AUTO_INCREMENT is fixed (T259158, T258007)
- Problems with database backup are fixed (T258402, T253299, T256665, T259406)
- Azure MySQL connection issues are fixed (T258067, T257997, T258214)
- Column adding issues are fixed (T258049, T255214)
- Comparison issues are fixed (T257780, T256944)
- Problems with error message are fixed (T256936, T252881)
- An unbreakable cycle issues are fixed (T256857, T254625, T252766, T253143, T252709)
- An authentication issue is fixed (T256529)
- Session Manager issue is fixed (T256274)
- Unique Key issue is fixed (T255452)
- Find and Replace issue is fixed (T255150)
- Out of Memory issue is fixed (T255088)
- NRE issues are fixed (T255107, T250154)
- Connection issues are fixed(T254819, T254009)
- Query execution issues are fixed (T253728, T252936)
- Security Manager issue is fixed (T253944)
- Studio freeze issue is fixed (T252723)
- Code Debugger issues are fixed (T252714, T252755)
- SQL parsing issue is fixed (T252248)
- Other User-reported bugs are fixed (T249778, T256287, T254976, T254818, T254720, T254660, T253674, T253386, T241410, T253167, T252908, T250973, T245123, T245219, T245441, T245503, T247529, T250524, T252390, T249849, T250807, T256596, T257456, T257503, T258057, T258320, T249849, T250807, T256596, T257161, T258286, T258291)
7.4.201 04-Apr-18
User-reported bug fixes
- Text pasting issues are fixed (T252649, T252708, T252801, T252909, T252907, T252908)
- Editing and saving database objects issues are fixed (T245444, T252534, T252251, T252908)
- Problems with changing current database are fixed (T252428, T252762, T252836, T252936)
- Slow executing query issue is fixed (T252936)
- Application crash issues are fixed (T252387, T252434, T252410, T252391, T252445, T252433, T245498, T252429, T252504, T252496, T252511, T252528, T252521, T252522, T252536, T252586, T252607, T252559, T252629, T252639, T252647, T252510, T252684, T252757, T252754, T252719, T252682, T252678, T252786, T252766, T252687, T252697, T252721, T252723, T252792, T252811, T252821, T252904, T252942, T252936, T252957, T252935)
- Other User-reported bugs are fixed (T249169, T252363, T252414, T252713, T252715, T252712, T252716)
7.4.185 28-Mar-18
New features and improvements
SQL Document
- Transaction Reminder
- Execution notifications
- Color 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
- E#25519 Authentication Plugin support
User-reported bug fixes
- 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 dependencies between View in database backup and restore is fixed (T242295)
- Problems with incorrect datatypes view in data grid caption are fixed (T178729, T185938, T233868)
- Issue with Icon of an open Connection is fixed (T241441)
- Application hang issues are fixed (T241836, T242227, T242948, T244495)
- Issue 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)
7.3.148 20-Feb-18
User-reported bug fixes
- dbForge Studio for MySQL crash is fixed (T247460)
- Issue with toolbar Connection is fixed (T246534)
- Different precision for equal columns issue is fixed (T246529)
- Code Debugger issue is fixed (T246403)
- Data Report issues are fixed (T246191, T244302)
- Generate Script from Data Editor/Viewer issue is fixed (T245734)
- Poor performance issues are fixed (T241611, T245218, T245440, T245442, T245668, T246257, T246681, T247755)
- Foreign Key issue is fixed (T245498)
- Database Charset issue is fixed (T244315)
- Spatial data view issues are fixed (T244202, T245794, T240746, T241712, T243300, T244202, T245546)
- Data Export issue is fixed (T244140)
- Schema Comparison after database restoring issue is fixed (T243802)
- Backup issue is fixed (T243541)
- Database Project issue is fixed (T241249)
- Other User-reported bugs are fixed (T245132, T244924, T242365)
- View Editor issue is fixed
- Data Editor's filter issue is fixed
- Syntax Check issues are fixed
7.3.137 15-Jan-18
User-reported bug fixes
- Random crashes during work are fixed (T241836, T242227, T242948, T244495, T240805, T241469, T241472, T241473, T241486, T241497, T241503, T241886, T243873, T241652, T241886, T243873)
- Missing SSL options issue is fixed (T243640)
- Include Trigger option issue for Copy Database is fixed (T241775)
- Data Editor and Viewer issues are fixed (T241609, T240746, T241712)
- Issue with "Include CREATE DATABASE statement" option for Database Backup/Restore is fixed (T241251)
- Other Backup/Restore issues are fixed (T157300)
- Incorrect Tab Titles issue with Database Explorer is fixed (T243810)
- Database Projects issues are fixed (T241634, T242175, T242281, T242525)
- ROW_NUMBER() formatting issue is fixed (T241350)
- Other User-reported bugs are fixed (T242716, T242960, T240685)
7.3.131 07-Dec-17
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 features and improvements
Enterprise Edition with several exclusive features is introduced
- Data Generator allows instant generation and database population with meaningful test data
- Database Documenter allows database documentation generation in HTML, PDF, and Markdown file formats
- Use Copy Database for copying a set of databases without generating and running a script
New Table Engines
- Support for TokuDB
- Support for RocksDB
- Support for NDBCluster
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
- Now every document creates its own connection
- 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
- 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 comparison 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 MS 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 bug fixes
- 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 Export\Import issues are fixed (T239286, T226800, T135692)
- Data Generator issues are fixed (T218965, T214247, T213706, T197645, T167476, T173058)
- Database Backup\Restore 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)
7.2.78 26-Jul-17
User-reported bug fixes
- User-reported issues with FK are fixed (T206260, T217492, T226234, T226259, T225935, T226290, T226142, T226265)
- User-reported issue with Database Projects is fixed (T217490)
7.2.76 12-Jul-17
User-reported bug fixes
- Schema Compare issues are fixed (T221584, T222079, T224011, T224905, T222557)
- Code Completion issues are fixed (T223857, T220754)
- Issue with Used By node in Object Explorer is fixed (T224998)
7.2.63 15-May-17
User-reported bug fixes
- The following Key Exchange algorithms are supported: diffie-hellman-group-exchange-sha1, diffie-hellman-group-exchange-sha256
- The following Message Authentication Code algorithms are supported: hmac-sha2-256, hmac-sha2-512
- User-reported Schema Compare issues with synchronization script are fixed (T211159, T211618, T211834, T213946, T214003, T216161, T217109, T217721)
- User-reported issue with COMMENT and CALL in EVENT at projects is fixed (T204437)
- User-reported issue with long stored procedure text and multiple clipboard usage is fixed (T213258)
- User-reported issue with FK lost in Schema Compare script is fixed
- Other Schema Compare issues are fixed (T207346, T208171)
7.2.58 24-Mar-17
User-reported bug fixes
- Data Editor issues with TIME and DATETIME values are fixed (T195928, T196506, T198573, T199273, T200185, T200559, T200974, T202003, T198018)
- Some formatting options were reorganized
- Adding Unique Index is more convenient in Object Editor now (T203572)
- Some users reported NRE when using Restore Tabs functionality (T199550, T200183, T204970, T205402, T206379, T207082, T207082, T210774)
- Issue with debugging stored procedures with BLOB parameters is fixed
- Issue with double quote in SQL Document is fixed (T203234, T204773)
7.2.53 30-Nov-16
- Issue with negative TIME value is fixed (T197993)
7.2.50 29-Nov-16
User-reported bug fixes
- Incorrect display of TIME value is fixed (T196300, T196559, T196674, T195972)
- Issue with ENGINE = ARCHIVE in Object Editor is fixed
- Issue in Security Manager which required to type administrator password twice is fixed (T196970)
- Syntax Check issue is fixed (T196712)
- Issue with quotes in SQL Document is fixed (T196181, T196212, T196267)
7.2.34 10-Nov-16
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 bug fixes
- 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 Export\Import issues are fixed (T192786, T191551, T179580)
- Database Backup\Restore 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)
7.1.31 30-Sep-16
User-reported bug fixes
- Issue with SSL connection is fixed (T189584, T189661)
7.1.30 27-Sep-16
User-reported bug fixes
- Issue with SSH connection is fixed (T164459)
- Issue with Data Editor and Viewer when request to information_schema returns null is fixed (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)
7.1.29 23-Sep-16
User-reported bug fixes
- Issue in Data Compare with very long server names is fixed
- Issue with parsing source text is fixed (T188585)
7.1.26 19-Sep-16
- User-reported issue with quick filter in Data Editor and Viewer is fixed (T187880)
- Ability to copy table headers without types is implemented (T169314, T170395, T170546, T170790, T171003, T172242, T172559, T174105, T175481, T176860, T183864, T186808, T187218, T187896)
7.1.20 13-Sep-16
- Latest MySQL builds are supported
7.1.13 27-Apr-16
New features and improvements
- Data type information to the column header in Data Grid added
- Data Grid now supports Generate Script As feature
- Generate Script As now available for multiple objects in Database Explorer
User-reported bug fixes
- Issue with application launch on Windows 10 at some systems is fixed (T161952, T166969, T165345, T169104, T168315)
- NRE when closing tabs while opening a connection is fixed (T169106)
- NRE when using auto-hide layout feature under some conditions is fixed (T168859, T168830)
- Support for specific Unicode characters in SQL document is fixed (T168760)
- Alias refactoring issue is fixed (T168760)
- Database Explorer auto-scroll issue is fixed
- NRE in Completion List under some circumstances is fixed (T168188)
- Issue when using Find & Replace in Data Compare document is fixed (T165954)
- Issue with filtering in Data Viewer is fixed (T165224)
7.0.54 23-Mar-16
User-reported bug fixes
- Issue with synchronizing table with project in Schema Compare is fixed (T164940, T164857)
- Issue with focus when switching between SQL Document and Data Viewer is fixed (T165099)
- NRE in Data Editor is fixed (T165224)
7.0.52 14-Mar-16
User-reported bug fixes
- Issue with color of variable in Metropolis Dark skin is fixed (T162483, T163065)
- NRE when using formatting on delimiter option is fixed (T162560, T163763, T163765, T162963)
- ansi_quotes support is fixed (T163085)
- Default comment style reverted to '--' (T163753)
7.0.49 29-Feb-16
User-reported bug fixes
- Issue with connecting to MySQL 5.7 instance on Unix systems when lower_case_table_names set to 0 is fixed (T162055, T161962)
7.0.46 26-Feb-16
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)
6.3.358 03-Jun-15
User-reported bug fixes
-
Improved application startup time
-
Several debug issues are fixed (T124585, T128025, T128625)
-
Find and Replace issues are fixed (T125864, T125379, T127103, T125379, T133137)
-
Issue with report is fixed (T128900)
-
Issue with data table editor is fixed (T126877)
-
Some formatting issues are fixed (T126448)
-
Data Export issues are fixed (T125522, T131135, T131393, T130436, T130487, T130826)
-
Find Object issue is fixed (T125367)
-
Database Diagram issue is fixed (T103032)
-
Layout issue when switching between different views is fixed (T132105)
-
'Message: Cannot use named and unnamed parameters in the same command' is fixed (T127440, T129867)
-
Error report when attempting to close a sql tab is fixed (T127738, T128659, T132332)
-
Issue with procedure design mode is fixed (T130840)
-
Query Builder exception is fixed (T133011)
-
Issue in data comparison with big data sets is fixed (T125000)
-
Other improvements and bug fixes (T128679, T131376, T128654, T51955, T124871, T131996, T129833, T128422, T127190, T123388, T123895, T131442, T133283, T129982)
6.3.341 30-Jan-15
- Stability improvements and bug fixes
- Issue with SSL connection is fixed (T123387)
6.3.339 23-Jan-15
User-reported bug fixes
-
Issue with metadata retrieval is fixed (T121706, T121815, T121873, T121968, T121988, T122003, T122043, T122126, T122135, T122532, T122469, T122479, T122515, T122711, T122722, T122772)
-
Issue with parsing labels is fixed (T122487, T121188, T122636)
-
Issue with Excel export is fixed (T122760)
-
Issue with data table editor is fixed (T122710)
-
Some formatting issues are fixed (T122242)
-
Some issues with search and replace functionality are fixed (T122242)
-
'Message: The given key was not present in the dictionary' is fixed (T122210)
-
Issues with importing date values from Excel are fixed (T121674, T121681)
-
Issues with documentation not opened in some cases is fixed (T120794)
-
'Message: Invalid operation. The connection is closed' is fixed (T121715)
-
Release also includes several other bug fixes, stability and performance improvements
6.3.337 5-Jan-15
User-reported bug fixes
-
Issue with SSL connection is fixed (T120898, T121089)
-
Issue with editing connection when database restore is in progress is fixed (T120751)
-
Issues with filtering are fixed (T120762, T120805)
-
Issue with opening recent projects is fixed (T120616)
-
Issue with parsing labels is fixed (T121157, T121188, T121283)
6.3.330 25-Dec-14
User-reported bug fixes
-
Error report when changing collation is fixed (T120306, T120429, T120485, T120502, T120600, T120603, T120614)
-
Issue with adjusting properties using the Pivot Table is fixed (T120301)
-
Some issues with data import of quoted text are fixed (T120342, T120373)
-
Issue with stored procedure Compile for Debugging is fixed (T119568)
-
Issue with schema comparison with CURRENT_TIMESTAMP columns is fixed (T119947)
-
Issue with 'Look in' field in Find and Replace window is fixed (T120330)
-
Issue with generating reports via command line is fixed (T120566)
-
Issue with rename in Object Editor is fixed (T120654, T120694)
6.3.325 19-Dec-14
User-reported bug fixes
-
Issue with creating indexes is fixed (T119874, T119772, T120051)
-
Issue with warnings in the data comparison command line is fixed (T112754)
-
Issue with search in projects is fixed (T119891)
-
Issue with reopening export template to modify data type is fixed (T119984)
-
Other minor improvements and bug fixes
6.3.323 09-Dec-14
SQL Editing and Execution
-
Command-line interface for SQL formatting
-
Query execution pane
-
Option to change a snippets folder location
-
Phrase completion
-
Extended support of MySQL 5.7 in Code Completion
-
Option to set files encoding within the /execute command-line operation
Database Explorer
-
Alternative ways to create a new object
-
Sending objects to a database diagram
-
Displaying the objects number in the tree
Schema Comparison and Sync
-
Selecting object types for comparison
Data Comparison and Sync
-
Option to ignore differences in characters that signify the end of line
-
Show white spaces option
-
Ignore computed columns option
-
Setting up the limit size of bulk during synchronization
Data Export and Import
-
Export to the Excel 2007 (XLSX) format
-
Retaining records filtering when the Export Selected Rows Only option is selected
-
Export of BLOB fields as TEXT to Excel, TXT, HTML, PDF, RTF, and CSV formats
-
Export to Excel, RTF, PDF with/without a header
-
Force quotes option when exporting data to a CSV file
-
Option to select encoding when exporting to DBF
-
Import of dynamic values from Excel and Excel 2007
-
Detecting column types when importing data from the CSV format
Data Report
-
Support for report parameters in the command-line interface
Data Editor
- Easy way to hide data results
-
Data Viewer and LOB Editor are combined in a single control
-
Redirect Data to Output is transformed into additional data editor
Database Restore
-
Option to set files encoding within the /restore command-line operation
GUI
-
Support for multiple monitors
-
Modeless Create Schema Snapshot and Data Report Wizard windows
Other Features and Improvements
-
Enhanced Find and Replace window
6.2.277 27-Aug-14
User-reported bug fixes
- Issue with stored procedure rename is fixed (T109743)
- Issue with non standard TEMP path is fixed (T110668, T111808)
- Application crashes are fixed (T111378, T111231, T11144, T110238)
- Issue with lost mapping is fixed (T110791)
- Issue with cache update using shortcut is fixed (T110076)
- Issue with some select queries with SUBSTRING() is fixed (T105611)
- Debugger issues are fixed (T111395)
- Issue with syntax check with newer versions of MySQL is fixed (T111266)
- Several problems with Data Editor are fixed
- A lot of other improvements and bugfixes
6.2.234 24-Jul-14
User Interface
- Switching tabs by the CTRL+ALT+PAGE UP and CTRL+ALT+PAGE DOWN key combinations
- Windows connection coloring is added
- Restoring document tabs from the last session is possible now
- Switching between wizard window and primary window is possible now
- Updated Database Explorer
- Filtering options are available in the Database Explorer
- New themes are added
- Start Page is updated
- Design is upgraded
Object Editors
- Connection to Sphinx Search Engine
- Viewing script while editing columns, indexes etc.
Code Completion
- Alias refactoring
- Quick Information for cursors
- Detect changes on a server before refreshing suggestion cache
A lot of minor improvements and bug fixes
6.1.166 19-Mar-14
User-reported bug fixes
- Issue related to InitializeCriticalSectionEx function during launching installation is fixed (R34601)
- Incorrect behavior with opening stored routine editor is fixed (T99060)
- ArgumentException on parsing text is fixed (T99110)
- NullReferenceException in Data Editor is fixed (T98982)
- Issue with shortcut is fixed (T98963, T98976, T99098, T99172, T99174, T99176, T99202, T99289, T99283, T99372, T99468, T99560, T99605, T99620, T99651, T99652, T99762, T99925, T99936, T100007, T100008, T100019, T100058)
- InvalidOperationException on evaluating expressions in debugger is fixed (T98740, T99087)
- OverflowException related to SQL Complete in SQL document is fixed (T98568)
6.1.164 24-Feb-14
New code formatter features
-
New Option: Enclose identifiers within brackets
-
New Option: Add parentheses when inserting functions
-
New Option: Enable autoformat words while typing
-
New Option: Alias Text Case - As in declaration
-
Code formatter functionality is available even if code completion is disabled
-
Do not format tag is implemented. Now it is possible to format a whole SQL document
in the editor ignoring selected code fragments which you do not want to be formatted.
Refresh suggestions cache
-
Automatic refresh suggestions cache by specified time is added
-
New option: Refresh suggestions cache on detecting changes on a server
Minor improvements
-
Formatting CASE options are redesigned
6.1.154 05-Feb-14
User-reported bug fixes
- NullReferenceException on a table script generating is fixed (T96763)
- The ability to filter all string types, including MEDIUMTEXT, in Data Editor is added (R32952)
- NullReferenceException on parsing text with syntax error in view editor is fixed (T97059)
- Issue with saving print options in Data Editor is fixed (T96945)
- Issue with lookup editor in Database Diagram is fixed (T96818)
- TargetException in table editor is fixed (T96951)
- CommunicationObjectAbortedException with MyDAC integration is fixed (T94850)
- Issue with parsing view text in the Express edition is fixed (T96863, T97204)
- NullReferenceException in Schema Comparison with column names which contain 'virtual' or 'persistent' is fixed (T97218)
- Problem on editing TEXT columns in Data Editor is fixed (T97010)
6.1.142 24-Jan-14
- Issue with server version identification is fixed (T96594)
6.1.137 23-Jan-14
Database connectivity support
All known MySQL and MariaDB servers' features are available to use. In this version the following servers are supported:
-
MySQL 5.6
-
MySQL 5.7
-
MariaDB 5.5
-
MariaDB 10.0
MariaDB Virtual Columns are supported in:
-
Data Export/Import wizards
-
Data/Schema Comparison tools
Microseconds support for TIME, DATETIME and TIMESTAMP data types
-
Data Editor
-
Data Export/Import wizards
-
Data Comparison tool
Pluggable authentication is supported
The product provides the extended support of pluggable authentication modules for MySQL servers
Minor features and improvements
-
The application launch time is decreased
-
Performance when worked with UI is improved (T74814, T75400)
-
Federated and Aria engines are supported
-
All new clauses and statements are supported in Syntax Check
-
The FOLLOWS and PRECEDES clauses are supported in the trigger editor
-
The ability to redo changes after undo in the table editor is added (R27345)
-
Microsoft Windows 8.1 is supported
User-reported bug fixes
-
AppDomainUnloadedException on maximizing/minimizing the application is fixed (T74588)
-
NullReferenceException on dragging windows is fixed (T75820, T76009, T83924)
-
Incorrect script generating on database refactoring is fixed (T83805)
-
MySQL Embedded 5.6 is supported (R29696)
-
An error on saving a SQL document is fixed (T91012)
-
NullReferenceException on working with models in Database Designer is fixed (T91033)
-
OverflowException on opening an object editor is fixed (T90173)
-
Incorrect behavior while showing the difference between two objects in Schema Compare
is fixed (T91476)
-
Incorrect filter data on choosing Today value in Data Editor is fixed (R31110)
6.0.622 26-Nov-13
User-reported bug fixes
-
An error occurred while compiling a procedure for debugging (that stores the ENUM
data type) is fixed (T88061)
-
ArgumentException while sorting data in the Data Editor is fixed (T88214, T88234,
T89919)
-
Wrong behavior with showing the dialog window on displaying data is fixed (T88367)
-
An error occurred while opening a file without an extension is fixed (T88880)
-
Wrong behavior with setting a position for a header, when importing from CSV file
is fixed (R29019)
-
A syntax error on compiling a project is fixed (R29021)
-
An error occurred while debugging a stored procedure is fixed (T89542)
-
Short names are used now for editing data to avoid problems with replication (R29645)
-
NullReferenceException while displaying the Start Page is fixed (T90258, T91547)
-
NullReferenceException on generating schema script for FEDERATED tables is fixed (T90968)
6.0.568 22-Oct-13
User-reported bug fixes
-
An exception while changing a parameter type in the Edit parameters window is fixed
(T87420, T87819)
-
A problem, related to displaying variables while debugging a trigger is fixed (T84478)
-
A mistype in the debugging procedure message is fixed (T85881)
-
A problem, related to displaying properties of columns with DOUBLE or FLOAT types,
is fixed (R27619)
-
An exception on clicking a splitter button in the Find Results window is fixed (T86371)
-
A problem, related to the table columns prompting in the IN statement, in a subquery
that contains WHERE condition is fixed (T86470)
-
An error, while executing Compile for Debugging command for stored procedures is
fixed (T87529)
6.0.493 25-Sep-13
User-reported bug fixes
-
NullReferenceException on refactoring a table is fixed (T84310)
-
NullReferenceException on sorting data in the Data Editor is fixed (T84292, T84287)
-
NullReferenceException on using invalid file path in the Export wizard (T84136)
-
A table refactoring failure is fixed (T83805)
-
NullReferenceException on editing a condition in the HAVING clause is fixed (T83306)
-
NullReferenceException on editing a column in the table editor is fixed (T83967)
-
An error while inserting data in a table from the Data Editor is fixed (T83957)
-
In case columns are differ by the name, they will be renamed (instead of re-creating)
(T83900)
-
NullReferenceException on editing code in the SQL editor is fixed (T83895)
-
NullReferenceException in the Objects Editor document is fixed (T83819, T86126)
-
An error related to scrolling in the table editor is fixed (T83359)
-
An error related to debugger freezing while debugging a function is fixed (T70402)
-
NullReferenceException on compiling a procedure is fixed (T83311)
-
An error occurring while editing parameters types in the procedure editor is fixed
(T77234)
-
NullReferenceException on re-opening the procedure editor (after closing parameters
window by pressing the ESC button) is fixed (T83238)
-
Receiving of meta data of default database is off (while the "Enable code completion"
is disabled) (T83160)
-
An error related to SSH connection is fixed (T75300)
6.0.441 23-Aug-13
User-reported bug fixes
-
The Issue with the replication is fixed (T24637)
-
InvalidOperationException on closing the application with opened documents is fixed
(T74609)
-
The Issue with setting the current date in a cell of Data Editor is fixed (T74754)
-
NullReferenceException on choosing an item in the Code Completion window is fixed
(T75098, T83498)
-
NullReferenceException on editing an expression in Query Builder is fixed (T75448)
-
InvalidOperationException on describing Code Completion members is fixed (75692)
-
The Issue with indentation on formatting a script with the CASE WHEN clauses is
fixed (R25618)
-
NullReferenceException on invoking the Save All command is fixed (T76032)
-
Hanging of the application on opening the table editor in transaction mode is fixed
(R24636)
-
NullReferenceException on refactoring a table in Database Diagram is fixed (T74916)
-
The Issue with showing modifications on the SQL tab of the view editor is fixed
(T75084)
-
ArgumentException on executing a script in SQL document is fixed (R25155)
-
The Issue with changing a case of variables in the DECLARE clause on formatting
a statement is fixed (R25322)
6.0.399 31-Jul-13
User-reported bug fixes
-
NullReferenceException on editing view is fixed (T72973)
-
Debugger errors connected with clearing debugging table (T70402)
-
InvalidOperationException on losing connection is fixed (T72844, T73975, T71393,
T71700, T72844, T69852, T70596, T73043)
-
Error on creating long synchronization file name or path is fixed (T72510)
-
NullReferenceException on executing query is fixed (T72865)
-
NullReferenceException on compiling objects is fixed (T73797)
-
Error in Code Completion when working with quoted objects is fixed (T73749)
-
Error on displaying full file name or path in the "Windows" window is fixed (T74242)
-
Error on debugging a procedure name of which starts with a number is fixed (T72879)
-
Error on navigating in the FKLookup window of Data Editor is fixed (R23530)
-
Error on formatting the BINARY keyword in the Code Completion functionality is fixed
(R24118)
-
NullReferenceException on adding invalid expression to GROUP BY or ORDER BY in Query
Builder is fixed (R24196)
-
Error with suggesting the UNSIGNED keyword in the Code Completion functionality
is fixed (R22572)
-
Error on deleting the last column in table on editing it is fixed (R23939)
-
Error on debugging procedures with SIGNAL/REGIGNAL operators is fixed (R22322)
-
NullReferenceException in Data Editor on switching view modes with unsaved data
is fixed (T74100)
-
Error in Data Compare on generating synchronization script when the "Exclude comments"
option is on is fixed (R24244)
-
NullReferenceException on working with SQL document is fixed (T72693)
-
Incorrect behavior of LOB Editor with unsaved data is fixed (R22597)
-
The Code Debugger interruption error is fixed (R23913)
-
Error on line numbering while grouping data in Data Editor is fixed (R23179)
-
OverflowException when scrolling the Database Diagram is fixed (T70450, T75088)
6.0.315 27-Jun-13
User-reported bug fixes
-
Issue with editing multi-line text in a VARCHAR column is fixed (R22636)
-
Issue with importing data from Access database is fixed (T72061)
-
Incorrect behavior on deleting a user in Security Manager is fixed (R23383)
-
Incorrect syntax on creating a user in Security Manager on MySQL server 4.1 is fixed
(R23377)
-
Problem on modifying the query text of a view in Database Designer is fixed (T71847)
-
Base64 encoding support is added for HTTP tunnel in the connection editor (T71684)
-
RowNotInTableException on removing a parameter in the procedure editor is fixed
(T71001)
-
ArgumentException on showing data after execution of a query is fixed (T71375)
-
Incorrect number of records on showing data in paginal mode in Data Editor is fixed
(T72465)
-
NullReferenceException on compiling a procedure is fixed (T72533, T73058)
-
Application crashing on denied access to MySQL services in Service Manager is fixed
(R23037)
-
Problem on restoring a backup copy with nonexistent users is fixed (R22186)
-
KeyNotFoundException on canceling query execution in Data Report designer is fixed
(T72052)
-
Issue with resetting the toolbar customization is fixed (T70463)
-
Issue with the INTERNAL keyword in Code Completion is fixed (R22954)
-
Issue with execution of the DELIMITER statement is fixed (T72486)
-
Incorrect behavior on changing the Primary property in Column Editor is fixed (T72690)
-
Incorrect behavior on adding new snippets in Snippet Manager is fixed (T72625)
6.0.265 23-May-13
User-reported bug fixes
-
NullReferenceException on closing modified Master-Detail document is fixed (T71516)
-
Incorrect script on changing a view in view editor is fixed (R21578)
-
Incorrect data synchronization of the Date type is fixed (T70414)
-
Invalid 'Reset Toolbar Layout' functionality is fixed (R21587)
-
ArgumentOutOfRangeException on comparing a database with a project is fixed (R22031)
-
NullReferenceException on deleting a connection during schema comparison (R22105)
-
Function GREATEST is added to autocompletion list (R21960)
-
Incorrect behavior with the length of a VARCHAR column on changing a charset is
fixed (R21993)
-
ArgumentOutOfRangeException on canceling the formatting of a query is fixed (R21925)
-
InvalidOperationException on setting up markers in Data Import wizard is fixed (T70358)
-
Incorrect error message on importing data from third-party ODBC drivers is fixed
(T70907)
-
Invalid navigation to an object from a SQL document is fixed (R21845)
-
ArgumentOutOfRangeException on writing a SQL query is fixed (T71402)
-
Integration with MyDAC on x64 operating systems is added (T70415)
-
CriteriaCompilerException on filtering data in Data Editor is fixed (T70637)
-
Incorrect determination of the current statement in SQL Document is fixed (T71402,
T70359)
-
InvalidCastException on sorting data of the Date type in Data Editor is fixed (R22260)
-
Incorrect behavior on a valid query in Query Builder is fixed (T70645)
-
A few problems on refactoring procedure's name are fixed (T71776)
-
RowNotInTableException on removing a parameter in the procedure editor is fixed
(T71001)
6.0.189 25-Apr-13
User-reported bug fixes
-
Project building performance is improved (R20862)
-
Problem of building a project with references on 'information_schema' is fixed (R19762)
-
TypeLoadException on loading dbForge Studio is fixed (T69731)
-
Issue with database diagram links is fixed (T69636)
-
ArgumentException on generating schema script is fixed (T70015, T70114)
-
ArgumentOutOfRangeException after deleting column in Query Builder is fixed (T70078)
-
Some documentation problems are fixed (T69629, R20607)
-
ArgumentNullException in Database Diagram is fixed (T69596)
-
InvalidOperationException on loading dbForge Studio is fixed (T70007)
-
InvalidCastException on copying data with header in Data Editor (T70088)
-
Problem on compiling function is fixed (T69704, T70045, T70290)
-
Issue with formatting SQL statements is fixed (T70202)
-
Syntax checking for INSERT...SELECT statement is fixed (T70140)
-
Issue with Database Connection Properties window size is fixed (T70094)
-
The 'POSITION' is a MySQL reserved word (T70199)
-
Issue with Data Editor is fixed (T70089)
-
Issue with 'Delete' key in SQL Document is fixed (T69663)
-
NullReferenceException in object editor is fixed (T70350)
-
MissingMethodException on formatting is fixed (T70002, T70030)
-
Encoding pages 949, 1253, and 1255 are supported (T70478, T70469, T69968, T70212,
T70480)
-
Issue with MyDAC integration in RAD Studio is fixed (T70415)
-
Issue with partitioned tables is fixed (T69867)
-
Issue with storing procedure parameters in object editor is fixed (T69619)
-
Issue with parsing procedure body is fixed (T70394)
-
Issue with foreign key in schema synchronization is fixed (T50213)
-
Issue with table named 'option' is fixed (T60303)
-
Option 'Treat NULL and EMPTY STRING as the same value' is added to Data Comparer
(T61027)
-
Option 'Force Column Order' is added to Data Comparer (R16375)
-
NullReferenceException on parsing script is fixed (T70429)
-
NullReferenceException on executing a procedure from Database Explorer is fixed
(T69922, T69909, T69873, T69866, T69587, T69987, T69945, T69948, T70005)
6.0.151 12-Apr-13
User-reported bug fixes
-
NullReferenceException on executing subquery from the modal Query Builder is fixed
(R20304)
-
Incorrect behavior of the Use Commit Mode option in Data Comparison is fixed (R20484)
-
Incorrect behavior of some code editor's options of in the Express edition is fixed
(R20515)
-
NullReferenceException on closing Data Editor is fixed (R20597)
-
ArgumentNullException on showing differences for BLOB fields in Data Comparison
document is fixed (R20610)
-
ArgumentOutOfRangeException on canceling compilation of a procedure is fixed (R20661)
-
NullReferenceException on executing a procedure from Database Explorer is fixed
(T69635, T69846, T69850)
-
InvalidOperationException on working with document views is fixed (T69709, T69708)
-
Storing parameters value for a procedure is fixed (T69619)
-
TypeLoadException on launching the application on the PC without .NET Framework
3.5 installed is fixed (T69731)
-
Database Diagram is included in the Standard edition without any limitations now
-
ArgumentException on generating the SELECT statement for a table from Database Explorer
is fixed (R20821)
6.0.128 04-Apr-13
Database refactoring
This feature allows renaming objects in a database and automatically updates links
to these objects in the whole database.
-
Renaming of tables, columns, views, procedures, functions, and indexes is supported
-
Preview of changes in the database with possibility to cancel them selectively is
supported
-
Possibility to generate refactoring script of a database without changing it is
supported
-
Refactoring functions can be accessed from the tree and object editors
-
Possibility to rename several columns from object editor
-
If an error in processing dependencies is encountered, a user can fix it manually
Query builder with support for DML statements and usability improvements
-
Visual building of INSERT, UPDATE, and DELETE statements is supported
-
Conversion of SELECT queries into INSERT statements is supported
-
One-click conversion of SELECT query into UPDATE or DELETE with saving of WHERE
condition is supported
-
Execution of separate subqueries to check their correctness without leaving diagram
interface
-
Usability of visual expression editor is improved
-
Query type is indicated on the diagram surface
Data export to SQL statements
-
Data export to INSERT, UPDATE, DELETE, and MERGE statements is supported
-
Ability to export query results as well as data directly from a table is supported
-
Quick generation of INSERT statements from data grid without opening wizard is supported
Improved database object editors
-
Editable column grid in the table editor now allows adding and editing columns without
opening the popup dialog
-
Full-text search in the column grid in the table editor is added
-
Schema changes can now be viewed before updating database
-
Editor layout was revised, and now it allows viewing designer and table SQL simultaneously
-
F7 shortcut can now be used to toggle all editor views
-
Stored procedure editor Design tab is redesigned
-
Heuristics is supported
New features in the data comparison tool
-
New data comparison reports now contain table data (not just a summary)
-
Comparison of custom query results (along with tables and views) is added
-
"One-to-many" objects mapping when addressing columns that were separated as a table
in the target database is added
-
Possibility to include objects into comparison by mask, which is useful when comparing
groups of tables is implemented
-
Full-text data search in comparison results is supported
-
Analysis of comparison results is improved: 'Hide unmodified columns' option, per-column
difference counters are added
Improved code completion
-
Column picker feature allows selecting multiple column suggestions from drop-down
list
-
Asterisk expansion in SELECT statements is added
-
Context-specific suggestions is improved
-
Quick object information is improved
-
JOIN clause autogeneration is added
-
Autogeneration of table aliases is added
-
Sorting suggested keywords by relevance is added
-
Highlighting occurrences of an identifier in SQL document is added
-
Performance of describing objects' metadata is improved
Automated data report delivery
This feature enables users to set an automatic data report generation and delivery
to the requested destination.
Setup of report's generation and delivery can be executed through the command line,
providing an opportunity to use Windows scheduler for regular report generation:
-
Users can choose the format for report generation
-
Users can choose "Report delivery" method: e-mail, ftp, shared folder
Code Snippets Manager
Code Templates feature is now renamed to Code Snippets and extended with the Snippets
Manager window for adding and editing SQL templates.
Improved code formatter
-
Format profiles are supported
-
Formatting options are extended
-
Preview window for viewing formatted code with support of code highlighting and
editing is added
-
Search of options by name is added
New window docking system
-
Switching between tool windows with Ctrl+Tab is supported
Minor features
-
Amazon RDS is supported
-
If there is more than one SELECT statement in a document, query results are now
displayed on separate tabs in the Data window after execution
-
Support of MySQL pluggable authentication on creating a connection to MySQL server
is added
-
Support of Windows authentication on creating a connection to MySQL server
-
F5 shortcut now works for execution of a selected SQL fragment as well as for the
entire script
-
Export of connection list from the application together with other settings is supported
-
Print setup for master-detail browser is supported
-
New skins added (Metropolis and VS2010)
5.0.98 23-Jul-12
User-reported bug fixes
-
Issue with missing functions in query designer is fixed (R10934)
-
Error during designing query is fixed (R8955)
-
Program crashing during database backup with Flush tables is fixed (R10055)
-
"Invalid argument" error when designing a query is fixed (R10169)
-
Error "Asynchronous operation already running" when creating pivot table is fixed
(R10207)
-
Issue with using the same Build Order for different configuration is fixed (T41472)
-
Error "Out of memory" during database backup is fixed (R10970)
-
Issue with changing the toolbar color is fixed (R11255)
-
Error after pressing Ctr+R in the Grid is fixed (T42264)
5.0.82 15-June-12
User-reported bug fixes
-
Error report when specifying Not Null in Filter is fixed (T40269)
-
NullReferenceException when editing indexes is fixed (T39663)
-
NullReferenceException when deleting index on a diagram is fixed (T39922, T40763)
-
Error report when editing grid is fixed (T39998)
-
ArgumentException in Data Import Wizard is fixed (T40209)
-
NullReferenceException when dropping an index in Database Explorer is fixed (T40278,
T41243, T40278)
-
"EXECUTE" label is added to the "execute" button (R9992)
-
Disabling intellisense buttons on change focus from sql document is added (R9996)
-
The "Invalid parameter value" error when executing a stored procedure with parameters
is fixed (T40501)
-
The "Can't get main profiling query." error report is fixed (T40713)
-
NullReferenceException in Data Report is fixed (T40796)
-
"Enter column name" and "Enter table name" phrases on the "Joins" tab are swapped
(T41005)
5.0.76 18-May-12
User-reported bug fixes
-
Issue with reserved keyword MAXVALUE is fixed (T39661)
-
Issue with 'Execute Current Statement' command when the caret is placed after
';' is fixed (T39448)
-
Error report with a table in the Query Builder is fixed (T39207)
-
Issue with HTTP-tunneling is fixed (T38708)
-
Issue with unexpected focused row in the Data Editor is fixed (T38675)
-
Error report on opening *.dcomp is fixed (R9462)
-
Issue with subquery alias during project building is fixed (R9076)
-
Issue with encrypted password for users in Generate Schema Script and Backup wizards
is fixed (R8737)
5.0.72 23-Apr-12
User-reported bug fixes
-
Error Report on Parameter information opening is fixed (T36601)
-
Error report on connection creating is fixed (T35423, T36597)
-
Error report on data import from *.xlsx file is fixed (T36030)
-
Error report on table editing is fixed (T36677)
-
Error report on database expanding is fixed (T36988, T38165)
-
Error report on changing current connection is fixed (T37408, T39190)
-
NullReferenceException on import from *.csv file is fixed (T37535)
-
Issue with foreign key dependencies is fixed (T37748)
-
Issue with incorrect dropdown list in SET clause of UPDATE statement is fixed
(T38483)
-
NullReferenceException on profiling a query is fixed (T38464)
-
NullReferenceException with connection in multiple threads is fixed (T35192, T39096)
-
Problem on data synchronization in TEXT type columns is fixed (T36801)
-
Issue with out of view columns in comparison document is fixed (T36708)
-
Issue with automatically generated indexes is fixed (R7805)
-
Issue with quoted columns in subpartitions is fixed (R7541)
-
Issue with updating data after default values inserting is fixed (R8419)
-
Issue with function does not exists during debug is fixed (R7153)
-
Issue with wrong result while insert update on duplicate key is fixed (R8563)
-
Issue with subquery alias on project building is fixed (R6372)
-
Issue with UDF reference on project building is fixed (R6373)
5.0.67 02-Mar-12
User-reported bug fixes
-
NullReferenceException on starting debug of stored procedure is fixed (R6643)
-
NullReferenceException on sending objects to Chart Designer is fixed (R6642)
-
NullReferenceException on executing a procedure in Standard Edition is fixed (R6641)
-
Issue with showing foreign keys lookup editor in Data Editor is fixed (R5690,
R5691)
-
IndexOutOfRangeException on compiling a procedure from Database Explorer is fixed
(R6647)
-
InvalidOperationException on formatting SQL after pasting it in SQL document is
fixed (T35115)
-
Showing duplicate warning about OutOfMemory in Data Editor is fixed (R5978)
-
NullReferenceException on importing data is fixed (R5416)
-
Few fixes for correct working with asynchronous connections are made (T35264)
-
ExternalException on pasting data in Data Viewer is fixed (T35506)
-
Few fixes on importing data through Thoroughbred ODBC driver are made (T36075)
-
Issue with activating an old object's editor without refreshing it on navigating
from code is fixed (T36235)
-
NullReferenceException on closing Data Import wizard is fixed (T36315)
-
KeyNotFoundException on entering a filter in upper case in Query Builder is fixed
(T36014)
5.0.63 13-Jan-12
User-reported bug fixes
-
NullReferenceException on refreshing connection with an opened SQL document is fixed
(R5536)
-
ArgumentOutOfRangeException on wrapping a query to a subquery in Query Builder is
fixed (R644)
-
OutOfMemoryException on exporting data is fixed (T34205)
-
Incorrect behavior on working with the filter in a pivot table is fixed (R5045)
-
NullReferenceException on filtering data in Data Editor is fixed (T35232, T34698)
-
Incorrect behavior on ignoring columns by mask in Data Compare is fixed (R4292)
-
OutOfMemoryException on generating report in Data Compare is fixed (R4079)
-
Incorrect showing of schema comparison results is fixed (R6198)
-
Conflicts with dbForge Fusion are fixed (T35700, T35770, T35788)
-
NullReferenceException on resizing SQL document is fixed (T35231, T35874, R2171)
-
Generating reports for data comparison results is supported in the command line
interface (T32974)
-
Incorrect determination of boundaries for the current statement on executing a query
in a SQL document is fixed (R5449)
-
NullReferenceException on wrapping a query to a subquery in Query Builder is fixed
(R5766)
-
Incorrect behavior with changing color of punctuation in code editor is fixed (T33640)
-
Incorrect renaming of alias on wrapping query to subquery in Query Builder is fixed
(T34205)
-
ExternalException on synchronizing data in Data Compare is fixed (T34878)
-
Inability of editing data on MySQL 4.1.22 is fixed (R6228)
-
Few problems with showing the foreign key lookup editor in Data Editor are fixed
(R5691, R5690)
5.0.60 06-Dec-11
User-reported bug fixes
-
A Issue with showing the Product update dialog box is fixed (T33358)
-
NullReferenceException on designing a query in Query Builder is fixed (T33930)
-
NullReferenceException on generating text with the last_insert_id function in Query
Builder is fixed (R4203, R5243)
-
NullReferenceException on terminating a debug session is fixed (T33166)
-
FormatException on showing data after executing a query is fixed (T33985, T33788,
T34883)
-
Issue with restoring closed tool windows is fixed (R5019)
-
Buttons on the Diagram and Layout toolbars are enabled now (T34437)
-
DBConcurrencyException on updating records in Data Editor is fixed (T33830)
-
NullReferenceException on Undo operation in procedure editor is fixed (T34069)
-
IndexOutOfRangeException on opening procedure editor is fixed (T33806)
-
NullReferenceException on parsing text in SQL document is fixed (T33582)
-
Incorrect navigation on errors in object visual editor from Error List is fixed
(T33786)
-
NullReferenceException on opening a master-detail document is fixed (T33931, T33559)
-
BadImageFormatException on product tour loading is fixed (T33949)
-
XmlException on opening the Code Templates window with and empty SnippetsIndex.xml
file is fixed (T34140)
-
Incorrect editing of dates in Data Editor is fixed (T34205)
-
NotImplementedException on executing procedures is fixed (T33885, T33887)
-
ArgumentException on editing data in Data Editor is fixed (T33826)
-
InvalidOperationException on saving a Database Diagram document is fixed (T34656)
-
InvalidOperationException on loading a preview of Excel file in the Data Import
wizard is fixed (T34269)
-
Incorrect behavior of the filter in Pivot table is fixed (R5045)
-
Issue with importing DBF files with Integer fields is fixed (T34388)
-
Wrong order of tables in generated schema script is fixed (R5481)
-
OdbcException on importing data from ODBC driver is shown in a message box now (T34900)
5.0.54 09-Nov-11
User-reported bug fixes
-
Hanging of the application on sorting data in the Foreign key Lookup editor of Data
Editor is fixed (R3539)
-
Refresh command is added for the Query Builder document to refresh objects on the
diagram (T32015)
-
The Issue with server-side sorting and filtering in Data Editor is fixed (R4336)
-
The Issue with a table locked by a server in Data Editor is resolved (T32566,
T31856)
-
NullReferenceException on editing data in Data Editor is fixed (T32173, T32138,
T32104)
-
NullReferenceException on opening a SQL file by drag'n'drop operation is fixed (T32362)
-
NullReferenceException on pressing the Enter key in Data Editor after inserting
a new record is fixed (T32393)
-
The Issue with debugging a procedure that contains the "SET autocommit" statement
is fixed (R3810)
-
The wrong behavior of the Continue button in the error message appeared during
script execution is fixed (R3691)
-
OutOfMemoryException on changing a page in Data Editor is fixed (R3508)
-
NotImplementedException on refreshing events in Database Explorer is fixed (T32833)
-
The Issue with connecting to MySQL server using SSL tunnel is fixed (T32811)
-
ArgumentOutOfRangeException on switching from the Text view to the Design view in
a SQL document is fixed (T32360)
-
The Issue with the name of the temp procedure is fixed (R4215)
-
The Issue with showing the Product Update dialog behind of the main form is fixed
(T33358)
5.0.50 05-Oct-11
User-reported bug fixes
-
The Issue with changing database for a document is fixed (R3338)
-
InvalidOperationException on deleting a record in Data Editor is fixed (T31439)
-
The Issue with navigating to the found object in the Find Object Results window
is fixed (R2478)
-
OutOfMemoryException on backing up a database is fixed (T30188)
-
The Issue with showing context menu in the Database Designer on working with two
monitors is fixed (R3951)
-
Incorrect behavior of Code Debugger with the SET AUTOCOMMIT statement is fixed
(T32554)
-
InvalidCastException on pasting LONGBLOB data in Data Editor is fixed (R3507)
-
Wrong behavior on deleting a parameter in a procedure editor is fixed (T31865)
-
NullReferenceException on showing data in Data Editor is fixed (T31832)
5.0.48 26-Aug-11
User-reported bug fixes
-
UriFormatException on saving an SQL file on a mapped network drive is fixed (T30092)
-
OutOfMemoryException on backing up a table with large average record size is fixed
(T30188, T31332)
-
ObjectDisposedException on executing a script in a SQL document is fixed (T31081)
-
The Issue with windows layout on x64 operating systems is fixed (T31293)
-
The syntax error on showing a foreign key lookup editor in Data Editor is fixed
(T30438, T30404, T30462)
-
ArgumentException on editing of several records in Data Editor is fixed (T31478)
-
The Issue with importing data from ODBC is fixed (T31433)
-
ArgumentException on importing data through the console with the specified connection
name as an argument instead of a connection string is fixed (T31433, T31579)
-
NullReferenceException on switching to the Data document view in the SQL document
is fixed (R2311)
-
The Issue with changing the "Unique" property of a column is fixed (T30482)
-
NullReferenceException on backing up a database on the previously modified connection
through the console is fixed (T30487)
-
ArgumentOutOfRangeException on exporting data to SQL is fixed (R3277)
-
The error report on debugging a stored procedure on a stopped MySQL server is fixed
(T30506)
-
Bad performance on server side sorting in Data Editor is fixed (T31581, T31511)
-
ArgumentOutOfRangeException on searching in Data Editor is fixed (T31142)
5.0.40 13-Jul-11
User-reported bug fixes
-
The error when working with Object Viewer and user without privileges is fixed (R1753)
-
InvalidCastException on paste data into the Data editor is fixed (R2050)
-
The Issue with copying column in the table editor was fixed (T30126)
-
IndexOutOfRangeException when drag'n'dropping objects onto Database Diagram is fixed
(T30116)
-
The Issue with losing procedure's text with some syntax clauses is fixed (T30317)
5.0.37 23-Jun-11
User-reported bug fixes
-
NullReferenceException on adding/removing select list items in table wrapped to
subquery is fixed (T29303)
-
The Issue with spoiled data after data synchronization is fixed (T29750, R1074)
-
NullReferenceException on switching to Design document view in SQL documents is
fixed (T29871, T29992)
-
NullReferenceException on showing data in Data Editor is fixed (T29872)
-
The list of editable session variables is expanded (R1818)
-
NullReferenceException on pasting large text to an SQL document is fixed (T29893)
5.0.36 16-Jun-11
User-reported bug fixes
-
Incorrect host name displaying in Data Comparison wizard is fixed (T29591)
-
NullReferenceException on refreshing data in Data Editor is fixed (T29562)
-
InvalidCastException on selecting content for backing up a database is fixed (T29505)
-
ArgumentOutOfRangeException on loading a SQL file is fixed (T29427)
-
Incorrect order of objects on generating objects schema is fixed (T29335)
-
NullReferenceException on fetching data after designing a query is fixed (T29277)
-
ArgumentNullException on trying to edit privileges for a connection is fixed (T29265)
-
Incorrect warning on comparing data of BIT fields is fixed (R891)
-
Encoding utf8mb4 is now supported (R890)
-
Incorrect order of statements in schema synchronization script is fixed (R883)
-
InvalidOperationException after editing data in Object Viewer is fixed (R875)
-
Issue with building a database project with disabled "Load completions from database"
option is fixed (R871)
-
The Cancel button is now the default one in dialog about uncommitted changes in
Data Editor (R870)
-
Annoying notifications in Data Editor are fixed (T28861)
-
ArgumentOutOfRangeException on renaming a procedure in Database Explorer is fixed
(T29039)
-
Issue with exporting decimal data is fixed (R860)
-
Unnecessary warnings about exceeding data size during data comparison are removed
(T29750)
5.0.33 18-May-11
User-reported bug fixes
-
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 application is fixed (T28344)
-
Lost connection on executing SLEEP function in SELECT statements is fixed (S12783291)
-
Application hanging on working with irresponsible server is fixed (S12782055)
-
ExternalException on operating clipboard operation in LOB Editor is fixed (T28373)
-
ArgumentOutOfRangeException on displaying view in Object Viewer is fixed (S12791783)
-
Automatic diagram layout on its opening is fixed (S12828929)
-
The Issue 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 Issue 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 synchronizing schema of some procedures is fixed (T28615)
-
The Issue with exporting data from DECIMAL columns is fixed (T28367)
-
NotImplementedException on refreshing triggers collection in Database Explorer is
fixed (T28363)
-
The Issue 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 Issue 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)
5.0.30 27-Apr-11
User-reported bug fixes
-
The Issue with retrieving the running process during product update operation
is fixed (T28124)
-
The Issue with an unreadable content in Excel files created by Data Export tool
is fixed (T27376, T26456, T27435)
-
Hanging of the application on typing a big SELECT statement with enormous number
of WHERE conditions is fixed (T28192)
-
The Issue with Turkish letters on comparing database's schema and project's schema
is fixed (T28274)
-
Extra space before brackets on SQL formatting is fixed (T28282)
-
The possibility to choose database column in Session Manager is added (S12678461)
-
The Issue with losing the focused row on refreshing in Session Manager is fixed
(S12678585)
-
ArgumentOutOfRangeException on typing some specific grammar constructions in SQL
document is fixed (T28218, T28204)
-
The Issue with quoted column identifiers in foreign key definition during schema
comparison is fixed (T28304)
-
ArgumentNullException on refreshing data in Data Editor is fixed (T28311)
5.0.28 19-Apr-11
Connectivity
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 dependents 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 the object 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
4.50.348 31-Mar-11
-
Removing field's autoincrement sign on editing index in a table fixed (S11697967)
-
Syntax error on editing, creating or deleting a trigger fixed (T27508)
-
NullReferenceException on interrupting of query profiling in SQL documents fixed
(T27349)
-
ArgumentException during query profiling in SQL documents fixed (S11328699)
-
Label caption's layout in the trigger editor fixed (T27186)
-
The Issue with updating records on importing data fixed (T27322)
-
OverflowException on working with windows in IDE fixed (T27465)
-
The Issue with incorrect displaying of NULL values in Data Editor fixed (S11495585)
-
Problems with displaying of the Query Profiler document view after executing a query
in SQL Document fixed (S11495585)
-
The Issue with incorrect values for autoincrement TINYINT columns on adding new
record in Data Editor fixed (T27454)
-
NullReferenceException on loading the table editor fixed (T27422)
-
The Issue with some symbols in identifier's names on building queries in Query
Builder fixed (T27310)
-
Displaying 'System.Bytes[]' instead of correct values on some MySQL servers in the
Plan view of Query Profiler fixed (T27297)
-
The Issue with incorrect generating of DEFAULT clauses on schema synchronization
fixed (S11382895)
-
Incorrect behavior on building a query in Query Builder, if it contains USING UTF8
clause, fixed (T26585)
-
ArgumentOutOfRangeException during importing data to MS Excel fixed (T27247)
-
Displaying 'System.Bytes[]' instead of correct values in Session Manager on some
MySQL servers fixed (T27323)
-
NullReferenceException on executing a procedure through the procedure editor fixed
(T27596)
4.50.342 16-Mar-11
-
The error on entering selection criteria after selecting Group By fields in Query
Builder fixed (T26884)
-
The Issue with showing 0 as a parameter value instead of NULL in the parameter
editor fixed (T26867)
-
Removing field's autoincrement sign on adding index in the table fixed (T24859)
-
Extra new line on copying data from a cell in Data Editor removed (T27021)
-
The Issue with losing ON UPDATE CURRENT_TIMESTAMP during editing a table fixed
(T27090)
-
The problems with connecting to MySQL Server via SSH tunnel fixed (T26911, T20079)
-
InvalidOperationExceptions on generating schema synchronization script in the Schema
Comparison tool fixed (T27106, T27108)
4.50.339 02-Mar-11
-
The problem on adding records with autoincrement field in Data Editor fixed (S10516747)
-
InvalidOperationException during schema synchronization fixed (T26493)
-
The Issue with losing procedure's text if it contains LIMIT statement with new
syntax fixed (T26511)
-
NullReferenceException on modifying or saving the text in SQL document fixed (T26446)
4.50.335 18-Feb-11
-
The Issue with updating to the new version of the product fixed (T26476, T26479,
T26473)
4.50.334 16-Feb-11
-
IndexOutOfRangeException on resizing windows fixed (T26293)
-
Unhandled exception on application closing fixed (S9490001)
4.50.331 02-Feb-11
-
Fixed freezing of Query Builder on editing WHERE conditions (T25766)
-
ArgumentException on opening a database project fixed (T25783)
-
InvalidOperationException on evaluating expressions in the debug session (Quick
Info or Watch) with unstable connection to the server fixed (T25657)
-
Fixed freezing of application on typing text in the SQL editor (T25663)
-
Error on editing table data in the Data editor on the MySQL server version 4.0 fixed
(T25679)
-
Issue with Clipboard operations in Data Viewer fixed (T25733)
-
NullReferenceException on the Ctrl+V operation in the Data editor fixed (T25740)
-
Problems with backuping up large amounts of data to a compressed file fixed (T25682)
-
Zip64 format for compressing of a backup file is supported now (S9446335)
-
InvalidOperationException on closing application with the opened Schema Comparison
document fixed (T26010)
-
ObjectDisposeException on closing the application via Task Manager fixed (T25919)
-
Automated determination of secondary screen's absence is supported now (T25919)
-
IndexOutOfRangeException during data comparison of a case sensitive database fixed
(T25882, T25847, T25791)
-
Issue with lost join when working with complex joins in Query Builder fixed (S7174199)
-
Issue with incompatibility of dbForge Studio and other Devart products fixed (T25976)
-
Issue with showing data without formatting for non-unique field names in the executed
SELECT statement fixed (S9384611)
4.50.321 19-Jan-11
-
NullReferenceException after procedure execution fixed (T25594)
-
Issue with the floatable Summary window on the secondary monitor fixed (S8483573)
-
Wrong behavior on generating DEFAULT clause for VARCHAR data type fixed (T25381,
T25571)
-
OutOfMemoryException on showing Quick Info in SQL Editor fixed (T25416)
-
OverflowException on viewing table's properties in the Summary window fixed (T25342)
-
NullReferenceException on showing the Generate Schema Script wizard without any
connection in Database Explorer fixed (T25418)
-
Incorrect evaluation of ROW_COUNT, FOUND_ROWS, LAST_INSERT_ID in the debugging session
fixed
4.50.316 05-Jan-11
-
Sending an extra DROP INDEX statement on altering table fixed (T25204)
-
Fixed Issue with loading an assembly in the Express edition (T25282, T25307)
-
OverflowException on resizing documents in different tabbed groups fixed (T24187)
-
NullReferenceException on opening a saved file with query fixed (T25243)
-
Exception when running an update statement with Chinese data and utf8 encoding fixed
(S7934055)
4.50.315 21-Dec-10
-
Fixed name quotation in the synchronization script after data comparison (T24989)
-
Fixed InvalidCastException on refreshing data in table editor after editing a table
(T24892, T24139)
-
Added IF EXISTS clause to DROP TRIGGER statement on editing trigger (S7387423)
-
Fixed error report on backing up database with compressing to ZIP64 format (T24741)
-
Fixed NullReferenceException on activating Session Manager after reloading application
(S6506785)
4.50.313 07-Dec-10
-
Fixed NullReferenceException on collapsing node in Document Outline (56493)
-
Fixed NullReferenceException on IDE closing (T24672, T24635, T24057, T24225, T24152,
T23895, T24459)
-
Fixed problems with Web Browser on refreshing, navigating and so on (57419, 57417,
57396, 57418, 57397, 57380)
-
Fixed cleaning of Redo Stack in SQL Editor after mouse click (56690)
-
Fixed IndexOutOfRangeException in Find and Replace (54918)
4.50.311 27-Oct-10
-
Removed spaces in the integer and float format in Data Export wizard (T23612)
-
Fixed NullReferenceException on saving a database project with opened table editors
(T23519)
-
Fixed NullReferenceException on deleting a table from a database with an opened
inactive editor (56081)
-
Fixed NullReferenceException on auto hiding a tool window (T23494)
-
Added possibility to edit a definer for triggers in the trigger editor (T23357)
-
Fixed Issue with BINARY(16) column type on selecting its data to the Data Editor
(T23292)
-
Fixed Issue with empty gray windows after editing a table in the modal editor
from Database Designer (T23164, T23018)
-
Fixed link on the first page in the product tour (55629)
-
Fixed syntax checking for some constructions in CREATE TABLE statements (55161)
-
Fixed lost connection on the data comparing (T22521)
-
Impossibility to disable Code Completion in the Express edition was fixed (54932)
-
Files in database projects are saved with a relative path now (54378)
4.50.308 20-Oct-10
-
Fixed automatic check updates
-
The length of a watch value was expanded to the maximum value 65355 (T23348)
4.50.306 22-Sep-10
-
Fixed updating the stored procedure editor after saving (T18354)
-
Fixed an error in Data Editor (T22099, T22004)
-
Fixed an error on opening the column editor from Database Diagram (T22278)
-
Fixed search canceling in Data Editor when the Esc button pressed (T22354)
-
Fixed Data Import of large Microsoft Excel 2007 files (T22506)
-
Improved displaying ACTION properties of foreign keys (T22539)
-
Enabled the 'Use bulk insert' checkbox when importing data into a new table (54516)
-
Fixed opening connection before restoring a database (T22159)
-
Fixed corrupted statements after commit in Code Completion Window (54930)
-
Fixed an error on trying to edit a stored procedure in the opened editor if the
procedure contains regions in the body (54223)
-
Fixed InvalidOperationException on opening user function in the editor (T21888)
-
Fixed corrupting statements in Query Builder (T21893)
-
Fixed inability to stop Code Debugger by the Stop button (55167)
-
Now .NET Framework 4.0 is supported (54701)
4.50.303 29-Jul-10
-
Fixed incorrect display of Product Tour on Windows 7 (T21994, T21986)
-
Fixed backup process hangup after it was canceled
-
Fixed error on deleting of column on mapping page in Data Import wizard
-
Fixed a couple problems with text markers in the data import from text file
4.50.300 19-Jul-10
New Features
Product Tour has been totally redesigned to provide more flexible navigation to
topics.
User-reported bug fixes
-
T12461 incorrect results of SQL Refactoring in database project
-
T20514 Stopping Code Debugger do not stop it
-
CR53409 Issue 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 Issue 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 Issue 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 Issue with code debugger on procedure renaming
4.50.285 24-Jun-10
-
Fix of InvalidCastException on opening tables node in Database Explorer (T19199,
T19210, T19284)
-
Fix of parameter count mismatch on debugging a procedure (53452)
4.50.282 23-Jun-10
Extended Express Edition
The following tools are added:
-
Session Manager
-
Server Variables
-
Table Maintenance Wizard
-
Flush dialog box
-
Database Backup Wizard with some limitations. It does not support command line,
backup projects, autodeletion of old backup files, compression, and backup files
larger than 1 MB.
-
Database Restore Wizard
Besides, Database Designer now supports 10 tables and Query Builder can work with
3 tables.
Redesigned Database Backup Wizard
Schema Export wizard has been totally redesigned to provide more freedom for backing
up schemas. It features the following:
-
Capability to save backup options for future use
-
Support of command line interface. You can back up schemas in automatic mode using
Windows task scheduler
-
Automatic archiving of schema backup scripts
-
Writing a report about backup process into a log file
-
Automatic removing old backup files based on date or quantity
New tool for database developers - Query Profiler
dbForge Studio offers results of internal MySQL tools like SHOW PROFILE and EXPLAIN
in a convenient and clear GUI. Besides you get STATUS variables for the required
query automatically calculated.
Additional benefits:
-
Plan of the query displayed in the tree view for easy review
-
Profiling history that can be saved for further analysis
-
Capability to compare profiling results in two clicks
-
Capability to print profiling results
Revised Data Comparison tool
Diverse testing and close interaction with database developers, admins and casual
users resulted in thoughtful redesign and enhancement of Data Comparison tool. Now
it embraces the following:
-
Capability to compare and synchronize database of any size
-
Increased performance of comparison processes
-
Generating accurate comparison reports in HTML and Excel formats
-
Capability to change synchronization direction in one click
-
New comparison options: Ignore columns by mask, Ignore trailing spaces, Round float
types
-
Quick filtering tables in comparison results
-
Optimized object management during custom synchronization
-
Capability to edit values of default comparison options
-
New synchronization option Exclude Comments
Improved Query Builder tool
Meet a stronger Query Builder tailored for creating complex conditions with several
clicks. The new power is based on the following:
-
Optimized usability of the Selection tab in the expression editor
-
New Wrap to Subquery option to wrap tables into a subquery
-
Visual addition of subqueries to any part of the main query
-
Optimized navigation in the editor, particularly between subqueries
-
Capability to edit view location in the query document
-
Joins show connection direction; better described connection properties
-
New skin for objects on the diagram
Quick generation of template SQL scripts for database objects
Thanks to this new functionality, you can save your time while working with database
objects. For example, you can quickly generate template SQL scripts CREATE, DROP,
SELECT, INSERT, UPDATE or DELETE scripts for tables. This option is available in
the context menu and called "Create Script As".
A few improvements in Schema Comparison tool
-
Extended capabilities of Schema Comparison wizard
-
New comparison options to ignore some table options, DEFINER and SQL SECURITY expressions,
default values for columns
Other improvements
-
New SQL document view layout - now you can see query text and retrieved data at
the same time
-
Generate DDL wizard was renamed into Generate Schema Script
User-reported bug fixes
-
T13265 Transport channel is closed
-
T10434, T10619 IndexOutOfRangeException on comparing data
-
CR51988 Error on foreign keys editing in Database Explorer window
-
T13766, T15231 ArgumentNullException at System.Windows.Forms.DataObject.SetText on
working with Data Editor
-
T13619 Support of command line functionality for x64
-
T13003 The record pointer moves out of the actual edited record when Ctrl+0 was
pressed (fill field with NULL)
-
T13110 Reset of VARCHAR column length to 20 in Column Editor on length editor focusing
-
CR51956 Incorrect displaying datetime values in Data Editor
-
T14852 Incorrect display of application toolbars on some operating systems
-
T12555 NullReferenceException on generating schema comparison reports
-
T13445 Generating a wrong SET NAMES statement
-
T12968 Inability to export data to Excel
-
CR49793 Removing two parameters in Parameter Editor on pressing the Del key
-
T9796, T10352, T10942 Missing SQL Profiler functionality
-
T9830, T10951, T11289 Missing script generating for objects (select, insert, update,
create, drop, etc)
-
CR39462 Missing ignore options for schema comparison
-
CR52697 Table is locked by the server
-
T14848 Generating a redundant synchronization script in Schema Comparison
-
T15166 Expanding a collapsed region in Procedure Editor in case of any error after
procedure compilation
-
T15997 MissingMethodException on showing the Code Completion window in the operating
system without update pack on Microsoft .NET Framework
-
T12461 Leg parameter type case ignoring during procedure comparison
-
T16583, T17758 ArgumentNullException on saving a template with column mapping in
the Data Import Wizard
-
T16250 Slow "Views" node opening in the Database Explorer
-
T15989 NullReferenceException on retrieving data from the Database Explorer
-
T16250 Problems with export data in Swedish format to Excel
4.00.224 15-Apr-10
User-reported bug fixes
-
NullReferenceException on switching view mode in Data Editor was fixed (T10961)
-
Reload of the editor after saving an invalid procedure was removed (T11596)
-
The number of elements in the filter list of Data Editor was increased (T10840)
-
The Issue with inserting a space in the beginning of the line after code uncommenting
in SQL editor was fixed (T10960)
-
The Issue with quotes in table comments was fixed (50507)
-
InvalidCastException on reconnecting was fixed (T11155)
-
Support of UTF-8 for MySQL Server versions prior to 4.1 (50201)
-
The problem of retrieving tables metadata during mapping in Data Compare was fixed
(T10434, T10619)
-
NullReferenceException during opening a database diagram from a demo-project, when
no connection is found, was fixed (T11314)
-
The error on copying data from Data Editor was fixed (T11583)
-
IndexOutOfRangeException on editing invalid SQL statement in SQL document with enabled
autoformatting was fixed (T11034)
-
Command out of sync on query execution was fixed (T10834)
-
Incorrect behavior of undo command in SQL document was fixed (T10960)
-
The problem of data displaying during data selecting from a view was fixed (T11073)
4.00.206 10-Feb-10
User-reported bug fixes
-
NullReferenceException on creating a new procedure in the procedure editor was fixed
(T10370)
-
Application locking up during saving modifications in the table editor was fixed
(T9980)
-
Issue with user privileges during procedure editing was fixed (48968)
-
IndexOutOfRangeException on running data comparison was fixed (T10434)
-
NullReferenceException on showing context menu in Data Editor was fixed (T10427)
-
NullReferenceException on saving a table in the table editor was fixed (T10516)
-
Issue with product installation on some operating systems was fixed (T10353)
-
DBF III with memo is supported (T10286)
4.00.202 26-Jan-10
User-reported bug fixes
-
Capability to set connection encoding to get compatibility with prior product versions
was added (T10131, T8475)
-
NullReferenceException while closing Data view of the document was fixed (T10254)
4.00.200 25-Jan-10
New features and improvements
-
Data import from various formats (Text, CSV, Excel, ODBC, Excel 2007, Access, XML,
DBF) implemented
-
Improved work with Data Editor
-
Pivot Grid for data analysis was added
-
Data Reports functionality was added
-
Capability to create virtual relations on Database Diagram was added
-
Capability to generate schema comparison reports
-
Customizable product updates check, downloading and installation
-
Product installation was redesigned to allow product updating without uninstalling
a previous version
-
Enhanced management of schema comparison results
-
Capability to add an SQL-filter to every pair of tables, while comparing data, was
implemented
-
Capability to ignore triggers during data synchronization was added
-
Design of Procedure editor wad extended, capability to edit procedure parameters
was added
-
While working with an SQL document, it is easy to set a database for script execution
-
A mechanism to renew a server connection after its break was implemented
-
Interaction between database connections and a MySQL service in Service Manager
was improved
-
Multiple usability improvements throughout the application
3.60.379 24-Nov-09
User-reported bug fixes
-
The Issue with procedure or function parameters parsing was fixed (T9073)
-
Hanging after Copy-Paste operations in the SQL document was fixed
3.60.376 12-Nov-09
-
Execute timeout setting works properly during editing objects or executing scripts
(T7607)
-
New connection encoding mode compatible with connection properties in prior product
versions was added (T8475, T8722)
-
Error with names in mixed-case while working with Database Diagram was fixed (46678)
3.60.368 22-Oct-09
User-reported bug fixes
-
Syntax check fixes(T7912, T7127)
-
All the styles of the text editor, including numerical ones, are applied during editing
from the Options window (45304)
-
Hang-up on getting Quick Info while editing some procedures was fixed (T7660, T7864,
T7679)
-
NullReferenceException during opening documents was fixed (T7577)
-
InvalidOperationException during working with Database Diagram (T7314) was fixed
-
Characters are correctly displayed with any selected encoding (T7430, T8234, T8173,
T7484)
-
Commands work correctly during toolbars customization (T5201)
-
NullReferenceException while using "Best Fit" option for multiple data set was fixed
(T6971)
-
Data vanishing from adjacent cells in Data Editor during copy-paste operations was
fixed (T7454)
-
Now if creating table's index command takes a long time, Execute timeout value specified
for the selected connection is applied (T7607)
-
Now keys generated by PuTTY are supported without conversion into an OpenSSH-supported
format (T7582)
-
Clear Type was supported in Database Diagram (T8338)
-
Fixes in employing HTTP-tunneling (T8213, T8161)
-
Data Export feature was added in Express edition
3.60.36 16-Sep-09
User-reported bug fixes
-
TargetInvocationException occurs arbitrarily when performing various actions (T7314)
-
Fix of NullReferenceException on Data Compare result document showing with "Automatically
adjust column width" option enabled (44420)
-
Fix of NullReferenceException on working with MySQL Server version less than 4.0
and with "Detect MySQL character set" option enabled (44059)
-
Issue with editing data in Data Editor with enabled paginal mode was fixed
-
Bugs with INSERT options in Schema Export were fixed
-
Bug with the auto increment value generation during editing data was fixed (T7182)
-
Issue with setting connection character set was fixed (44067)
3.60.351 28-Aug-09
User-reported bug fixes
-
Schema Compare skips differences between AVG_ROW_LENGTH values in code viewers (T6118)
-
Issue with inserting data into TEXT fields by LOB Editor fixed (T7011)
-
Issue with connecting to some SSH servers fixed
-
NullReferenceException on working with Summary Window fixed (T6969)
-
NullReferenceException on best fit columns with multiple results in the Data Editor
fixed (T6971)
-
Bug with moving tables on the Database Diagram after modification fixed (T6769)
3.60.347 12-Aug-09
New features and improvements
-
New HTTP tunneling is implemented
-
Public key authentication for SSH connection is supported
-
More flexible setting of connection character set is implemented
-
Performance on large databases has been improved
-
Stored procedures are executed asynchronously now
-
Retrieving data from tables has become more faster and convenient
-
Database connectivity was optimized. Better performance while opening connections,
managing database objects, doing schema and data export.
User-reported bug fixes
-
Issue with executing stored procedures by limited user was fixed (T6061)
-
Issue with mixed case of column names was fixed (T6107)
-
Schema Compare skips differences between AVG_ROW_LENGTH values (T6118)
-
CryptographicException on loading connections was fixed (T6228)
-
Possibility to change file encoding in Schema Import and Execute Wizard was added
(T6387)
-
LOAD DATA LOCAL INFILE statement is now supported (T6448)
-
Issue with regional value of decimal separator during data copy from Data Editor
was fixed (T4656)
-
Bug with adding AUTOINCREMENT column was fixed (T6039)
-
NullReferenceException on renaming the table which is displayed in the Database
Diagram document was fixed (T6502)
-
NullReferenceException on exporting data from Data Editor was fixed (T6688)
-
ArgumentException in Summary Window when a node in Database Explorer has been selected
was fixed (T6771)
3.50.310 25-Jun-09
User-reported bug fixes
-
Issue with editing of some procedures was fixed (T5860)
3.50.305 23-Jun-09
User-reported bug fixes
-
Issue with obtaining the SQL code for procedures was fixed (42100)
-
The bug with application hang on parsing some view texts was fixed (41333)
-
The "Stop" button that stops query executing is working correctly now (41292)
-
The bug with removing of a procedure during its renaming was fixed (41284)
-
IndexOutOfRangeException on working with identifier's aliases in SELECT statements
was fixed (41712)
-
IndexOutOfRangeException during tables editing was fixed (41716)
-
The Issue with incorrect detection of relations between tables in Database Diagram
was fixed (41799)
-
NullReferenceException on closing an SQL document was fixed (41876)
-
NullReferenceException on project opening was fixed (41458)
-
The Issue with the unsaved "Use Unicode" option in connection properties was fixed
(41427)
-
NullReferenceException and InvalidOperationException on closing the application
were fixed (41864)
-
The Issue with truncating data of the UTF8 database after editing in LOB editor
was fixed (T5219)
-
ObjectDisposedException on the automatically hidden tool window display was fixed
(41299)
3.50.29021-May-09
User-reported bug fixes
-
NullReferenceException on closing SQL document after work with query builder was
fixed (41213)
-
Wrong data result on SELECT executing in Paginal Mode was fixed (41199)
-
Shortcuts in SQL editor of trigger and view editor are working now (41138)
-
Blank Security Manager after changing connection's property was fixed (41135)
3.50.287 12-May-09
User-reported bug fixes
-
Issue with showing appropriate editor in the Data window for DATETIME columns
fixed (40731)
-
Bug when another constraint has been added to tables which located on different
containers in the Database Diagram fixed (40770)
-
Data Export to HTML is working with Unicode now (40871)
-
Bugs in DDL generation for tables with DATETIME columns fixed
-
Bug with importing settings that had been saved in 3.10 fixed (40885)
-
NullReferenceException related to closing of the database object document in the
Express edition fixed (40886)
-
Application hang-up on Paste operation in stored procedure editor fixed (41004)
-
NullReferenceException when reopening pinned document from Database Diagram fixed
(41008)
3.50.275 23-Apr-09
New features and improvements
-
New database diagram
-
Custom mapping of tables, columns, and views with different names available
-
Custom mapping of columns with different types added
-
Capability to map a table and a view added
-
Capability to cancel custom mapping and return to the automatic one added
-
Detailed information about each mapped column and warnings before synchronizations
shown
-
The Find box for quick search of objects added
-
Extended filtering of objects by their status added (the following are available:
valid or invalid mapping, auto or user mapped, fully or partially mapped, included
or excluded in comparison)
-
Ignore Case, Ignore Spaces, Ignore Underscores mapping options added
-
Data comparison speed boosted 5-10 times
-
Filtering schema comparison results by object type, update operation,
or status
-
Quick search by object name in schema comparison results added
-
Grouping by comparison difference type or update operation added
-
Capability to cancel grouping
-
Preview of the synchronization script for any object in the schema comparison results
implemented
-
Execute Script Wizard added to execute large SQL scripts
-
Use Compression setting added to connection
-
Many other improvements
3.10.22 26-Feb-09
User-reported bug fixes
-
Issue with retrieving data from Database Explorer was fixed (38089)
-
Bugs occurred during removing errors of formatting from Error List were fixed (38120,
38124)
-
Bug on creating procedures with comments was fixed (38122)
3.10.225 12-Feb-09
User-reported bug fixes
-
'Cannot access a disposed object' error is fixed while working with windows (37379)
-
NullReferenceException error is fixed while closing the document (35195).
-
NullReferenceException error is fixed while getting data in Data Editor and scrolling
simultaneously (36252).
-
Unicode data output in LOB editor is fixed
-
Issue with changing connection string was fixed (36547)
-
Bug with debug starting on the server in replication slave mode was fixed (37198)
-
Bug with executing or debugging procedure which include BIGINT UNSINGED parameter
was fixed (37200)
3.10.222 12-Jan-09
User-reported bug fixes
-
Bug with end date in event editor was fixed (35582)
-
Issues with generation database export file were fixed (34262)
-
Many other small improvements.
-
NullReferenceException on using horizontal scroll bar in Data Editor was fixed (36252)
-
Procedure's input parameters are saved in the procedure editor between executions
now
-
Issue with syntax error when deploying debug engine fixed
-
NullReferenceException after text replace operation fixed
3.10.209 17-Dec-08
User-reported bug fixes
-
Bug with showing second popup menu in left-top corner on any grid was fixed (35288)
-
Issues on Text Comparison module load failure were solved (35118)
3.10.205 08-Dec-08
New features and improvements
-
Projects can have different connections for different configurations
-
Incremental database project synchronization with the server
-
Database object dependencies are now considered when generating scripts with Generate
DDL, Schema Export, New Project, and Schema Synchronization wizards.
-
SQL Editor performance increased
-
Filter toolbar added to the Error List window
-
Sample database project added to the installation
3.00.192 06-Nov-08
User-reported bug fixes
-
NullReferenceException on text editing in the text editor is fixed (33628)
-
Lost connection while running the query was fixed (33520)
-
KeyNotFoundException on text editing in the editor is fixed (33546, 33682, 33844)
-
Exception during clipboard operations is fixed (29068)
-
NullReferenceException during exporting geometry data is fixed(33255)
-
NullReferenceException on open schema comparison file without connection or with
modified connection's properties was fixed (32500)
-
Issue with automatic changing connection timeout was fixed (33465)
-
Issue with adding additional symbols in the text of procedure during opening procedure
editor was fixed (33435)
-
SQL formatting errors were fixed (32352, 33413, 33599, 33611)
-
Reference resolving error when building project was fixed (33560)
3.00.183 18-Sep-08
-
Forced capitalization when saving a procedure fixed
-
NullReferenceException when trying to open a schema comparison fixed (32500)
3.00.14 01-Aug-08
New features and improvements
-
MyDeveloper Studio becomes dbForge Studio for MySQL
-
Product divided into Express, Standard, and Professional editions.
-
Database Project enhanced
-
Schema comparison tool added
-
Data comparison tool added
-
SQL Code Formatting added
-
SQL syntax check supported
-
SQL refactoring added
-
Reference check added
-
Debugger for stored routines and SQL scripts added
-
Brand new Query Builder implemented
-
Project building to a result script
-
A range of data export formats extended
-
Tools for centralized Server Administration and Maintenance added
-
Summary Window added
-
Partitioning support
-
Merge and Falcon table support
-
Import and Export of dbForge Studio for MySQL Settings
-
Context-sensitive help revised and improved
-
Many other improvements
2.10.78 09-Jan-08
User-reported bug fixes
-
Bug fixed with default shortcut schema loading (25263)
-
Bug fixed with generic error in GDI+ (24902)
-
NullReferenceException when fulfilling data export fixed (25264)
-
NullReferenceException when retrieving data fixed (24961)
-
NullReferenceException when working with code templates fixed (24901)
-
NullReferenceException when file saving fixed (25394)
2.10.77 05-Dec-07
User-reported bug fixes
-
Bug fixed with exception on application loading under Framework 2.0
-
Bug fixed with installation process suspension under Framework 2.0
-
Bug fixed with breakpoints validation(23587)
2.10.76 26-Nov-07
User-reported bug fixes
-
Bug fixed with InvalidOperationException when stopping the server (24110)
-
Bug fixed with decimal type fields scale parameter (24203)
-
Bug fixed with generic error in GDI+ (24466)
2.10.74 23-Oct-07
New features and improvements
-
Support for autoincrement in BIGINT columns
-
Support for UTF-8 Encoding in database export (23944)
Bug fixes
-
Bug with ArgumentOutOfRangeException in QueryBuilder is fixed (23954)
-
Bug fixed with displaying of several foreign keys in the table
-
UTF-8 Encoding is supported in database export (23944)
-
Exception when inserting text to the stored procedure text editor is eliminated
(23904)
2.10.71 02-Oct-07
Bug fixes
-
Bugs with foreign keys modification and creation is fixed (23722, 23724)
-
Bug with expanding tables or views in the Database Explorer is fixed (23751)
-
Bug with exception in Table Maintenance wizard is fixed(23787)
2.10.68 20-Sep-07
New features and improvements
-
Code template preview added, template system usability improved
-
Navigation history added to Database Explorer
-
Column type and size can be displayed in Database Explorer
-
User comments for tables columns supported
-
SQL Log output customization supported
-
Setting of Date format can be fulfilled in Data Editor
-
Start Page added
-
Many other improvements
2.00.49 06-Jul-07
Bug fixes
-
Issue with encoding 'Chinese Simplified (GB2312)' during execute fixed is fixed
-
Automatic indentation bug fixed in SQL editor
-
Bug fixed with arithmetic overflow/underflow on font initialization (FixFPU)
-
ArgumentOutOfRangeException during column check in the Query Builder Form bug fixed
-
NullReferenceException on query execution fixed
-
DllNotFoundException on connection refresh fixed (embedded server)
2.00.48 05-Jun-07
Bug fixes
-
Cannot access a disposed object bug fixed (20693)
-
Bug fixed with "JOIN" statements parsing (20788)
-
Now engine is always added in the table DDL (20789)
-
NullReferenceException on submenu popup fixed (20861)
-
NullReferenceException in Security Manager fixed (20862)
-
Class not registered exception on showing Contents window fixed (20860)
-
Bug fixed in Query Builder with changing table aliases from text (20978)
-
NullReferenceException on Undo in stored procedure editor fixed (20979)
-
Incorrect behavior of the AutoHide menu in the Windows menu fixed
2.00.36 07-May-07
New features and improvements
-
Stored function and trigger debugging enabled for MySQL server version 5.1.13 and
higher
-
Stored procedure compilation bugs fixed. Improper exception handler parsing. (20535,
20537)
-
Breakpoint validation added for stored routines that does not contain debug info
2.00.35 26-Apr-07
Bug fixes
-
Bug fixed with debugger hanging on MySQL server under Linux
-
Bug with parsing INT UNSIGNED procedure parameter fixed (20463)
-
Several minor bug-fixes
2.00.34 20-Apr-07
User-reported bug fixes
-
Bug with opening tables in Database Explorer is fixed. Overflow exception. (20033)
-
Bug ith closing document during data fetch is fixed (19993)
-
Bug fixed with table dependencies in New Project Wizard (19892)
-
Bug fixed with default values for auto increment fields
-
Documentation revised
-
Many other bug fixes
2.00.31 06-Apr-07
New features and improvements
-
Stored routines and SQL debugging support
-
Context-sensitive code completion
-
Code navigation and quick info
-
Project support
-
Fully customizable keyboard mapping schemes
-
Completely redesigned Security Manager
-
Table maintenance, flush and server variables support
-
Extended object search
-
MySQL service manager
-
Event object support
-
Session manager
-
Text editor syntax customization
-
Code templates
-
Document outline window
-
Data printing supported
-
Card data view added
-
View data as text feature
-
Pin/unpin document feature
-
Many other improvements
1.51.33 18-Sep-06
Bug fixes
-
Bug with dropping current database fixed
-
Bug in SQL document with opening design view if text view is not visible fixed
1.51.32 25-May-06
Bug fixes
-
Output overflow bug fixed
-
Bug with storing connection options fixed
-
Bug with opening an icon file in the LOB viewer is fixed
1.51.30 21-Apr-06
New features and improvements
-
Large database import improved
1.50.24 26-Jan-06
New features and improvements
-
Bug with stop execution fixed (9504)
-
Bug with refresh node after lost connection fixed (8871)
-
CASE WHEN clause supported in parser (9804)
-
Read-only files saving enabled (8470)
-
Minor SQL editor improvements
-
Inserted row is not removed now when apply changes fails (9714)
-
Begin transaction when connection is lost bug fixed (10022)
-
Data window observer mode bug with invalid view fixed (9875)
-
Query builder bug with invalid names in generated text fixed (9805)
-
Bug with trying to use Import(Export) without connection fixed (9985)
-
A few Data view and parameter editor bugs fixed
1.50.2 03-Nov-05
Bug fixes
-
Security problems in Generate DDL wizard fixed
-
Bug with default value for auto-increment column fixed
1.50.22 03-Nov-05
New features and improvements
-
User and privileges management support
-
Database export/import to/from SQL script
-
Trigger support
-
Script support
-
Stop execution feature
-
Execution of the selected SQL fragment feature
-
Data Export feature
-
Dynamic data viewing of the tables and views in DbExplorer
-
Paginal data access mode
-
LOB viewer/editor
-
Database object search
-
Secure SSL and SSH connections support
-
Query plan tool
-
Duplicate object feature
-
DDL generation wizard
-
Embedded server support
-
Data grid colors customizing
-
Tabbed groups for documents
-
Drag-n-drop files from shell
-
Many other improvements
1.0.5 16-Sep-05
User reported bug fixes
-
Bug with generating text of the stored function parameter list fixed. (7255)
-
Edit PrimaryKey from column editor bug fixed. (8240)
-
Duplicate entry bug on tables having auto-increment fields fixed. (8198)
1.0.4 10-Jun-05
-
SQL editor speed increased.
-
Bug with altering stored procedure on MySQL server 5.0.3 and higher fixed.
1.0.3 19-May-05
Bug fixes
-
Bug with "camel-cased" tables on Linux server fixed.
-
Help->Index menu item now points to correct window.
1.0.2 04-May-05
Programs menu shortcut changed.
1.0.1 25-Apr-05
New features and improvements
-
Documentation in HtmlHelp 1.x format added
1.0.0 12-Apr-05
-
First release of MyDeveloper Studio.
© 2025 Devart. All Rights Reserved.