dbForge Schema Compare for MySQL History

10.0.225 28-Mar-24

User-reported and internal bug fixes

Fixed a syntax error that occurred when using the json_object function on older server versions (D144784, D145530)
Resolved the Studio freeze issue that occurred when parsing a query with a large number of joins (D144992)
Improved the behavior of retrieving metadata about database objects under restricted privilege conditions (D148216)
Fixed a MySQL server connection error that occurred when using the SSL Cipher List parameter
Fixed the issue that prevented table editing for queries involving JOIN operations in the Data Editor
Resolved an issue that occurred when attempting to open a connection to the server while editing script parameters in the SQL Document
Fixed the Lost connection to MySQL server during query error in the stored procedure editor
Fixed an issue with unnecessary quotation marks being added to values when copying data from the Data Editor
Fixed an issue related to computing the insertion position for elements from the Member List

10.0.150 17-Jan-24

Improvements

Added connectivity support for MariaDB 11.4
New Alt + Up/Down Arrow shortcuts for navigating script differences in the lower comparison pane

User-reported and internal bug fixes

Fixed issues that occurred during the synchronization of schemas into project files
Fixed an issue that occurred when running a comparison after saving a .scomp document

10.0.60 20-Nov-23

User-reported and internal bug fixes

Fixed an issue with editing string values in the Data Editor
Resolved an application crash issue when attempting to save a script larger than 2 gigabytes
Fixed an issue with parsing duplicate objects in the script
Resolved the problem with SQL Document freezing during query execution

10.0.46 03-Nov-23

New features

Added support for temporal tables in MariaDB
Supported spatial reference identifiers (SRID)
Introduced a new group of comparison options called Sequences, which includes Ignore CACHE, Ignore CYCLE, Ignore INCREMENT BY, Ignore MAXVALUE, Ignore MINVALUE, and Ignore START
Improved the behavior of the Ignore Permissions option
Added a new exit code 114 for invalid object filters
The object description process now ignores folders with static data, which may contain large files and thus may affect the performance
Added an option to enable/disable the display of DDL differences for pairs of compared objects with the Equal status
Introduced support for ASC and DESC in indexes with functional key parts
Supported an INVISIBLE attribute in CREATE TABLE and ALTER TABLE statements
Added support to save the .scomp comparison document directly from the comparison wizard

Connectivity

Introduced support for Transport Layer Security 1.3
Added support for MySQL v8.2

User-reported and internal bug fixes

Resolved an issue with invoking the popup menu on macOS
Improved data display for the JSON_OBJECT function
Resolved an issue that occurred when establishing an SSH connection to the server
Resolved an issue with updating data cells for TIMESTAMP-type columns in Data Editor
Fixed an error that occurred when editing data in Data Editor
Improved the behavior of Schema Compare to alert users with an error message when duplicate indexes exist in project tables
Fixed an error that occurred during the generation of a synchronization script when connected to AWS RDS for MySQL

5.2.109 14-Sep-23

Improvements

Added support for authentication via AWS Identity and Access Management (IAM)

User-reported and internal bug fixes

Fixed an issue with the SSL connection to the server

5.2.88 17-Aug-23

Connectivity

Added support for MySQL v8.1

User-reported bug fixes

Fixed a typo in the comparison progress output in the command line
Fixed an internal application error in SQL Editor
Fixed an issue that occurred during schema synchronization and added an unnecessary CREATE TRIGGER to the synchronization script

5.2.29 18-May-23

User-reported bug fixes

Facing parsing errors when performing schema comparison for objects containing specific subqueries (D119271, D120251, D120555)

5.2.6 19-Apr-23

Schema Compare

Added support for the UUID Data Type
Added support for the INET6 Data Type
Added support for MySQL functional indexes
Improved the charset comparison
Added quoting of function names being used as table names

Connectivity

Added support for MariaDB v11.3
Added support for Support for Aiven Cloud
Added support for SHA-256/512

Text Editor

Enhanced code completion for application-period temporal tables
Added support for a broader range of optimizer hints
Added support for the VALUES ... ORDER BY ... LIMIT statements
Added support for the TABLE statement
Added support for the EXCEPT and INTERSECT statements
Added support for spatial functions ST_LineInterpolatePoint, ST_LineInterpolatePoints, ST_PointAtDistance and ST_Collect

User-reported bug fixes

