dbForge Data Compare for MySQL History

10.0.225 28-Mar-24

User-reported and internal bug fixes

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

Improvement

Added connectivity support for MariaDB 11.4

User-reported and internal bug fixes

Fixed an issue that occurred during the repeated execution of a query in SQL 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
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
Extended support for the INET6 data type, intended for the storage of IPv6 addresses
Added support to hide empty columns from the grid that displays data differences
In case there are NULL to NOT NULL mapped pairs, the synchronization wizard introduces a new page called Issues where you can specify the conflict resolution behavior for potential sync issues
Added support to save the .dcomp 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

5.9.107 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.9.86 17-Aug-23

Connectivity

Added support for MySQL v8.1

User-reported bug fixes

Improved table mapping error diagnostics
Fixed an internal application error in SQL Editor

5.9.27 18-May-23

User-reported bug fixes

Facing parsing errors when performing schema comparison for objects containing specific subqueries (D119561)

5.9.4 19-Apr-23

Connectivity

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

Data Compare

Added support for the UUID Data Type
Added support for the INET6 Data Type

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

Fixed an error that could occur when comparing BIGINT values (D104794, D107548, D112104)
Fixed an error that occurred when closing data comparison documents (D51712)
Fixed an issue with establishing a connection
Fixed an error that occurred when synchronizing MEDIUMTEXT data

5.8.19 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

5.8.7 12-Aug-22

General

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

User-reported bug fixes

Fixed the behavior of the data comparison module
Fixed a column comparison issue that occurred when comparing data (D80383, D86934, D86933)
Fixed an issue that occurred when opening a synchronization script

5.7.635 20-May-22

Improvements

Improved CrossOver compatibility

5.7.629 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 an unexpected exception that occurred after selecting the Use Regular Expression option in the Data Compare Wizard
Fixed an issue in the text editor on Windows builds 22567 and higher

5.7.552 09-Dec-21

User-reported bug fixes

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.7.546 01-Dec-21

User-reported bug fixes

Fixed the incorrect behavior of the "Hide unmodified columns" option in the Data Comparison document
Fixed the behavior of the view editor during detection of syntax errors
Fixed an issue with the repeated execution of a query in Data Editor
Fixed the behavior of change markers in SQL Editor

5.7.502 08-Sep-21

User-reported bug fixes

Fixed a error with displaying a warning about the absence of unique keys in the Data Editor

5.7.478 28-Jul-21

User-reported bug fixes

Minor user reported bugs are fixed

5.7.460 8-Jul-21

User-reported bug fixes

Minor user reported bugs are fixed

5.7.402 22-Apr-21

User-reported bug fixes

Minor user reported bugs are fixed

5.7.348 02-Feb-21

User-reported bug fixes

Minor user reported bugs are fixed

5.7.330 25-Nov-20

Improvements

Work of the application when connecting via SSL is improved

5.7.305 10-Oct-20

User-reported bug fixes

Minor user reported bugs are fixed

5.7.266 17-Aug-20

User-reported bug fixes

Minor user reported bugs are fixed

5.7.232 07-Jul-20

User-reported bug fixes

Minor user reported bugs are fixed

5.7.202 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

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

5.5.36 07-May-19

User-reported bug fixes

Issue with wrong status message is fixed (MYS-2342)
Minor user reported bugs are fixed

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

5.4.38 20-Nov-18

User-reported bug fixes

Issues with connection to MySQL Server are fixed

5.4.37 17-Oct-18

User-reported bug fixes

Several user-reported bugs are fixed

5.4.26 14-Aug-18

User-reported bug fixes

Issue with product freeze is fixed
Issue with NRE is fixed
Issues with lost connection are fixed
Issues with TLS 1.2 connection are fixed

5.4.11 27-Jun-18

Database Connectivity

Support for new servers

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

User-reported bug fixes

Loading assemblies issues are fixed (T254507, T255052, T255749, T257265, T260226)

5.3.21 12-Apr-18

Database Connectivity

MariaDB 10.1
MariaDB 10.2
Google Cloud Platform
Alibaba Cloud
Azure MySQL

Other features and improvements

Support for data conversions allows performing more complete and precise data comparison
Some new Data Comparison Options are added
Improved comparison and synchronization progress

