dbForge Studio for MySQL History

5.0.63 13-Jan-12

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 behaviour on workng with the filter in a pivot table is fixed (R5045)
NullReferenceException on filtering data in Data Editor is fixed (T35232, T34698)
Incorrect behaviour on ingoring 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 (T32531, 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 behaviour 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

A problem 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)
Problem 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 behaviour of the filter in Pivot table is fixed (R5045)
Problem 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 ODCB driver is shown in a message box now (T34900)

5.0.54 09-Nov-11

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 problem with server-side sorting and filtering in Data Editor is fixed (R4336)
The problem 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 problem with debugging a procedure that contains the "SET autocommit" statement is fixed (R3810)
The wrong behaviour 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 problem 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 problem with the name of the temp procedure is fixed (R4215)
The problem with showing the Product Update dialog behind of the main form is fixed (T33358)

5.0.50 05-Oct-11

The problem with changing database for a document is fixed (R3338)
InvalidOperationException on deleting a record in Data Editor is fixed (T31439)
The problem 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 problem with showing context menu in the Database Designer on working with two monitors is fixed (R3951)
Incorrect behaviour of Code Debugger with the SET AUTOCOMMIT statement is fixed (T32554)
InvalidCastException on pasting LONGBLOB data in Data Editor is fixed (R3507)
Wrong behaviour 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

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 problem 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 problem 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 problem 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

The error when working with Object Viewer and user without privilegs is fixed (R1753)
InvalidCastException on paste data into the Data editor is fixed (R2050)
The problem with copying column in the table editor was fixed (T30126)
IndexOutOfRangeException when drag'n'dropping objects onto Database Diagram is fixed (T30116)
The problem with losing procedure's text with some syntax clauses is fixed (T30317)

5.0.37 23-Jun-11

NullReferenceException on adding/removing select list items in table wrapped to subquery is fixed (T29303)
The problem 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

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 priviliges 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 statemetents in schema synchronization script is fixed (R883)
InvalidOperationException after editing data in Object Viewer is fixed (R875)
Problem 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 uncommited changes in Data Editor (R870)
Annoying notifications in Data Editor are fixed (T28861)
ArgumentOutOfRangeException on renaming a procedure in Database Explorer is fixed (T29039)
Problem 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

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

5.0.30 27-Apr-11

The problem with retrieving the running process during product update operation is fixed (T28124)
The problem 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 enourmous number of WHERE conditions is fixed (T28192)
The problem 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 problem 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 problem 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

Support for MySQL server 5.5

Our product is fully compatible with MySQL server version 5.5

New features were added and obsolete clauses removed in the Syntax check functionality
New encodings were added to the encoding list in the Connection Properties dialog
New kinds of partitioning are supported in the table editor

Master-detail Browser

Explore and analyze master-detail data in a convenient browser with the following features:

Design view allows building relations between tables with setting where condition and fetch limit, choosing fields for output, and sorting them by default
Data of the parent table/view is shown in the upper part of the Data view to allow analyzing data of child tables/views without extra navigation.
The document allows saving and loading data and diagram for future use
Sorting and filtering data in the Data view
Ability to analyze self-referencing tables

Object dependency tree - unique feature

Easily explore object's references and dependants in Database Explorer.
Compilation of dependants for debugging is now also available through the object's context menu.

Enhanced Data Editor

Newly added features and a few totally redesigned ones provide even more freedom when working with data.

Foreign Key lookup editor added
Server-side sorting and filtering implemented to avoid retrieving all data from the table and enhance work in Paginal Mode
A few indications added to inform user about Data Editor's state
Editing of tables in join statements is enabled now
Option for numbering records added
Copy data with header functionality added
Ability to build graphical representation of your data with fully functional wizard added

Improved Security Manager

Ability to edit permissions for several users added
Virtual roles for users were added to allow granting a definite set of permissions to selected users
Grouping by hosts in the users list tree added
Editing users and working with Security Manager window simplified

Data Export and Import improvements

Ability to export data from several tables at once added
Exporting data from command line added
Importing data from command line added