Resolved an issue with formatting Boolean literals (D112005)
Fixed an error that resulted in creating an invalid GRANT expression (D98191)
Fixed an error that resulted in creating an invalid FOREIGN KEY CONSTRAINT (D93712)
Supported the precision value outside the range for the TINYINT type (D112364, D113203, D113358, D113399, D113390)
Fixed the comparison of default column values (D98000)
Fixed an error that could occur when generating HTML Comparison Reports through the Command Line (D109741, D111649)
Resolved an issue with table comparison (D109625)
Improved the application behavior when handling UTF-8 encoding (D98191)
Fixed the comparison of tables with auto-increment columns (D94354)
Improved error diagnostics
Fixed an error that occurred when generating a partitioned table script

5.1.16 30-Aug-22

Improvements

Connectivity support for MariaDB 10.10

User-reported bug fixes

Fixed an issue with data modification in tables with an INVISIBLE column in the Data Editor
Fixed a bug that occurred when saving document cache for recovery
Fixed an issue with the synchronization of calculated columns

5.1.7 12-Aug-22

General

Added support for Linux and macOS via CrossOver
Added connectivity support for MariaDB 10.9

Schema Compare

Improved the comparison and synchronization of integer datatypes on MySQL 8.0 and Percona 8.0
Added support for ASC and DESC sorting of index columns

User-reported bug fixes

Fixed issues that occurred when scripting objects whose names match the names of preinstalled server functions
Fixed an issue that occurred when comparing two tables containing foreign keys

5.0.622 20-May-22

User-reported bug fixes

Improved CrossOver compatibility
Fixed schema comparison behavior

5.0.616 12-May-22

User-reported bug fixes

Improved the tab activation behavior when executing queries in a SQL Document
Improved the SSH Protocol configuration form to display the Local port option
Fixed the comparison and synchronization of foreign keys and indexes associated with foreign keys (D68054)
Fixed an issue in the text editor on Windows builds 22567 and higher
Fixed a bug that could occur when switching between pages in the comparison wizard (D67465, D77784)
Fixed an issue with the synchronization of objects with the enabled NO_ZERO_DATE, NO_ZERO_IN_DATE options
Fixed an error that could occur when comparing a database with a script folder
Fixed the behavior of index synchronization

5.0.539 09-Dec-21

User-reported bug fixes

Added support for new privileges during syntax check
Fixed an issue that occurred when generating scripts for tables
Fixed an issue with reading table metadata
Fixed an issue with reading session variables when opening a connection
Improved performance when opening a connection

5.0.533 01-Dec-21

User-reported bug fixes

Fixed a false syntax check that hindered the comparison of views (D60764)
Fixed a synchronization issue for a table with PARTITION BY RANGE COLUMN
Fixed the selection of encoding when writing synchronization scripts to a file
Fixed an issue that occurred when processing scripts containing syntax in versioned comments
Fixed a primary key synchronization issue
Fixed a synchronization issue for a table with partitioning

5.0.491 08-Sep-21

User-reported bug fixes

Fixed an error with reading the default values
Fixed a error with displaying a warning about the absence of unique keys in the Data Editor

5.0.471 05-Aug-21

User-reported bug fixes

Error with quotation of Default values for the ENUM type was fixed

5.0.466 28-Jul-21

User-reported bug fixes

Fixed incorrect work with the default TIMESTAMP column
Fixed a problem with generating a script for virtual columns

5.0.448 8-Jul-21

User-reported bug fixes

Column persistency settings are incorrectly detected within DDL scripts
Error with comparing the DEFAULT value for columns with a BIT(1) data type was fixed
Error with comparing automatically generated index names was fixed
Error with searching dependencies was fixed

5.0.389 22-Apr-21

User-reported bug fixes

Error in ignoring spaces through the command line when working with options (D50899)

5.0.335 02-Feb-21

User-reported bug fixes

Minor user reported bugs are fixed

5.0.318 25-Nov-20

Improvements

Work of the application when connecting via SSL is improved

5.0.293 10-Oct-20

User-reported bug fixes

Error when analyzing index dependencies (T318093)
Incorrect reading of the DEFAULT values if it was not specified as CURRENT_TIMESTAMP() (T317941)

5.0.254 17-Aug-20

User-reported bug fixes

Minor user reported bugs are fixed

5.0.220 07-Jul-20

User-reported bug fixes

Minor user reported bugs are fixed

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

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

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

4.4.32 07-May-19

User-reported bug fixes

Issue with character case is fixed (T272640)
Issue with AUTO_INCREMENT property loosing is fixed (MYS-3203)
Issue with wrong table rebuild is fixed (MYS-2240)
Issue with date format is fixed (MYS-2799)
Minor user reported bugs are fixed