User-reported bug fixes

Different precision for equal columns issue is fixed (T246529)
Application crash issue is fixed (T223708)
Other user reported bugs are fixed (T240885, T241498, T242142, T242595, T236415, T229629, T117849)

5.1.17 09-Jun-17

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

5.1.11 30-Nov-16

User-reported bug fixes

Issues with TIME value in Data Editor and Viewer are fixed
Some Syntax Check and SQL Document issues are fixed

5.1.10 17-Nov-16

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
Other minor fixes and improvements

5.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)

5.0.9 26-Feb-16

Database Connectivity

Support for MySQL 5.7

Support for computed columns
Support for the JSON Data Type

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 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 during data comparison is fixed (T140016)
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

4.3.29 02-Feb-15

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

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

4.2.19 31-Jul-14

Database Connectivity

Windows connection coloring is added

User Interface

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

4.1.13 30-Jan-14

Database Connectivity

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

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
Microsoft Windows 8.1 is supported

User-reported bug fixes

Exception during data comparison (T95027)
MySQL Embedded 5.6 is supported (R29696)
Incorrect filter data on choosing Today value in Data Editor is fixed (R31110)

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

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

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

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

4.0.59 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)
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)
Error on line numbering while grouping data in Data Editor is fixed (R23179)

4.0.43 27-Jun-13

User-reported bug fixes

Issue with editing the 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 on restoring a backup copy with nonexistent users is fixed (R22186)
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)

4.0.34 23-May-13

User-reported bug fixes

Incorrect data synchronization of the Date type is fixed (T70414)
Invalid 'Reset Toolbar Layout' functionality is fixed (R21587)
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)

4.0.18 22-Apr-13

Data Comparison

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

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 for 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 saving of custom mapping in data compare document is fixed (T67743)
The new option for quite mode in command lint is added (T61027)
The Issue with similar names of different objects in comparison data is fixed (T60303)
The Issue with retrieving data from a table with datetime field is fixed (T60213)

3.5.23 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 the Intellisense buttons upon shifting focus from SQL document is added (R9996)

3.5.18 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)
Error report on opening *.dcomp is fixed (R9462)

3.5.17 23-Apr-12

User-reported bug fixes

NullReferenceException with connection in multiple threads is fixed (T35192, T39096)
Issue on data synchronization in TEXT type columns is fixed (T36801)
Issue with out of view columns in comparison document is fixed (T36708)

3.5.11 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 behaviour 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)
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)
NullReferenceException on filtering data in Data Editor is fixed (T35232, T34698)
ExternalException on synchronizing data in Data Compare is fixed (T34878)
Generating reports for data comparison results is supported in the command line interface (T32974)
OutOfMemoryException on generating report in Data Compare is fixed (R4079)
Incorrect behavior on ignoring columns by mask in Data Compare is fixed (R4292)

3.5.9 23-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)
Incorrect warning on comparing data of BIT fields is fixed (R891)
Encoding utf8mb4 is now supported (R890)
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)

3.5.7 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)
The Issue with connecting to MySQL server through SSL tunnel is fixed (S12831167)
The Issue with connecting to embedded MySQL server is fixed (S12831167)

3.5.6 04-May-11

New Extended Data Comparison reports

New Comparison Report wizard
Option for exporting the number of differences per column
Options for exporting actual data records for analysis

Comparison process improvement

More informative progress during Data comparison

Support for MySQL server 5.5

Our product is fully compatible with MySQL server version 5.5

Enhanced Data Editor

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

Server-side sorting and filtering implemented to avoid retrieving all data from the table and enhance work in Paginal Mode
Few indications added to inform user about Data Editor's state
Option for numbering records added
Copy data with header functionality 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
New encodings were added to the encoding list in the Connection Properties dialog

3.00.5 04-Aug-10

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
New SQL document view layout

User-reported bug fixes

T13265 Transport channel is closed
T10434, T10619 IndexOutOfRangeException on comparing data
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
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
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.20 21-Feb-10

Command-line execution added
SQL-filter can be applied to any compared table
Capability to ignore triggers during data synchronization was added
Start page for quick access to latest comparison projects 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

HTTP tunneling support added
SSL and SSH connections support added

1.0.302 23-July-09

First release of dbForge Data Compare for MySQL