Object Viewer - a simple way to view object's details

Object Viewer (formerly known as Summary Window) was totally redesigned to provide an easier way for analyzing objects and their structure:

There are three views to display properties, DDL (text), and data of the selected object
Inner navigation through object hierarchy
History with previously viewed objects
More information about each object is displayed in the Properties view now

Brand new start page

New functional start page providing the easiest way to learn the product's features and to run the most frequently used ones added.

New state-of-the-art skins

Four new UI skins added to improve the application appearance.

Other improvements

Ability to view internal SQL queries that are sent to the server with parameter's values added
A few UI improvements in Database Explorer were made
Options to ignore clauses during the comparison of events added to the Schema Comparison wizard
Highlighting of differences on comparing SQL profiling results added
More informative progress during Schema and Data comparison

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 problem with updating records on importing data fixed (T27322)
OverflowException on working with windows in IDE fixed (T27465)
The problem 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 problem with incorrect values for autoincrement TINYINT columns on adding new recrod in Data Editor fixed (T27454)
NullReferenceException on loading the table editor fixed (T27422)
The problem 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 problem with incorrect generating of DEFAULT clauses on schema synchronization fixed (S11382895)
Incorrect behaviour 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 problem 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 problem 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 problem with losing procedure's text if it contains LIMIT statement with new syntax fixed (T26511)
NullReferenceException on modifiyng or saving the text in SQL document fixed (T26446)

4.50.335 18-Feb-11

The problem 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)
Problem 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, 25847, 25791)
Problem with lost join when working with complex joins in Query Builder fixed (S7174199)
Problem with incompatibility of dbForge Studio and other Devart products fixed (T25976)
Problem 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)
Problem with the floatable Summary window on the secondary monitor fixed (S8483573)
Wrong behaviour on generating DEFAULT clause for VARCHAR data type fixed (T25381, 25571)
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 problem 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 refreshind 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 problem with BINARY(16) column type on selecting its data to the Data Editor (T23292)
Fixed problem 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 Code Refactoring in database project
T20514 Stopping Code Debugger do not stop it
CR53409 Problem with updating view after saving
CR53449 Query Profiler must show date of profiling result in local format
CR53463 Cannot delete primary key on a column with autoincrement from Database Explorer
CR53472 Disable changing project configuration when building project
CR53497 Problem with backing up through the command line after lost connection
CR53501 InvalidOperationException on executing script in SQL document
CR53573 Unavailable documentation in Schema Compare wizard
T16516 Persistent modification marker in trigger editor after trigger saving
T16516 Problem with temporary procedure on procedure editing
CR53593 NullReferenceException after clearing all in the Where editor in Query Builder
T20339 All routines run twice after session killing
CR53640,CR53641,CR53643,CR53645 Problems with database projects
CR53644 NullReferenceException on getting new results in Query Profiler if the document was opened with the loaded database project
CR53646 Why the Refresh button is disabled after reopen SQL document?
T20888 NullReferenceException on refreshing data in Data Editor
CR53678 Hide password in log file on backing up database
CR53709,CR53719 Problems with navigating to result of data search
CR53720 Do not save opened document views in SQL document
T21284 Display System.Byte[] instead of default values of table columns on MySQL 4.1.x
T10942 Add option to ignore query cache on query profiling
CR53767 Problems with query profiling on MySQL 4.1.x
CR53792 Support relative path of log file in Database Backup Wizard
T21587 When exporting a table or backing up a database, date column is improperly exported/created
CR53843 Current statement marker hides on breakpoint removing
CR53852,53859 Breakpoint in code editor doesn't synchronize with Breakpoints window
CR53853 Problem with code debugger on procedure renaming

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, autodelition of old backup files, compression, and bakup 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 usablility 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 generating 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 diplaying 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

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 problem with inserting a space in the beginning of the line after code uncommenting in SQL editor was fixed (T10960)
The problem 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 behaviour 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

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)
Problem 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)
Problem with product installation on some operating systems was fixed (T10353)
DBF III with memo is supported (T10286)