4.4.20 15-Jan-19

Database Connectivity

Support for MariaDB 10.4

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 (MYS-2031)
"Spatial view" mode of Data Viewer issue is fixed (MYS-2000)

4.3.38 20-Nov-18

User-reported bug fixes

Issue with comparing DEFAULT values of a table columns is fixed (T269389)
Issues with connection to MySQL Server are fixed
Issue with comparing database project and database is fixed (T268301)

4.3.37 17-Oct-18

User-reported bug fixes

Issue with application hanging is fixed (T263299)
Other user reported bugs are fixed

4.3.26 14-Aug-18

User-reported bug fixes

Issue with product freeze is fixed
Issue with option Ignore Foreign Key Action is fixed
Issue with NRE is fixed
Event comparison issue is fixed
Issues with lost connection are fixed
Issues with TLS 1.2 connection are fixed

4.3.11 27-Jun-18

Database Connectivity

Support for MySQL Server 8.0
Support for MariaDB 10.3
Support for Tencent Cloud

User-reported bug fixes

Comparison issues are fixed (T257780)
SSH database connection issue is fixed (T260194)

4.2.35 12-Apr-18

Database Connectivity

Support for MariaDB 10.1
Support for MariaDB 10.2
Support for Google Cloud Platform
Support for Alibaba Cloud
Support for Azure MySQL

New features and improvements

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

User-reported bug fixes

Some PowerShell issues are fixed (T246378)
Poor performance issues are fixed (T241611)
Option Ignore Character Set and Collation is added (T234555, T233606, T242565, T24418, T227836)
Option Ignore Foreign Key Rule is added (T224980)
Lost privilege after synchronization issue is fixed (T147793)
Other user reported bugs are fixed (T244105, T243136, T244105, T235991, T223945, T216586, T214246, T211159, T211618, T211834, T213946, T214003, T216161, T217109, T217721, T221073, T92338, 204440, T225748, T230878, T235758, T154742, T98876, T37187)

4.1.10 17-Nov-16

New features and improvements

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
Syntax Check supports new MariaDB 10.0 - 10.1 statements
Styled icons are used by default
User reported issues with DROP INDEX are fixed (T194500, T184623)
Other minor fixes and improvements

4.0.22 23-Sep-16

User-reported bug fixes

Issue with parsing source text is fixed (T188585)

4.0.20 19-Sep-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
Latest MySQL builds are supported

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

4.0.9 26-Feb-16

Database connectivity

Support for MySQL 5.7

Support for computed columns
Support for the JSON Data Type
Support for Spatial Indexes

Other features and improvements

Support for Percona PAM authentication
Support for the Amazon Aurora connection

User-reported bug fixes

Issue with saving 'Look In' option in Find and Replace window is fixed (T122242)
Issue with connection via SSH is fixed (T133379, T133780, T135203, T144325, T156321, T157597)
Issue with text replacement using regular expression is fixed
'Current Document' is selected by default in Find and Replace window
ArgumentException while trying to unlock removed connection is fixed (T140709, T145293)
Issue with ignoring foreign key during schema comparison is fixed (T130146)
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)
COLUMN_GET expressions are recognized correctly (T152603)
ArgumentException while lost connection is fixed (T140016)
Bug when using CAST or CONVERT in stored procedure is fixed (T154606)
Viewing functions in GROUP BY are correct (T155234)
Default path for log is changed

3.3.29 02-Feb-15

New features and improvements

Schema Comparison and Sync

Selecting object types for comparison

SQL Editing and Execution

Command-line interface for SQL formatting
Query execution pane
Option to set files encoding within the /execute command-line operation

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

Other Features and Improvements

Enhanced Find and Replace window
On-line documentation

3.2.19 31-Jul-14

Database Connectivity

Window connection coloring is added

New features and improvements

Switching tabs by the CTRL+ALT+PAGE UP and CTRL+ALT+PAGE DOWN keys combination
Restoring document tabs from the last session is possible now
Switching between wizard window and primary window

3.1.15 05-Feb-14

User-reported bug fixes

NullReferenceException with column names which contain 'virtual' or 'persistent' is fixed (T97218)

3.1.13 30-Jan-14

Database Connectivity

All known MySQL and MariaDB server 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

Pluggable authentication is supported

New features and improvements

The application launch time is decreased
Microsoft Windows 8.1 is supported