4.00.202 26-Jan-10

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

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 unistalling 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 usablility impovements throughout the application

3.60.379 24-Nov-09

The problem with procedure or function parameters parsing was fixed (T9073)
Hang 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

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 multipile 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.360 16-Sep-09

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)
Problem with editing data in Data Editor with enabled paginal mode was fixed
Bugs with INSERT options in Schema Export were fixed
Bug with autoincrement value generation during editing data was fixed (T7182)
Problem with setting connection character set was fixed (44067)

3.60.351 28-Aug-09

Schema Compare skips differences between AVG_ROW_LENGTH values in code viewers (T6118)
Problem with inserting data into TEXT fields by LOB Editor fixed (T7011)
Problem 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 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.
Problem with executing stored procedures by limited user was fixed (T6061)
Problem 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)
Problem 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

Problem with editing of some procedures was fixed (T5860)

3.50.305 23-Jun-09

Problem 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 problem 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 problem with the unsaved "Use Unicode" option in connection properties was fixed (41427)
NullReferenceException and InvalidOperationException on closing the application were fixed (41864)
The problem 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.290 21-May-09

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

Problem 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 excellent database diagram added
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 Undercores mapping options added
Data comparison speeded by 5-10 times
Capability to filter schema comparison results by object type, update operation, or status added
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.227 26-Feb-09

Problem with retrieving data from Database Explorer was fixed (38089)
Bugs occured 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

'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
Problem 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 debuging procedure which include BIGINT UNSINGED parameter was fixed (37200)

3.10.222 12-Jan-09

Bug with end date in event editor was fixed (35582)
Some problems with generation database export file were fixed (34262)
Many other small improvements were made.
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
Problem with syntax error when deploying debug engine fixed
NullReferenceException after text replace operation fixed

3.10.209 17-Dec-08

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

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

NullReferenceException on text editing in the text editor was fixed (33628)
Lost connection while running the query was fixed (33520)
KeyNotFoundException on text editing in the editor was fixed (33546, 33682, 33844)
Exception during clipboard operations was fixed (29068)
NullReferenceException during exporting geometry data was fixed(33255)
NullReferenceException on open schema comparison file without connection or with modified connection's properties was fixed (32500)
Problem with automatic changing connection timeout was fixed (33465)
Problem 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.146 01-Aug-08

MyDeveloper Studio becomes dbForge Studio for MySQL
Product devided 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 Code 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

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

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

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

Bug fixed with ArgumentOutOfRangeException in QueryBuilder (23954)
Now autoincrement in BIGINT columns is supported
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

Bugs fixed with foreign keys modification and creation (23722, 23724)
Bug fixed with expanding tables or views in the Database Explorer (23751)
Bug fixed with exception in Table Maintenance wizard (23787)

2.10.68 20-Sep-07

Code template preview added, template system usability improved
Naviagation 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 fulfiled in Data Editor
Start Page added
Many other improvements

2.00.49 06-Jul-07

The problem with encoding 'Chinese Simplified (GB2312)' during execute 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

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

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 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

Bug fixed with opening tables in Database Explorer. Overflow exception. (20033)
Bug fixed with closing document during data fetch (19993)
Bug fixed with table dependencies in New Project Wizard (19892)
Bug fixed with default values for autoincrement fields
Documentation revised
Many other bug-fixes

2.00.31 06-Apr-07

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 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

Output overflow bug fixed
Bug with storing connection options fixed
Bug with opening icon file in LOB viewer fixed

1.51.30 21-Apr-06

Large database import improved

1.50.24 26-Jan-06

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.23 03-Nov-05

Security problems in Generate DDL wizard fixed
Bug with default value for autoincrement column fixed

1.50.22 03-Nov-05

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

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 autoincrement 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 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

Documentation in HtmlHelp 1.x format added.

1.0.0 12-Apr-05

First release of MyDeveloper Studio.

dbForge Studio for MySQL History	dbforgemysql@devart.com
Copyright 2004-2012 Devart. All Rights Reserved.