User-reported bug fixes

MySQL Embedded 5.6 is supported (R29696)
Incorrect behavior while showing the difference between two objects is fixed (T91476)
Incorrect filter data on choosing Today value in Data Editor is fixed (R31110)

3.0.139 26-Nov-13

User-reported bug fixes

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)
Short names are used now for editing data to avoid Issues with replication (R29645)
NullReferenceException while displaying the Start Page is fixed (T90258, T91547)

3.0.129 22-Oct-13

User-reported bug fixes

An exception while changing a parameter type in the Edit parameters window is fixed (T87420, T87819)
An exception on clicking a splitter button in the Find Results window is fixed (T86371)
A Issue, related to the table columns prompting in the IN statement, in a subquery that contains WHERE condition is fixed (T86470)

3.0.114 25-Sep-13

User-reported bug fixes

NullReferenceException on sorting data in the Data Editor is fixed (T84292, T84287)
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)
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)

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

3.0.96 31-Jul-13

User-reported bug fixes

NullReferenceException 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)
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 navigating in the FKLookup window of Data Editor is fixed (R23530)
Error with suggesting the UNSIGNED keyword in the Code Completion functionality is fixed (R22572)
NullReferenceException in Data Editor on switching view modes with unsaved data is fixed (T74100)
NullReferenceException on working with SQL document is fixed (T72693)
Incorrect behaviour of LOB Editor with unsaved data is fixed (R22597)
Error on line numbering while grouping data in Data Editor is fixed (R23179)

3.0.80 27-Jun-13

User-reported bug fixes

Issue with editing multiline text in a VARCHAR column is fixed (R22636)
Base64 encoding support is added for HTTP tunnel in the connection editor (T71684)
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)
Issue with resetting of toolbar's 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)

3.0.70 23-May-13

User-reported bug fixes

Invalid 'Reset Toolbar Layout' functionality is fixed (R21587)
NullReferenceException on deleting a connection during schema comparison (R22105)
Function GREATEST is added to autocompletion list (R21960)
ArgumentOutOfRangeException on writing a SQL query is fixed (T71402)
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)

3.0.54 22-Apr-13

New features and improvements

SQL Editor

Code completion is added
SQL Code Formatter is added

New window docking system

Switching between tool windows on 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
New skins added (Metropolis and VS2010)

User-reported bug fixes

Incorrect behavior with generating schema update script for selected object in schema compare document is fixed (R13509)
Incorrect CREATE EVENT text on comparing schema is fixed (R3848)
The Issue with describing ON UPDATE CURRENT_TIMESTAMP option is fixed (R2783)
The Issue with retrieving data from a table with datetime field is fixed (T60213)

2.30.49 15-June-12

User-reported bug fixes

Error report when editing grid is fixed (T39998)
"EXECUTE" label is added to the "execute" button (R9992)
Disabling intellisense buttons on change focus from sql document is added (R9996)

2.30.43 21-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)
Issue with HTTP-tunneling is fixed (T38708)
Issue with unexpected focused row in the Data Editor is fixed (T38675)

2.30.42 23-Apr-12

User-reported bug fixes

Issue with foreign key dependencies is fixed (T37748)
Issue with automatically generated indexes is fixed (R7805)
Issue with quoted column in subpartition is fixed (R7541)

2.30.36 13-Jan-12

User-reported bug fixes

InvalidCastException on paste data into the Data editor is fixed (R2050)
ArgumentOutOfRangeException on searching in Data Editor is fixed (T31142)
Bad performance on server side sorting in Data Editor is fixed (T31581, T31511)
NullReferenceException on switching to the Data document view in the SQL document is fixed (R2311)
ArgumentException on editing of several records in Data Editor is fixed (T31478)
The Issue with windows layout on x64 operating systems is fixed (T31293)
ObjectDisposedException on executing a script in a SQL document is fixed (T31081)
UriFormatException on saving an SQL file on a mapped network drive is fixed (T30092)
NullReferenceException on showing data in Data Editor is fixed (T31832)
InvalidCastException on pasting LONGBLOB data in Data Editor is fixed (R3507)
InvalidOperationException on deleting a record in Data Editor is fixed (T31439)
The Issue with changing database for a document is fixed (R3338)
The Issue with showing the Product Update dialog behind of the main form is fixed (T33358)
The Issue with connecting to MySQL server using SSL tunnel is fixed (T32811)
OutOfMemoryException on changing a page in Data Editor is fixed (R3508)
The wrong behavior of the Continue button in the error message appeared during script execution is fixed (R3691)
NullReferenceException on pressing the Enter key in Data Editor after inserting a new record is fixed (T32393)
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)
Wrong order of tables in generated schema script is fixed (R5481)
ArgumentException on editing data in Data Editor is fixed (T33826)
Incorrect editing of dates in Data Editor is fixed (T34205)
NullReferenceException on parsing text in SQL document is fixed (T33582)
DBConcurrencyException on updating records in Data Editor is fixed (T33830)
Issue with restoring closed tool windows is fixed (R5019)
FormatException on showing data after executing a query is fixed (T33985, T33788, T34883)
A Issue with showing the Product update dialog box is fixed (T33358)
Few Issues with showing the foreign key lookup editor in Data Editor are fixed (R5691, R5690)
Inability of editing data on MySQL 4.1.22 is fixed (R6228)
Incorrect behavior with changing color of punctuation in code editor is fixed (T33640)
Incorrect determination of boundaries for the current statement on executing a query in a SQL document is fixed (R5449)
Incorrect showing of schema comparison results is fixed (R6198)
NullReferenceException on filtering data in Data Editor is fixed (T35232, T34698)

2.30.34 23-Jun-11

User-reported bug fixes

NullReferenceException on refreshing data in Data Editor is fixed (T29562)
Incorrect order of objects on generating objects schema is fixed (T29335)
Encoding utf8mb4 is now supported (R890)
Incorrect order of statements in schema synchronization script is fixed (R883)
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)

2.30.32 19-May-11

User-reported bug fixes

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 unresponsable server is fixed (S12782055)
ExternalException on operating clipboard operation in LOB Editor is fixed (T28373)
Incorrect object describing with ANSI server mode is fixed (T28591)
NullReferenceException on showing data in Data Editor is fixed (T28478, T28837)
The Issue with bad handshake on connecting to a server is fixed (T28747)
Application hanging on opening a big SQL file with enormous count of JOIN clauses is fixed (T28716)
Incorrect detection of default table engine on some MySQL server versions is fixed (R124)
InvalidOperationException on synchronizing schema of some procedures is fixed (T28615)
The Issue with connecting to MySQL server through SSL tunnel is fixed (S12831167)
The Issue with connecting to embedded MySQL server is fixed (S12831167)

2.30.31 04-May-11

Database connectivity

Support for MySQL server 5.5<

New features and improvements

Comparison

Options to ignore clauses during the comparison of events added to the Schema Comparison wizard
More informative progress during Schema comparison

Enhanced Data Editor

Server-side sorting and filtering implemented to avoid retrieving all data from the table and enhance work in Paginal Mode
Notifications that inform user about the Data Editor state are added
Option for numbering records added
Copy data with header functionality added

New skins

Four new UI skins added to improve the application appearance.

Other improvements

Enhanced Data Editor
Ability to view internal SQL queries that are sent to the server with parameter's values added
New encodings were added to the encoding list in the Connection Properties dialog

2.20.30 04-Aug-10

New features and improvements

Extended capabilities of Schema Comparison wizard
New comparison options to ignore some table options, DEFINER and SQL SECURITY expressions, default values for columns
New SQL document view layout - now you can see query text and retrieved data at the same time

User-reported bug fixes

T13265 Transport channel is closed
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)
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
CR39462 Missing ignore options for schema comparison
T14848 Generating a redundant synchronization script in Schema Comparison
T15997 MissingMethodException on showing the Code Completion window in the operating system without update pack on Microsoft .NET Framework
CR53501 InvalidOperationException on executing script in SQL document
CR53573 Unavailable documentation in Schema Compare wizard
CR53646 Why the Refresh button is disabled after reopen SQL document?
T20888 NullReferenceException on refreshing data in Data Editor
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

2.0.21 11-Feb-10

New features and improvements

Command-line execution added
Start page for quick access to latest comparison projects was implemented
Option to manage groups of objects in the comparison document
Symbol differences in DDL of compared objects are displayed
Text comparer toolbar was added
Generation of comparison and synchronization reports was implemented
Improved work with Data Editor
A mechanism to renew a server connection after its break was implemented
Customizable product updates check, downloading and installation

1.10.352 28-Aug-09

New features and improvements

HTTP tunneling support added
SSL and SSH connections support added
Schema Compare skips differences between AVG_ROW_LENGTH values (T6118)

1.00.292 204-Jun-09

First release of dbForge Schema Compare for MySQL